Public MySQL Account Maintenance




Sign in below with your NetID and password to set up and manage your account on the OIT public MySQL database servers. Once you have an account, you will be able to create one or more databases using this 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 Linux, 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 under General Information/Support before proceeding.


Database Servers Information



Legacy Server (Deprecated)

Host: mysql.utk.edu
Port: 3306
Default Charset: latin1
SSL: DISABLED
Software: MariaDB 10.3.17
Server O/S: RHEL 8.2
Note: This server is currently in the process of being phased out. No new accounts or databases may be created on this server, but you may continue to manage your existing content.

Public LAMP MySQL #1

Host: gaslamp.oit.utk.edu
Port: 3306
Default Charset: latin1
SSL: DISABLED
Software: MariaDB 5.5.64
Server O/S: RHEL 7.8
Note: This host is running the apache web server and the MariaDB (open-source) implementation of MySQL. You may only make MySQL connections from web application running on this server, and you must use 127.0.0.1 as the MySQL hostname. All code must be accessed from the Linux public access hosts,linux.oit.utk.edu or linux2.oit.utk.edu

Public LAMP MySQL #2

Host: butane.oit.utk.edu
Port: 3306
Default Charset: latin1
SSL: DISABLED
Software: MariaDB 5.5.64
Server O/S: RHEL 7.8
Note: This host is running the apache web server and the MariaDB (open-source) implementation of MySQL. You may only make MySQL connections from web application running on this server, and you must use 127.0.0.1 as the MySQL hostname. All code must be accessed from the Linux public access hosts,linux.oit.utk.edu or linux2.oit.utk.edu

Public LAMP MySQL Cluster for Software Collections

Hosts: mariadbx0.oit.utk.edu, mariadbx1.oit.utk.edu, mariadbx2.oit.utk.edu
Port: 3306
Default Charset: latin1
SSL: DISABLED
Software: MariaDB 10.2.22
Server O/S: RHEL 7.8 with Software Collections
Note: Content on any host in this cluster is automatically and synchronously replicated to the others, in order to provide higher availability than available on previous servers. You may only connect to these hosts from web application code running on the Software Collections Public LAMP hosts, scllampx0.oit.utk.edu and scllampx1.oit.utk.edu, and you must use 127.0.0.1 for the hostname. The software collections LAMP hosts are running haproxy to forward local connections to the LAMP MySQL cluster. As with the Public LAMP MySQL hosts not running software collections, all code must be accessed from linux.oit.utk.edu or linux2.oit.utk.edu

Computational Cluster

Hosts: mariadb-compx0.oit.utk.edu, mariadb-compx1.oit.utk.edu, mariadb-compx2.oit.utk.edu
Port: 3306
Default Charset: latin1
SSL: DISABLED
Software: MariaDB 10.3.17
Server O/S: RHEL 8.2
Note: You may only connect to these hosts from any UTK address, and may do so using any of the cluster addresses: mariadb-compx0.oit.utk.edu, mariadb-compx1.oit.utk.edu, or mariadb-compx2.oit.utk.edu. In order to preserve quality of service for public LAMP, all MySQL for research and coursework must be performed on the computational cluster. Failure to observe this rule may result in loss of access without warning.


 

General Information



Note on using PhpMyAdmin

The phpmyadmin.utk.edu 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 (current IP address is 160.36.239.192) 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 in our Knowledge Base.

Note about Support for MySQL

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.

In order to preserve quality of service for public LAMP, all MySQL for research and coursework must be performed on the computational cluster. All other MySQL servers should only be used for web content. Failure to observe this rule may result in loss of access without warning.