Difference between revisions of "CS Database Class (315/415/615) MySQL Information"

Line 3: Line 3:
 
This dbase.cs.jhu.edu MySQL server ''is for the Database class only''.  It is '''''not''''' the same as the [[Dept. MySQL Server|MySQL server available to the entire department (mysql.cs.jhu.edu)]].
 
This dbase.cs.jhu.edu MySQL server ''is for the Database class only''.  It is '''''not''''' the same as the [[Dept. MySQL Server|MySQL server available to the entire department (mysql.cs.jhu.edu)]].
  
Although the CS IT group maintains the physical dbase.cs.jhu.edu server and its operating system, The Databases course's  Teaching Assistant (TA) maintains the ''MySQL accounts'' for dbase.cs.jhu.edu
+
Although the CS IT group maintains the physical dbase.cs.jhu.edu server and its operating system, the Databases course's  Teaching Assistant (TA) maintains the ''MySQL accounts'' for dbase.cs.jhu.edu
  
 
Therefore, ''all MySQL account-related/access-related issues and questions for dbase.cs.jhu.edu'' should go to the TA for the course, as that's the person responsible for creating those MySQL accounts.
 
Therefore, ''all MySQL account-related/access-related issues and questions for dbase.cs.jhu.edu'' should go to the TA for the course, as that's the person responsible for creating those MySQL accounts.

Revision as of 18:51, 13 August 2020

As part of the CS Database Class (for CS315, CS415, and/or CS615), your instructor might have you utilize a special MySQL server called dbase.cs.jhu.edu.

This dbase.cs.jhu.edu MySQL server is for the Database class only. It is not the same as the MySQL server available to the entire department (mysql.cs.jhu.edu).

Although the CS IT group maintains the physical dbase.cs.jhu.edu server and its operating system, the Databases course's Teaching Assistant (TA) maintains the MySQL accounts for dbase.cs.jhu.edu

Therefore, all MySQL account-related/access-related issues and questions for dbase.cs.jhu.edu should go to the TA for the course, as that's the person responsible for creating those MySQL accounts.

NOTES

  • Your CS Linux account (Grad/Ugrad) is not the same as a CS MySQL-related account, even if the usernames are the same. Our Linux accounts and our MySQL accounts are two separate types of accounts.
  • You cannot ssh into dbase.cs.jhu.edu. The only connection you have to dbase.cs.jhu.edu is remotely, via a MySQL client.
  • From the CS Department Linux clients, you can use the text-based MySQL client by running mysql -h dbase.cs.jhu.edu -u account -p database , where "account" is your dbase.cs.jhu.edu account name and "database" is the name of your database. You will be prompted to enter your password.
  • You can access dbase.cs.jhu.edu with any MySQL client, either text-based or GUI, from any computer on the JHU network, JHU's wireless network (but not JHGuestnet), or VPN. Just use "dbase.cs.jhu.edu" as the hostname. If asked for a network port, use "3306".