MySQL is the general purpose database subsystem provided by the School of Computing (SoC) for student use. Each user is allowed one database. This database is automatically created after requested by a user and is named the same as your SoC systems username. Users can create as many tables as they want but we ask that they keep all databases to a reasonable size.
Requesting a MySQL Account and Database
Any user with a SoC account can request access to the MySQL server running on the cse-linux-01.unl.edu server. Users with legacy CSE server accounts can request access to the MySQL server running on the cse.unl.edu server. To determine if you already have a MySQL account, log in to the SoC Account Management Utility (AMU) page at https://cse.unl.edu/account with your CSE account credentials. Once you log in, click the Account Settings link on the left page. If you have already been granted a MySQL account on one of the SoC servers (cse.unl.edu, cse-linux-01.unl.edu, or nuros.unl.edu) you will see a message indicating on which system(s):
If you do not have any MySQL accounts showing on Account Settings, you will need to send an email to support@cse.unl.edu requesting a MySQL account. If you already have an account on the cse.unl.edu server, you may request a MySQL account on that system, otherwise your MySQL account will be created on the cse-linux-01.unl.edu server.
The MySQL credentials you receive will have a login that matches your CSE server (cse.unl.edu) username, but your password for the MySQL server is completely different from your CSE server password.
Accessing the MySQL server is done by one either logging into the cse.unl.edu server using your CSE username and password, or connecting to the cse.unl.edu server using a TCP/IP connection.
Connecting to MySQL Database
To connect to a MySQL database from the command-line on cse.unl.edu, type mysql -p
and hit enter. The password you will be prompted for will be your MySQL password, which is different from your cse.unl.edu server password. Enter the MySQL password you received in the email message that was sent when you requested your account. You should be presented a MariaDB [(username)]>
prompt from the MySQL application.
To connect to a MySQL database from the command line from another computer with the MySQL command line client installed. Run 'mysql -h cse.unl.edu -u YOUR_CSE_LOGIN -p' and hit enter. Note: the password you will be prompted for will be your MySQL password, which is different from your SoC password. MySQL passwords can be reset using the SoC Account Management Utility page.
TCP/IP connectivity requires authentication using your MySQL credentials and is supported on the standard MySQL service port, 3306, on the CSE server.