Difference between revisions of "Dept. MySQL Server"
 
(5 intermediate revisions by 2 users not shown)
Line 3: Line 3:
 
You will need a [[Obtaining CS MySQL Accounts|CS '''''MySQL''''' account]] for access.   
 
You will need a [[Obtaining CS MySQL Accounts|CS '''''MySQL''''' account]] for access.   
  
−
{{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}}
+
Please read the following '''Notes'''...
  
−
{{messagebox|'''Note 2:''' Only those with [https://support.cs.jhu.edu/wiki/Obtaining_CS_Computer_Accounts CS Linux accounts] will be able to apply for a [https://support.cs.jhu.edu/wiki/Obtaining_CS_MySQL_Accounts MySQL account] for our '''mysql.cs.jhu.edu''' server.|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.|type=info}}
  
−
{{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}}
+
{{messagebox|'''Note 2:''' Only those with [[Obtaining_CS_Computer_Accounts|CS Linux accounts]] will be able to apply for a [[Obtaining_CS_MySQL_Accounts|MySQL account]] for our '''mysql.cs.jhu.edu''' server.|type=info}}
  
−
{{messagebox|'''Note 4:'''  When your MySQL account is created, you will receive a database whose name is the same as your 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.|type=info}}
  
−
{{messagebox|'''Note 5:'''  Later, if you need an ''additional'' database set up at some point for your MySQL account, send an email to [mailto:support@cs.jhu.edu support@cs.jhu.edu] letting us know your MySQL username and the proposed name of your database.|warning}}
+
{{messagebox|'''Note 4:'''  When your MySQL account is created, you will receive a database whose name is ''the same as'' your MySQL account.|type=info}}
 +
 
 +
{{messagebox|'''Note 5:'''  Later, if you need an ''additional'' database set up at some point for your MySQL account, send an email to {{mailto|support}} letting us know your MySQL username and the ''proposed name'' of your database.|type=info}}
  
 
==Connecting to our MySQL server==
 
==Connecting to our MySQL server==
Line 17: Line 19:
 
Once you have your CS Department '''''MySQL''''' account, you can connect to the '''mysql.cs.jhu.edu''' server with:
 
Once you have your CS Department '''''MySQL''''' account, you can connect to the '''mysql.cs.jhu.edu''' server with:
  
−
:<code>mysql -u ''your-mysql-username'' -p -h mysql.cs.jhu.edu</code>
+
<kbd>mysql -u <var>your-mysql-username</var> -p -h mysql.cs.jhu.edu</kbd>
  
 
You will be prompted for your MySQL password.
 
You will be prompted for your MySQL password.
 +
 +
The MySQL server is only accessible from the JHU networks or VPN.
  
 
== Changing Your MySQL Password ==
 
== Changing Your MySQL Password ==

Latest revision as of 12:55, 10 September 2024

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.

Please read the following Notes...

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.

Note 2: Only those with CS Linux accounts will be able to apply for a MySQL account for our mysql.cs.jhu.edu server.

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.

Note 4: When your MySQL account is created, you will receive a database whose name is the same as your MySQL account.

Note 5: Later, if you need an additional database set up at some point for your MySQL account, send an email to support@cs.jhu.edu letting us know your MySQL username and the proposed name of your database.

Connecting to our MySQL server

Once you have your CS Department MySQL account, you can connect to the mysql.cs.jhu.edu server with: 

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

You will be prompted for your MySQL password.

The MySQL server is only accessible from the JHU networks or VPN.

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.