phpMyAdmin: Manage MySQL Databases

Overview

phpMyAdmin is a PHP-based open-sourced tool to manage MySQL databases from the web. While the OIT-provided website is geared for the initial setup and creation of databases only, phpMyAdmin is a full-function site for managing your existing databases.

OIT has installed a copy of phpMyAdmin at http://phpmyadmin.utk.edu

• Log in with your MySQL username and password. 
  • Note: Do not use your NetID/password

*Complete information on using phpMyAdmin can be found at http://www.phpmyadmin.net

Manage Your Databases

Just as with logging in, phpMyAdmin runs without special privileges. You must grant your account on the phpMyAdmin server access to your databases:

1. Navigate to: https://setupmysql.utk.edu
2. Select Login
3. Enter your NetID and password
4. Select a database name (only one at a time)
5. Select Grant Privileges under Commands
6. Enter your NetID
7. Enter hostname: 160.36.178.132
8. Check all the privileges you wish to allow from phpMyAdmin
9. Select Grant

Repeat steps 4 - 9 for each database you wish to access from phpMyAdmin.