How to Manage Database by phpMyAdmin
The administration of MySQL is done by phpMyAdmin tool, which is written in PHP. You should also know that through phpMyAdmin can create, drop, alter tables, delete, edit or add fields and export the necessary information in different formats.
Access to phpMyAdmin by cPanel or Plesk
1. Login into cPanel /or Plesk/.
2. From the Databases section select the phpMyAdmin icon /or Webadmin if you work with Plesk/.
How to Manage a MySQL Database using phpMyAdmin
MySQL is managed easily by using phpMyAdmin.
You can search in your browser for videos that show how to access your databases create and delete tables, update records, and even import a MySQL file into a database.
Please, note: You can create database only in your cPanel, not in phpMyAdmin.
Some of the Common Errors (cPanel):
If you log in WHM, you will haven’t access to the database via cPanel’s phpMyAdmim and will see the following 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".
The next step for you is to log out from the root and log into your individual cPanel.
Note: If root WHM users use a 'root' phpMyAdmin (WHM - MySQL - phpMyAdmin), they will have access to all databases on the server.
If you try to log in your phpMyAdmin (cPanel - MySQL - phpMyAdmin), it’s possible to see the next error:
#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured.
In this case, you should contact your supplier and want to restart MySQL.
If you see “No tables found in the database!”:
It’s necessary to check if the target database has tables. The tables made by MySQL Database haven’t information in them. They are empty.
In case that the database has tables, but they are invisible, you should Refresh your screen.
When you look at the table name, select the first icon under Action (the Browse button).
PHPMyAdmin returns to the login page
If you go to phpMyAdmin and it returns you to the login page, then your cPanel and MySQL password are unsynced. To resolve this problem, please change cPanel password.