The CAT offers PostgreSQL and MySQL databases. Any faculty, staff, or student with an MCECS account is eligible for database access. Currently we are running MySQL 5.5.4 and PostgreSQL 9.3.6. These database accounts are self-managed. If you have any questions or need assistance for a database class (CS 486/586), reach out to your TA or Professor.
How to get a new PostgreSQL or MySQL account
To get an account, you may either visit the CAT office in FAB 82-01 with your student ID, send us an email, or contact us through online chat. Ask for either a PostgreSQL or a MySQL account (or both, if you’d like). These two types of databases are different, so be sure to research which type of database will meet your needs.
Your username and the name of your database will be your MCECS username. This cannot be changed. However, you will be able to change the password used for logging in to your new database.
NOTE: This password will be DIFFERENT from your normal MCECS password. Also remember that passwords for your MySQL and PostgreSQL access (if you have both), will be different from each other.
Once your new database account has been requested and processed by the CAT, you may activate it and change your password through the CECS Remote Account Manager (CRAM) tool.
How to access your PostgreSQL and MySQL databases
- If you forget your password, please visit the CAT office in FAB 82-01 with photo ID and ask for a MySQL or PostgreSQL password reset.
- Please use caution if you put your password in any scripts. If you do, make sure your file is as secure as possible. Carefully select your file permissions, using the “chmod” command to make changes.
- Database backups occur nightly. If you need a restore send an email to firstname.lastname@example.org. Be sure to include your username and information about what happened. Please include which table you need restored, or if you need your whole database restored.