CS Database Class (315/415/615) MySQL Information - Revision history

Steve410 at 13:09, 10 September 2024

2024-09-10T13:09:09Z

Steve410 at 13:08, 10 September 2024

2024-09-10T13:08:21Z

Steve410: /* IMPORTANT INFO ABOUT ACCESSING THE MYSQL SERVICE ON dbase.cs.jhu.edu */

2024-09-10T13:06:14Z

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

Steve410: /* IMPORTANT INFO ABOUT ACCESSING THE MYSQL SERVICE ON dbase.cs.jhu.edu */

2024-09-10T13:05:19Z

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

Phil at 19:01, 16 May 2023

2023-05-16T19:01:46Z

Steve410 at 12:57, 10 October 2022

2022-10-10T12:57:26Z

Steve410 at 19:33, 21 April 2022

2022-04-21T19:33:01Z

Steve410 at 19:32, 21 April 2022

2022-04-21T19:32:10Z

Steve410 at 19:31, 21 April 2022

2022-04-21T19:31:54Z

Steve410 at 19:31, 21 April 2022

2022-04-21T19:31:01Z

← Older revision		Revision as of 13:09, 10 September 2024
Line 1:		Line 1:
	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''.		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''.
−
−	{{messagebox\|'''Note 1:''' 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]].'''

@@ Line 1: / Line 1: @@
 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''.
 {{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}}
 {{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}}
 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'''

@@ Line 11: / Line 11: @@
 ==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 or on the JHU VPN.''
+* 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.

@@ Line 10: / Line 10: @@
 ==IMPORTANT INFO ABOUT ACCESSING THE MYSQL SERVICE ON dbase.cs.jhu.edu==
 *  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.
@@ Line 17: / Line 19: @@
 * 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, 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.
+* 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]]

@@ Line 1: / Line 1: @@
 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''.
-{{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'')]].|warning}}
+{{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}}
-{{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.|warning}}
+{{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}}
 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'''

@@ Line 5: / Line 5: @@
 {{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.|warning}}
-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''' or the '''CA''' for the course, as that's the person '''responsible for creating those MySQL accounts.'''

@@ Line 15: / Line 15: @@
 * '''''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'' 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 '''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 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, 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]]