PHP & MySQL Tutorials
Remote MySQL Access In Site Tools

Remote MySQL Access In Site Tools

How to add and manage remote access hosts to my MySQL – Video Tutorial

You can access and manage the databases on your account from locations different than the hosting server. The list of hosts and IPs that are allowed to access the databases on your account remotely is managed from Site Tools > Site > MySQL > Remote.

Allow hosts access to the databases on your account

When you open the tool, add the IP or hostname that you would like to allow access to your databases from the Host field. If you would like to add an IP range you can do that by using a wildcard (%) character. For example, to allow access from all IPs starting with 1.2.3, enter 1.2.3.%.

Once ready, click on Add to apply the change.

You will see a confirmation message that the host was added successfully.

If you have a dynamic IP address which changes on a regular basis, you can allow the exact IP addresses or range you are using.

Keep in mind that allowing access from all IPs is considered a security vulnerability and is not recommended.

Revoke access to allowed hosts

To remove an allowed host from the allowed hosts list, click on Delete for the corresponding entry:

A pop up will open, on which you need to confirm the removal of the host by clicking on Confirm.

Share This Article