Dept. MySQL Server

Revision as of 18:23, 13 August 2020 by Steve410 (talk | contribs)

The CS Dept has a MySQL server available. Point your MySQL client to mysql.cs.jhu.edu

You will need a CS MySQL account for access.

(Note: The 315/415/615 Databases courses use a completely different MySQL server, dbase.cs.jhu.edu. If you are taking his class, you will need to get account info from your TA.)

Once you have a CS MySQL account, you can connect to the server with:

mysql -u your-mysql-username -p -h mysql.cs.jhu.edu

You will be prompted for your MySQL password.

Changing Your MySQL Password

MySQL passwords are separate from the passwords for our Linux clients; changing your Linux password will not change your MySQL password (and vice versa).

To change your MySQL password, connect to mysql.cs.jhu.edu with a MySQL client, and run the following command:

SET PASSWORD = PASSWORD('your-new-password');

Replace your-new-password with what you want your password to be.

Please be aware that many MySQL clients keep a record of SQL queries. You should clear that record to keep your MySQL password safe. On Linux systems, the command line MySQL client keeps its statement log in ~/.mysql_history; we recommend removing that file after changing your MySQL password. Other clients may store their history in other places.