Remote MySQL access allows external servers or applications to securely connect to your MySQL database hosted on your web server. This is especially useful if you’re running apps on a different server, using remote development tools, or connecting a third-party service to your database.

With web hosting from Domains.co.za, you can easily enable and manage remote database access directly from your cPanel dashboard, giving you control, security, and flexibility for multi-server or remote workflows.

How to Configure Remote MySQL Access in cPanel

Follow these steps to allow remote connections to your MySQL database:

1. Login to your Domains.co.za account.

2. Open the Manage Services dropdown menu, select your hosting plan from the list.

3.Click Manage next to your domain.

4. Click Login next to Control Panel to access cPanel.

5. Scroll to Databases and click Remote Database Access.

• Enter the IP address or domain name of the remote server you wish to grant access to.
• If you wish to allow all IPs (not recommended for security), use %.
• Click Add Host to save the remote IP.
• Ensure your MySQL user has the correct privileges to access the database remotely (you can manage this via MySQL® Databases in cPanel).
• Use Whitelist port 3306 in your firewall if you are configuring your own remote server.

Additional Information

• What is Remote MySQL? It allows a database connection from a server or app that is not hosted on the same server as your database.
• Why Use it? Useful for developers working off-site, third-party applications, or connecting separate servers.
• Security Note: Only allow trusted IPs to prevent unauthorised access to your databases.
• Dynamic IPs: If your IP often changes, consider using a dynamic DNS service or updating your IP manually each time.
• Database User Access: Grant privileges to the correct MySQL user through cPanel’s MySQL Databases interface.
• Connection Details: Use your server IP or hostname as the database host, along with your database username and password.
• Firewall Access: Port 3306 must be open for external MySQL connections. Check with your remote server or hosting provider.
• Restrict When Done: Remove unused or outdated IPs from the allowed host list to maintain security.