Databases
Remote MySQL
Updated: 10 February 2024In this tutorial, we will guide you on how to use the Remote MySQL menu in cPanel. This feature allows you to configure databases to accept connections from remote hosts, which can be useful for managing your databases remotely or connecting them to third-party software.
Accessing the Remote MySQL Menu
To access the Remote MySQL menu, follow these steps:
- Log into your cPanel account
- Scroll down to the Databases section.
- Click on the Remote MySQL icon.
Adding a Remote Host
Once you have accessed the Remote MySQL menu, you can add a remote host to allow it to access your databases. Here's how to do it:
- In the Host field, enter the IP address of the remote host you want to add.
- Click on the Add Host button.
Remember
You can also enter a fully qualified domain name (FQDN) instead of an IP address.
Removing a Remote Host
If you need to remove a remote host's access to your databases, you can do it from the Remote MySQL menu as well. Here are the steps:
- Under the Manage Access Hosts section, find the host you want to remove.
- Click on the Delete button next to the host's IP address or domain name.
- Confirm your action in the pop-up window.
Be Careful
Before deleting a host, make sure that no active applications are relying on its access to your databases.
Using a Wildcard (%)
You can use a wildcard (%) in the Host field to allow all hosts on a particular domain or subnet to access your databases. However, this should be used with caution as it can expose your databases to potential security risks.