Difference between revisions of "Dept. MySQL Server"
Line 5: Line 5:
 
{{messagebox|'''Note 1:'''  The ''[[CS_Database_Class_(315/415/615)_Information|315/415/615 Databases courses]]'' use a completely different MySQL server called ''dbase.cs.jhu.edu.''    If you are taking the Databases class, you will need to get account info and instructions from your TA.|warning}}
 
{{messagebox|'''Note 1:'''  The ''[[CS_Database_Class_(315/415/615)_Information|315/415/615 Databases courses]]'' use a completely different MySQL server called ''dbase.cs.jhu.edu.''    If you are taking the Databases class, you will need to get account info and instructions from your TA.|warning}}
  
−
{{messagebox|'''Note 2:''' You ''do not'' need a CS login account to access the MySQL service on ''mysql.cs.jhu.edu'', nor can you ''ssh'' into mysql.cs.jhu.edu.  Please see below for details.|warning}}
+
{{messagebox|'''Note 2:''' Currently, any CS'er, whether they have a CS Linux account or now, can apply for a MySQL account.  However, that will be changing soon, where only those with CS Linux accounts will be able to apply for a MySQL account.|warning}}
 +
 
 +
{{messagebox|'''Note 3:''' You cannot ''ssh'' into mysql.cs.jhu.edu.  You must connect to the MySQL server using MySQL commands or a MySQL client program, using the MySQL account we would provide you.|warning}}
  
  

Revision as of 22:04, 18 February 2022

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 1: The 315/415/615 Databases courses use a completely different MySQL server called dbase.cs.jhu.edu. If you are taking the Databases class, you will need to get account info and instructions from your TA.

warning

Note 2: Currently, any CS'er, whether they have a CS Linux account or now, can apply for a MySQL account. However, that will be changing soon, where only those with CS Linux accounts will be able to apply for a MySQL account.

warning

Note 3: You cannot ssh into mysql.cs.jhu.edu. You must connect to the MySQL server using MySQL commands or a MySQL client program, using the MySQL account we would provide you.

warning


Once you have your CS Department 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.