Managing MySQL databases
CPanel includes a web-based MySQL management tool called phpMyAdmin. This tool allows you to manage all aspects of your database structure and data. Refer to the phpMyAdmin documentation link, which is http://yourURL/3rdparty/phpMyAdmin/Documentation.html, if you need to know more about using phpMyAdmin.
To manage MySQL databases using phpMyAdmin:
-
Click on the MySQL databases button on the home page.
-
Click on the phpMyAdmin link at the base of the window. Refer to the phpMyAdmin documentation link, which is http://yourURL/3rdparty/phpMyAdmin/Documentation.html, if you need to know more about using phpMyAdmin
Adding host access
You can allow external web servers to access your MySQL databases by adding their domain name to the list of hosts that are able to access databases on your web site. localhost stands for your own web server.
To add host access:
-
Click on the MySQL databases button on the home page.
-
Enter the domain name or IP number of the host that you wish to add in the Host field.
-
Click on the Add Host button.
Removing host access
Remove host access for a particular server when you no longer want that server to access your MySQL databases.
To remove host access:
-
Click on the MySQL databases button on the home page.
-
Click on the Delete button next to the web server that you want to remove.