This topic will show how to login to phpMyAdmin via the WCP control panel.
What is phpMyAdmin?
phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web. phpMyAdmin supports a wide range of operations on MySQL and MariaDB. Frequently used operations (managing databases, tables, columns, relations, indexes, users, permissions, etc) can be performed via the user interface, while you still have the ability to directly execute any SQL statement.
view source: https://www.phpmyadmin.net
Since phpMyAdmin is a web based software written in PHP this means it falls under the servers (it’s running on) PHP limits. For this reason recommend the use of a database administration tool like MySQL WorkBench for larger database administration task. You can, however, raise the PHP limits on the server to allow for larger execution times, upload size restrictions, etc. to help your database administrating.
Login to phpMyAdmin via WCP
Login to your WCP control panel.
Note: You can view our topic on logging into WCP if you need help with this step.
Once logged in if you are not already on the domain in questions control panel page then click on the ‘Hosted Domains’ drop-down from the top of the pages navigation bar. Then select the desired domain from the drop-down.
Once logged into the control panel for the domain you wish to login to phpMyAdmin with click ‘phpMyAdmin’ icon underneath the ‘Databases’ section.
Here you’ll see a list of each MySQL user you’ve setup for this domain. You will only see each user listed once, unless you have the same username created on multiple MySQL servers ( Each server can only have the user listed once ). You can see the database(s) this user is assigned to in the “Databases” column.
Click ‘Login’ next to the MySQL user you would like to login to phpMyAdmin with.
You should now be logged into phpMyAdmin where you can manage your MySQL databases.
Note: Your databases will be listed on the left-hand side navigation menu. Select a database to begin operating within phpMyAdmin.