The administration of a MySQL database throughout the internet is managed by a tool written in PHP called PHPMyAdmin. The database itself is first set up in cPanel, but PHPMyAdmin manages its functions. For example, PHPMyAdmin can create and alter databases. You can use it to add, edit, delete fields, drop entire databases, run SQL statements or even transmit information into different formats and administer keys. Basically, any table command you would run from the shell at the mysql prompt can be accomplished here in this graphical user interface.
How Do I Access PHPMyAdmin?
To find PHPMyAdmin on your cPanel, login and go to Home > Databases > PHPMyAdmin.
What Does PHPMyAdmin do?
After you create a database, you'll be able to use the functionality of PHPMyAdmin. Here are the basic functions of the application,
View MySQL Processes
Searches and SQL Queries
As always, if you have any other questions or need assistance with this, please contact us in our 24/7 Live Chat, and we'll be happy to assist you.