• News
• SECS
• FAQ

MySQL

Getting a MySQL Account

SECS provides MySQL databases for all SECS students. To use MySQL, your MySQL account must first be activated. To activate your account, go to https://www.secs.oakland.edu/cgi-bin/mysqlacct_req.pl. This page will ask you for your SECS username and password. When provided, it will create a MySQL account for you with the same username and password. There will also be a database created for you with your username.

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. 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.

The other way to use MySQL is from the command line on the SECS webserver. Use Ssh to access www.secs.oakland.edu, and from the command line, type

mysql -p

From there, you can execute any MySQL command you'd like. This is the bare-bones way of interacting with MySQL.

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 help@secs.oakland.edu and let us know that you need your account reset.