Database

We use MySQL built on top of MariaDB for all our databases. To get into the database you'll need to get the username and password from CommonKey. This goes for any applications database you want to make changes to (there is a user for each).

The url will differ depending on which environment you are in. (sga.dev.it.marist.edu or sga.marist.edu) we usually don't make changes on sga.staging.it.marist.edu because that is the same as sga.marist.edu.

1. Go to sga.marist.edu/mysqladmin or sga.dev.it.marist.edu/mysqladmin
2. Enter in the credentials you got from common key
3. Then you're in!

Additionally you can get into the database through the command line.

1. SSH onto the server (see Server Guide)
2. Get into the DB

mysql -u USERNAME -p and enter in the password

Starting, stopping, and status

Status of the mysql server

sudo systemctl status mysql

Restart the db server

sudo systemctl restart mysql

Stop the db server

sudo systemctl stop mysql

Start the db server

sudo systemctl start mysql