Difference between revisions of "Dept. MySQL Server"
(17 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. | ||
− | + | Please read the following '''Notes'''... | |
− | Once you have | + | {{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 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 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 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== | ||
+ | |||
+ | 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> | :<code>mysql -u ''your-mysql-username'' -p -h mysql.cs.jhu.edu</code> |
Latest revision as of 19:00, 16 May 2023
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...
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.
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.