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.

Print Article