...
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.
|
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 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 |
---|
language | bash |
---|
theme | Confluence |
---|
linenumbers | true |
---|
| mysql -h studentdb-maria.gl -u '$USER' -p'$PASSWORD' |
Warning |
---|
| 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)- 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'); |
|
excerpt Excerpt |
---|
| 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.
...
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:
...