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

(Created page with "Dr. David Yarowsky teaches a Databases course for CS. As part of the course, he might have his students utilize a special MySQL server called '''dbase.cs.jhu.edu'''. This db...")
 
 
(44 intermediate revisions by 3 users not shown)
Line 1: Line 1:
−
Dr. David Yarowsky teaches a Databases course for CS.  As part of the course, he might have his students utilize a special MySQL server called '''dbase.cs.jhu.edu'''.
+
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 Dr. Yarowsky's class only''.  It is '''''not''''' the same as the [https://support.cs.jhu.edu/wiki/Dept._MySQL_Server mysql.cs.jhu.edu MySQL server available to the entire department]. 
 
  
 +
{{messagebox|'''Note 1:'''  This ''dbase.cs.jhu.edu'' MySQL server ''is for the Databases class only''.  It is '''''not''''' the same as the [[Dept. MySQL Server|MySQL server available to the entire department (''mysql.cs.jhu.edu'')]].|type=info}}
  
−
Although the CS IT group maintains the physical dbase.cs.jhu.edu server and its operating system, Dr. Yarowsky's Teaching Assistant (TA) maintains the ''MySQL accounts'' for dbase.cs.jhu.edu
+
{{messagebox|'''Note 2 :'''  You ''do not'' need a CS login account to access the MySQL service on ''dbase.cs.jhu.edu'', nor can you ''ssh'' into dbase.cs.jhu.edu.  Instead, you will need a ''MySQL'' account.  Please see below for details.|type=info}}
  
−
Therefore, ''all MySQL account-related/access-related issues for dbase.cs.jhu.edu'' should go to the TA for the course, as that's the person responsible for creating those MySQL accounts.
+
{{messagebox|'''Note 3:''' Access to the MySQL service on dbase.cs.jhu.edu is '''limited to those on a JHU-Network-based computer, including Hopkins WiFi (except JHGuesnet) or on the [[VPN_-_JHU | VPN]].'''|type=info}}
  
−
'''Note:'''  Your CS Linux account (Grad/Ugrad) is '''not''' the same as a CS MySQL account, even if the usernames are the same.  Our Linux accounts and our MySQL accounts are two different sets of accounts. 
+
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''' or the '''CA''' for the course, as that's the person '''responsible for creating those MySQL accounts.'''
 +
 +
==IMPORTANT INFO ABOUT ACCESSING THE MYSQL SERVICE ON dbase.cs.jhu.edu==
 +
 +
* Access to the MySQL service on dbase.cs.jhu.edu is '''limited to those on a JHU-Network-based computer, including Hopkins WiFi (except JHGuesnet) or on the [[VPN_-_JHU | VPN]].'''
 +
 +
*  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 way you can connect to dbase.cs.jhu.edu is remotely, via a ''MySQL client''.
 +
 +
* If you '''already have a CS ''login'' (ssh) account''' for any of our [[:Category:Linux Clients|CS Department Linux clients]], you can log into one of those Linux systems and use its text-based MySQL client by running <kbd>mysql -h dbase.cs.jhu.edu -u <var>account</var> -p <var>database</var></kbd> , where "<var>account</var>" is your dbase.cs.jhu.edu account name and "<var>database</var>" is the name of your database.  You will be prompted to enter your password.
 +
 +
* If you '''do not have a CS ''login'' (ssh) account ''' ''(you '''do not''' need one to access our MySQL service on dbase.cs.jhu.edu''), you can access dbase.cs.jhu.edu with any MySQL client, either text-based or GUI, and, as mentioned before, '''''from any computer on the JHU network, [[Wireless_Networking | JHU's wireless network]] (but not JHGuestnet), or [[VPN_-_JHU | VPN]].'''''  Just use "dbase.cs.jhu.edu" as the hostname.  If asked for a network port, use "3306".  MySQL clients are available for Linux, Mac, and Windows systems.
 
[[Category:MySQL]]
 
[[Category:MySQL]]

Latest revision as of 13:09, 10 September 2024

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.


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

Note 2 : You do not need a CS login account to access the MySQL service on dbase.cs.jhu.edu, nor can you ssh into dbase.cs.jhu.edu. Instead, you will need a MySQL account. Please see below for details.

Note 3: Access to the MySQL service on dbase.cs.jhu.edu is limited to those on a JHU-Network-based computer, including Hopkins WiFi (except JHGuesnet) or on the VPN.

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 or the CA for the course, as that's the person responsible for creating those MySQL accounts.

IMPORTANT INFO ABOUT ACCESSING THE MYSQL SERVICE ON dbase.cs.jhu.edu

  • Access to the MySQL service on dbase.cs.jhu.edu is limited to those on a JHU-Network-based computer, including Hopkins WiFi (except JHGuesnet) or on the VPN.
  • 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 way you can connect to dbase.cs.jhu.edu is remotely, via a MySQL client.
  • If you already have a CS login (ssh) account for any of our CS Department Linux clients, you can log into one of those Linux systems and use its 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.
  • If you do not have a CS login (ssh) account (you do not need one to access our MySQL service on dbase.cs.jhu.edu), you can access dbase.cs.jhu.edu with any MySQL client, either text-based or GUI, and, as mentioned before, 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". MySQL clients are available for Linux, Mac, and Windows systems.