Managing Your Database Using phpMyAdmin
phpMyAdmin is a tool written in PHP to handle the administration of MySQL over the web. Databases must be created in cPanel or Plesk, but phpMyAdmin can drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, and export data into various formats.
Login to cPanel and click the phpMyAdmin icon in the Databases section.
See the directions on how to access Webadmin. The Webadmin icon takes you to phpMyAdmin for MySQL databases.
Note: You can only access phpMyAdmin from within cPanel or Plesk. The icon in cPanel says phpMyAdmin and the icon in Plesk says Webadmin.
Root WHM on a VPS or Dedicated Server
Users with root access to WHM on a VPS or Dedicated Server may also access phpMyAdmin from root WHM by going to WHM > SQL Services > phpMyAdmin to gain access to every database on the server.
How to Manage a MySQL Database using phpMyAdmin
Managing your mySQL database is a snap using phpMyAdmin, a powerful user interface that is accessed via your HostGator cPanel. This video shows you how to access your databases create and delete tables, update records, and even import a MySQL file into a database.
This video shows how to access phpMyAdmin via cPanel, and may look slightly different if you have a different cPanel style (theme). Plesk users can access phpMyAdmin by following the directions on how to access Webadmin. For MySQL databases in Plesk, clicking the Webadmin icon opens phpMyAdmin. Once inside phpMyAdmin, most of the functionality is the same.
Common Errors (cPanel):
By default, owners logged into WHM cannot access a database through a dependent cPanel's phpMyAdmin. You will get this error:
"This feature is not available while logged in with root override. You are logged in with the root, or reseller's password. Please login with this user's account password"
To resolve this, you will need to log out of root, and log into the individual cPanel in order to access a database via phpMyAdmin.
Note: Root WHM users can use a 'root' phpMyAdmin (WHM > MySQL > phpMyAdmin) that will access all databases on your server.
When you try to enter your phpMyAdmin (cPanel > MySQL > phpMyAdmin) you might be greeted by this error:
#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)
Please contact us via phone or live chat so we can restart MySQL.
Tables missing. No tables found in the database!
Be sure that the target database does have tables. Tables manually generated with the MySQL Databases section of the cPanel are empty - they are created with no tables.
If you are attempting to import information into a database please follow these instructions:
If the database does have tables in it but are not visible, simply refresh the screen. Alternatively, click the Structure tab at the top
When you see your table name, click the first icon under Action (the Browse button).
PHPMyAdmin showing a login screen
If clicking on the phpMyAdmin button in your cPanel brings you to a login page for phpMyAdmin, this means that your MySQL and cPanel passwords have become un-synced. You can resolve this yourself by simply changing your cPanel password.