By default your database only accepts connections from the server itself. To connect from your computer or an external application, you allow remote MySQL access for a specific address. This guide explains how in cPanel, safely.
When you need this #
- Connecting a desktop tool like MySQL Workbench.
- Allowing an external application or server to reach the database.
- Letting a developer connect remotely.
Allowing a host #
- Log in to cPanel.
- In the Databaser section, open Remote MySQL.
- Enter the IP address allowed to connect.
- Click Add Host.
Security first #
- Allow specific IPs, never a wildcard open to everyone.
- Use a strong database password.
- Remove hosts you no longer need.
Connecting #
Use your database name, user, password, the server hostname or IP, and port 3306 in your remote tool. If your home IP changes, update the allowed address when needed.
Troubleshooting #
- Connection refused: confirm your current IP is on the list.
- Access denied: re-check the user and password.
Need help? #
If remote access will not connect, our support team can help over live chat.
