The University of Tennessee, Knoxville


Public MySQL Account Maintenance

Note: This site works with Firefox 20+, Safari 5+, Chrome 26+ and IE9+ (compatibility mode off) only.

Use this site to get an account on the OIT public MySQL database server. Anyone with a valid NetID can request use of this service. Once you have an account, you will be able to create one or more databases using this site. That is about all you can do from this web site. For additional management of your database, you should use any of the free open-source tools (e.g., MySQL Workbench , the MySQL command-line tool for unix, or the phpMyAdmin web site).

Login Required

In order to use this site, you must login with your UT NetID and password. Please read the disclaimer at the bottom of the page before proceeding.

Database Server Information

Port: 3306
Default Charset: latin1
Software: MySQL 5.5.62-log

Note about passwords

The password encryption algorithm used by MySQL changed with v4.1. Many older clients cannot decrypt passwords using the new algorithm. If you are having problems logging in with your MySQL credentials, you know your password is correct, and you aren't using an fairly new client, you might want to consider logging back in to this site and resetting your password using the old algorithm.

Note on using PhpMyAdmin

The web site runs with no special privileges. If you want to use phpMyAdmin to help manage your MySQL databases, you must grant the phpMyAdmin web host (currently IP address access to your user accounts and databases.

Note about WordPress

Beginning April 2, 2018, OIT scans web sites and automatically removes WordPress plug-ins that have been determined to negatively impact the performance, security and/or reliability of the web server. The complete list of plug-ins that currently fall in this category can be found at


OIT provides a MySQL database service for customers who need a MySQL database. OIT performs normal hardware and operating system administration on those servers, including backups and account management. For assist­ance using MySQL, please submit a ticket via the OIT Helpdesk. Depending on the nature of the assistance needed OIT's Service Level Manager may contact you to discuss your needs.

If you find that the public-service MySQL offering does not meet your needs for enterprise use, please contact the OIT Helpdesk to setup a conversation with the OIT Associate CIO. The ACIO can discuss supported full-service alternatives to this public timeshare offering.

Please Note: The service may not be used to store sensitive data (e.g., HIPAA, FERPA, PCI, etc.), nor shall it be used to store data needed by high profile applications.



The MySQL database service is a free offering made available, as is, for those with MySQL database exper­ience. Traditional hardware and operating system administration, plus backup and account management will be provided for the central service; but at the present time, end‐user support for this service, which includes, but is not limited to, support for database design and development, application integration, debugging support and support for general use of your MySQL database, will not be provided.

Faculty and staff who want higher levels of support should contact the OIT Associate CIO for their campus and request information about the supported database services, such as MSSQL or Oracle.

Please note: The MySQL service should not be considered suitable for enterprise use. The service may not be used to store sensitive data (e.g., HIPAA, FERPA, PCI, etc.), nor should it be used to store data needed by high profile applications.


The University of Tennessee, Knoxville. Big Orange. Big Ideas.

Knoxville, Tennessee 37996 | 865-974-1000
The flagship campus of the University of Tennessee System