MySQL

Getting a MySQL Account

You can get MySQL Account by emailing a request to secs@oakland.edu

Using your MySQL Account

The easiest way to start working with MySQL is to use the SECS PHPMyAdmin site at https://www.secs.oakland.edu/phpmyadmin (Requires VPN access from off campus). From this site you can work with your database's schema and data. It also allows you to execute SQL commands and other advanced features. For more information go to http://www.phpmyadmin.net/documentation/#faqusing.

Changing your MySQL Password

To change your MySQL password, you need to use the following MySQL command:

set password = password('mynewpassword');

substituting 'mynewpassword' with what you want your password to be (make sure to leave the single-quotes.)

You can type this either at the MySQL command prompt (see above), or from PHPMyAdmin, by clicking the SQL icon on the top-left and executing a query directly.

I Forgot my password

There is no automated system yet for resetting MySQL passwords. In the meantime, send an email to secs@oakland.edu and let us know that you need your account reset.