Setting up remote MySQL access

By default your databases only accept connections from localhost (applications on the same hosting). If you need to connect from an external tool - such as MySQL Workbench, a reporting app or another server - enable Remote MySQL.

1. Open the DirhamHost panel and go to Remote MySQL.
2. Add the public IP address that will connect. You can find yours by searching "what is my IP".
3. Save. That IP can now reach your databases.

When connecting externally, use:

• Host: your server's hostname or IP (not localhost)
• Port: 3306
• Username / password: your database user

Security advice: only whitelist specific, static IP addresses - never use % (any host), which exposes your database to the whole internet. If your office uses a dynamic IP, you may need to update the whitelist when it changes. Ensure port 3306 is not blocked by your local firewall.

For sensitive data, consider connecting over an SSH tunnel instead of opening remote MySQL. If you are unsure which IP to allow or the connection is refused, our team can check the firewall for you - WhatsApp +971 58 553 6767.