Home
/
PHP & MySQL Tutorials
/
Remote MySQL Access Tutorial In Site Tools

Remote MySQL Access Tutorial In Site Tools

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 remote access to your databases from all IP addresses. To do that, add the wildcard character in the Access Hosts list as shown below:

Keep in mind that this is considered as a security vulnerability and is not recommended. Instead, you can allow the exact IP addresses or range you are using.

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