Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info
  • 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
Connecting
Connecting to StudentDB-Maria

Excerpt

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
    languagebash
    themeConfluence
    linenumberstrue
    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.

    Note
Note: if
  1. 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.

OR

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

Code Block
languagebash
themeConfluence
linenumberstrue
mysql -h studentdb-maria.gl -u '$USER' -p'$PASSWORD'
Warning
titleHeads 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).

...


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.

Anchor
Password
Password
Changing your SQL password 

Excerpt

Anchor
Changing password from Command Line
Changing password from Command Line
From GL

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

  1. Connect to MariaDB (see Connecting to StudentDB-Maria > From GL)
  2. Type the following command, where $PASSWORD is replaced with the password you'd like to use:

    Code Block
    languagesql
    themeConfluence
    titleSet Password
    linenumberstrue
    SET PASSWORD = PASSWORD('$PASSWORD');

 

excerptFrom 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.
Excerpt

Anchor

Connecting from phpMyAdminConnecting from phpMyAdmin

...

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
    languagesql
    themeConfluence
    titleSet Password
    linenumberstrue
    SET PASSWORD = PASSWORD('$PASSWORD');


  3. Then Click 'Go' to reset your password


 

...



Requesting a Password Reset / I forgot my password

If you have forgotten your password, please submit an RT Ticket with the following information and someone will assist you:

...