Info |
---|
- This FAQ only applies to DoIT's StudentDB MySQL/MariaDB server. If you're connecting to another server, see your professor for the appropriate instructions.
|
Connecting to StudentDB-Maria
Excerpt |
---|
Anchor |
---|
| Connecting from the Command Line |
---|
| Connecting from the Command Line |
---|
| From GLFrom a command line shell to linux.gl.umbc.edu: Type the following command, where $USER is replaced with your myUMBC username in lowercase: Code Block |
---|
language | bash |
---|
theme | Confluence |
---|
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). |
Enter your assigned MariaDB password at the prompt. 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)- Open a web browser and navigate to http://mysql-admin.umbc.edu/
- 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.
|
Changing your SQL password
Excerpt |
---|
Anchor |
---|
| Changing password from Command Line |
---|
| Changing password from Command Line |
---|
| From GLFrom a command line shell to linux.gl.umbc.edu: - Connect to MariaDB (see Connecting to StudentDB-Maria > From GL)
Type the following command, where $PASSWORD is replaced with the password you'd like to use: Code Block |
---|
language | sql |
---|
theme | Confluence |
---|
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: - Click the 'SQL' tab.
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 |
---|
title | Set Password |
---|
linenumbers | true |
---|
| SET PASSWORD = PASSWORD('$PASSWORD'); |
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:
- Username
- The server you are trying to connect to / what commands you are using to connect.
- Which class you are in