How to Manage a MySQL Database with phpMyAdmin in cPanel

How to Manage a MySQL Database with phpMyAdmin in cPanel?

  1. In order to manage a MySQL database with phpMyAdmin, you need to log in first in the cPanel while using your web hosting account’s username and password.
  2. Then you need to click on the phpMyAdmin icon to move to the next step.
  3. You will be then redirected to the main page of phpMyAdmin. It is the place from where you can manage all the MySQL databases that you have assigned for your hosting account.
  4. At the top left corner you can find out entry that carries your account’s user name. Click on the Plus sign that is on its left. Now a list of databases will appear before you. Click on the specific one that you want to manage.
  5. Now you will be able to manage the desired database, you can add or delete entries, manage tables, and also perform queries among other things. 
  • 97 Users Found This Useful
Was this answer helpful?

Related Articles

Can I connect to MySQL from my computer

Yes, you can. Just need to add your IP address in the hosts allowed to connect to MySQL. Adding...

Can’t connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

If you receive this error message when connecting to MySQL trough command line on your VPS...

Export and import of MySQL databases from cPanel

For management on databases in your hosting account you can use the web application phpMyAdmin....

Export and import MySQL databases via SSH

If you want to import your MySQL database through SSH on your VPS or dedicated server, use the...

How to see the MySQL variables

Log into your MySQL database and type: show variables; You will see the following: mysql>...