phpMyAdmin

 

Managing Your Database Using phpMyAdmin

The 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.


Jump to a Section:


Accessing phpMyAdmin

cPanel

  1. Login to cPanel.
  2. Click the phpMyAdmin icon in the Databases section.

Plesk

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.

  1. Log into WHM.
  2. Under the SQL Services section, select phpMyAdmin to gain access to every database on the server.

    WHM - SQL Services - phpMyAdmin


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 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: A database cannot be created in phpMyAdmin. (You can, however, create databases as needed in your cPanel.)
How Do You Analyze the Size of a Database Using phpMyAdmin

Using the phpMyAdmin in your cPanel, you can see the details of your databases and tables. Please refer to this guide.

  1. Log into the cPanel.
  2. Scroll down to locate the Databases section.
  3. Click phpMyAdmin.
  4. On the left pane, choose your database name. Click the + icon to expand and see the tables in that database.

    phpMyAdmin - Select Database

  5. Once collapsed, you will see all tables in that database.

    phpMyAdmin - Tables in Database

  6. On the right pane, scroll a little bit to view the Size column.

    phpMyAdmin - Database - Table Size

  7. The phpMyAdmin shows the sizes of each table, and the total size of all tables are shown at the bottom.

    phpMyAdmin - Database - Table Total Size

How to Check, Optimize, and Repair Tables in phpMyAdmin
  1. In phpMyAdmin, select the database you wish to optimize.
  2. Click the + icon to expand and see all tables in that database.

    phpMyAdmin - Select Database

  3. On the right pane, select the table(s) you wish to optimize. You can also put a checkmark on the Check All checkbox found below the tables.

    phpMyAdmin - Databases - Select All Tables

  4. Once selected, choose Optimize table from the With selected: drop-down menu below the tables.

    phpMyAdmin - Databases - Select Action

    Note: You can also select Check table or Repair table from the options.

  5. A confirmation prompt will appear on top to notify you that the query was successful.

    Successful Query Prompt

How To Delete All Contents of a MySQL Table Using phpMyAdmin
  1. On the selected database, choose the table you wish to delete the contents. Note: This option would apply to ALL contents of that table.

    phpMyAdmin - Select Table

  2. To delete contents, click the Empty icon located along the row of the selected table.

    phpMyAdmin - Empty Icon to Delete Table Contents

  3.  Alternatively, you can use the Empty option from the With selected: drop-down menu below.

    phpMyAdmin - Choose Empty Action from Drop-Down

  4. A confirmation prompt will appear on top notifying you about the successful query.

How To Run Queries Using phpMyAdmin

To run SQL queries, please refer to this article, How to Run SQL Queries in phpMyAdmin.


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

phpMyAdmin - Structure Tab

When you see your table name, click the Browse button under the Action menu.

phpMyAdmin - Browse Action


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.