University of Virginia

MySQL Self Service

University of Virginia MySQL Self Service

No Sensitive Data Allowed

This service does not have the necessary security for storing HIPAA, FERPA, or other sensitive data.

Logging In

phpMyAdmin requires you to log in with a MySQL account name and password. All of the other options require you to log in with NetBadge (using your UVA computing id and password, or certificate).

Logging Out

Protect your identity and privacy. Completely exit your web browser when you are finished.

When you log in your web browser saves credentials that give you continued access without re-entering your password. If you leave your computer unattended then someone else can use it to access web services using your credentials without entering your user name and password. The phpMyAdmin log out link does not delete your saved MySQL password. You must still exit your browser.

Disk Quotas

The disk usage of a MySQL account is the total disk space occupied by all of its databases. Each MySQL account has a soft disk quota (default 50 Mbytes) and a hard disk quota (default 100 Mbytes). If the disk usage is over the soft quota then a weekly job sends an email notification to the contact address for the account. If the disk usage is over the hard quota then a nightly job suspends the account, which prevents logins. You can use the Un-Suspend MySQL Account option to un-suspend an account and clean up its databases.

You can use the Request Disk Quota Change option to request a larger disk quota.

Getting Started

If you do not have any MySQL accounts or databases on this server, then do the following:

  1. Create a MySQL account.
  2. Create a database.
  3. Create tables in your database with phpMyAdmin, or follow the installation instructions for your web site software package.

To access your databases, the MySQL server host name is Log in with your MySQL account name and password.

Account and Database Cleanup

Please delete any databases and MySQL accounts when you are finished with them. After two months we will automatically delete any empty databases and any accounts that have no databases. Two months after each semester we will delete any accounts and databases where all of the owners have left the University.

If you have a database that should not be deleted after you leave the University, then please pass it on to someone else.

Self Service Options

Administer Databases with phpMyAdmin

Log in to phpMyAdmin with a MySQL account name and password. Use phpMyAdmin to administer your existing databases. (See Create Database to create a new database.)

If you logged in to phpMyAdmin earlier in this browser session and you now want to log in using a different MySQL account name and password, then you should completely exit your browser first. Otherwise your browser may automatically log you in to phpMyAdmin using the previous MySQL account name and password.

MySQL Account and Database Status
Displays the status of your MySQL accounts and databases. Shows disk space used, active connections, disk quotas, and contact email addresses. Indicates if an account is suspended or if a database has public read enabled.
MySQL Server Status
Displays all active connections on the MySQL server and all suspended accounts. Useful for troubleshooting.
Create MySQL Account
Create a new MySQL Account. You may create a personal account for yourself or a group account for a MyGroups group. If using MyGroups, then the group name may not exceed 16 characters, and may not match a UVa Computing Id such as mst3k. If you have recently created a new MyGroups group, then wait at least half an hour for the group information to propagate to this server.
Change MySQL Account Password
Change the password for a MySQL account. You may also choose old or new password security style. Remember to update any web sites that log in to this MySQL account.
Change MySQL Account Email Address
Change the contact email address for a MySQL account. This email address receives notifications regarding the status of the account, such as if the disk quota is exceeded. You cannot change the contact email for a personal account. For a group account you may use either your own personal email address or the email address of the entire group. If a different member of the group should be the contact, then that person must set the email address.
Un-Suspend MySQL Account

If an account is over its hard disk quota, then a nightly job suspends it, which prevents logins. Use this option to un-suspend the account so that you can log in and clean up its databases.

Dropping (deleting) a database frees the disk space occupied by the database. Dropping or truncating a database table frees the disk space occupied by the table. By itself, deleting rows from a table does not free any disk space. To free disk space occupied by deleted rows, you can optimize the table with phpMyAdmin, or you can run the MySQL command:  OPTIMIZE TABLE tablename (where tablename is the name of the table). If you need to increase your disk quota, then use the Request Disk Quota Change option.

Request Disk Quota Change
Send an email request to change the disk quota for a MySQL account. You may request up to 250 Mbytes soft disk quota at no charge. Beyond that you must lease enterprise-grade disk storage with backup.
Delete MySQL Account
You may not delete a MySQL account if it still has any databases. See the Drop Database option to delete the databases.
Create Database
Create a new MySQL database. The name of the database may not exceed 64 characters and it may contain only letters, digits, or underscores ('_'). (You cannot create databases with phpMyAdmin on this server.)
Drop Database
Drop (delete) a MySQL database. ITS retains a small number of database backups for up to one year. We highly recommend that you use phpMyAdmin to create your own backup copy before dropping the database. (You cannot drop databases with phpMyAdmin on this server.)
Restore Database
Restore a MySQL database from backup. Databases are backed up every day at around 3:15 AM. You can restore a database from a recent backup copy that exists on this MySQL server. ITS also retains a few database backups for up to one year.
Change Owner of Database
Change Owner of a MySQL database. If you have more than one MySQL account, then you can change the account that owns a database.
Enable Database Public Read
Grant read only (select only) access on a database to the publicread MySQL account. No password is required to log in to publicread. Web sites that do not need to modify the database may access the database with the publicread account to protect the MySQL account and password of the database owner.
Disable Database Public Read
Revoke all access on a database from the publicread MySQL account.

Administrator Options

The following options are for administrators only.

MySQL Account and Database Summary
Show a summary of selected MySQL accounts and databases.
Change Disk Quota
Change the disk quota for a MySQL account. (May also un-suspend the account.)
Change Owner of Database
Change the MySQL account that owns a database.
Archive Account
For each database owned by the account, save the latest backup and drop the database. Also delete the account.