• This FAQ only applies to the DoIT's StudentDB MySQL/MariaDB StudentDBserver. If you're connecting to another server, see your professor for the appropriate instructions.

Anchor
Connecting from the Command Line Connecting from the Command Line

From GL

From a command line shell to linux.gl.umbc.edu:

1. Type the following command, where $USER is replaced with your myUMBC username in lowercase:

   Code Block
   language bash theme Confluence language bash linenumbers true
   mysql -h studentdb-maria.gl -u '$USER' -p

   
   

   Note
   Your username is the first part of your email address, not your campus ID (e.g. AB12345).

   
   

2. Enter your assigned MariaDB password at the prompt.

OR

1. Type the following command, where $USER is replaced with your myUMBC username and $PASSWORD is replaced with your assigned MariaDB password:

   Code Block
   theme Confluence language bash linenumbers true
   mysql -h studentdb-maria.gl -u '$USER' -p'$PASSWORD'

   Warning
   title Heads Up!
   If you do not use single quotes around your password and it contains a dollar sign or other special characters, then you may not be able to log in (see http://tldp.org/LDP/abs/html/quoting.html for details on shell expansion).

1. Note
   If you are logging in for the first time, your default password is your username. You are advised to change your password after logging in for the first time.

   
   

Anchor
Connecting from phpMyAdmin Connecting from phpMyAdmin

From a web browser (phpMyAdmin)

1. Open a web browser and navigate to http://mysql-admin.umbc.edu/
2. Enter your MariaDB username and password and make sure to select studentdb-maria.gl.umbc.edu from the Server Choice drop down menu.
   Note: if you are logging in for the first time, your default password is your username. You are advised to change your password after logging in for the first time.

1. title Set Password linenumbers true

   SET PASSWORD = PASSWORD('$PASSWORD');

Anchor
Changing password from a web browser Changing password from a web browser

From a web browser (phpMyAdmin)

From phpMyAdmin:

1. Click the 'SQL' tab.

2. Type the following command, where $PASSWORD is replaced with the password you'd like to use, and hit Go:

   Code Block
   language sql theme Confluence

1. title Set Password linenumbers true

   SET PASSWORD = PASSWORD('$PASSWORD');

1. 
   

2. Then Click 'Go' to reset your password

Image Added