By default, your database only accepts connections from the server it lives on. If you need to connect from your own computer or an external application, you must allow remote MySQL access for a specific address. This guide explains how to do that safely in DirectAdmin.
When you need this #
- Connecting a desktop tool like MySQL Workbench to your database.
- Allowing an external application or server to read your database.
- Letting a developer connect remotely for maintenance.
Allowing a remote host #
- Log in to DirectAdmin.
- Go to Account Manager > MySQL Management.
- Find the Access Hosts option.
- Add the IP address that should be allowed to connect.
- Save.
Security first #
Remote access widens who can reach your database, so keep it tight:
- Allow specific IP addresses, never a wildcard that opens it to everyone.
- Use a strong database password.
- Remove access hosts you no longer need.
Connecting #
Use your database name, username, password, the server hostname or IP, and port 3306 in your remote tool. If your own IP changes (many home connections do), you may need to update the allowed address.
Troubleshooting #
- Connection refused: confirm your current IP is on the access hosts list.
- Access denied: re-check the database user and password.
- IP keeps changing: ask your provider about a static IP or update the entry as needed.
Need help? #
If remote access will not connect, our support team can help over live chat.
