CS department server login

You have a MySQL account during the semester you are taking CS 85 or CS 331 or CS 355.

• Username (all lowercase): First 2 letters of your last name, followed by first 2 letters of first name, followed by last 4 digits of CUNYfirst ID. If your name is John Doe an d your CUNYfirst ID is 12345678, then your username is dojo5678
• Password: Your 8 digits of CUNYfirst ID#

Logging onto MySQL account from your linux account

• mariadb -u your_username -p
• Press Enter
• Enter your_password
• At MariaDB [(none)]> prompt, type
  use your_schema; (your_schema name is same as your username)

Logging onto MySQL account using a MySQL client application from your computer

• Download and Install DBeaver Community.
• Create a New Connection (MariaDB)
  Enter mars.cs.qc.cuny.edu in the box labeled Server Host:
  Enter your_username in the box labeled Database:
  Enter your_username in the box labeled Username:
  Click Test Connection to confirm the settings are good
  Click OK
  

Connect MySQL database with Python

• Install python module pymysql or mysql-connector-python or mysql-connector in your computer

Changing your MySQL password

• At MariaDB[your_schema] prompt, type
  set password = password("your new password");