Adding MySQL access hosts

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 the server that your site is currently on.

Steps

1 To access the MySQL Account Maintenance Menu, click on the icon above the words MySQL Databases on the main screen of your cPanel interface.

2 Type the name of the server into the blank field next to Host: (It should be in the following format: test.cpdocs.net, server1.cpdocs.com, ns1.cpdocs.com, etc).

3 Click on Add Host to allows that server to access your MySQL databases.

Was this answer helpful?

 Print this Article

Also Read

What is the mysql host name and port

Always use 'localhost' as a host name and 3306 port no.

How do I create a MySQL database, a user, and then delete if needed?

Create: If you are using any type of PHP software or keeping a collection of records which need...

How do I restore a database using PHPMyadmin?

You can restore a database backup in PHPMyadmin by doing the following: 1) After entering...