MySQL Tutorial

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.

Step 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.

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

Step 3: Click on Add Host to allow that server to access your MySQL databases.

Step 4: Click on Delete to remove the server to access your MySQL databases.

Troubleshooting Tips: To add a group of servers, you can use %.domain.com which would include all of the following: ns1.domain.com, server1.domain.com, test.domain.com, etc.