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 8 and PostgreSQL 16. 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 request a PostgreSQL or MySQL account (or both), visit the CAT office in FAB 82-01 with your student ID, send us an email, or contact us via online chat. Please research which database type best fits your project before reaching out.
- If you need a custom database name for a group project, include that detail in your request.
Note: Research which database system fits your project requirements before requesting
- Database Name & Username: Set to your default MCECS username.
- Separate Passwords: Your database password is completely separate from your main MCECS password. Additionally, MySQL and PostgreSQL accounts use different passwords from one another.
- Retrieving Your Password: Once CAT processes your request, retrieve your initial password using the CECS Remote Account Manager (CRAM) tool.
- Changing Your Password: Refer to the MySQL and PostgreSQL instruction sections below.
How to access your PostgreSQL and MySQL databases
Additional Help
- 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 support@cat.pdx.edu. 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.