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.
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, even importing 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.
Note: PHPMyAdmin won't allow you to create databases directly on it. You can only create databases in cPanel via the MySQL Databases icon.
Note: You can only access phpMyAdmin from within cPanel or Plesk. The icon in cPanel says phpMyAdmin and the icon in Plesk says Webadmin.
Common Errors (cPanel):
By default, owners logged into WHM cannot access individual accounts 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"
This means exactly what it says. You will need to log out of root, and log into the individual cPanel in order to access those databases.
Dedicated: You can access 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.
If you are seeing an error saying No Privileges. [screen shot]
This is not an error. You cannot create databases in phpMyAdmin. To create a database you must go to cPanel > MySqL Databases and use the Create Database button.
Tables missing. No tables found in the database!
Simply refresh the screen. Alternatively, click the Structure tab at the top, and then when you see your table name, click the first icon under Action (the Browse button).
[screen shot 1] ..:|:.. [screen shot 2]