PhpMyAdmin

phpMyAdmin is a tool written in PHP to handle the administration of MySQL over the web. Databases must be created in cPanel, 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.

I apologize, but we do not offer support for using phpMyAdmin. You can find support at phpmyadmin.net.

 

Note: PHPMyAdmin won't allow you to create databases directly on it. You can only create MySQL Databases in cPanel.

Note: You can only access phpMyAdmin from within cPanel.

Common Errors:

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.

Cloud Computing: 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.

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

  • 2 Users Found This Useful
Was this answer helpful?

Related Articles

Public_ftp folder

The public_ftp folder is used for storing files which are available with anonymous FTP. You...

How to generate/download a full backup

A full backup is a backup of all of your files, e-mail, databases, etc. To run a full backup, you...

How to connect to the MySQL database

Configuration Settings: Host = localhost (really, put localhost)Database name =...

How to view website statistics in cPanel using AWStats

When you have a website online, you may want to check on how many people are coming to your...

I accidentally deleted the public_html or www folder.

If you delete the www folder, your site should still load properly. If you delete the...