How can I signup my personal or group locker for the MySQL service?
If your group does not already have a locker, start by mailing accounts@mit.edu to get one.
Individuals or groups that have lockers can easily register for a MySQL account at an Athena prompt:
athena$ add scripts
athena$ signup-sql
Individuals wishing to register an account for themselves should select option #1 at the first prompt. To register an account for a group, select option #2 at the first prompt.
You may get an error message that says The MySQL login information in your .my.cnf file appears to be incorrect.
If this happens, you will need to manually set your MySQL password. Go to sql.mit.edu and log in via your MIT certificate. Click Account and create a new MySQL password. Your MySQL password should be different from your Athena account password. Copy this password into the .my.cnf file in your Athena home directory after the password=
. Your MySQL account should then work correctly.
If you do not get an error when running signup-sql
, you can then read your password from /mit/locker/.sql/my.cnf. You can use this to log in to sql.mit.edu under the “SQL Password” option. You will need to create and drop databases from sql.mit.edu, but you can do all other operations from any MySQL client. We recommend using phpMyAdmin.
Previous: | How do I do certificate authentication with Django? |
Next: | How can I access my MySQL databases? |
These pages may be reused under either the GFDL 1.2 or CC-BY-SA 3.0.
Questions? Contact scripts@mit.edu.
You are currently connected to whole-enchilada.mit.edu.