How to Set Up Remote MySQL Access in Webuzo

By default, your MySQL database only accepts connections from the server itself — which is exactly what you want for security. But sometimes you need to connect from outside, such as from a desktop database tool or an external application. Remote MySQL access lets you do that by whitelisting the specific IP address that is allowed to connect.

Before you begin

You will need the public IP address of the computer or server that will connect. You can find it by searching “what is my IP” in a browser on that machine.

Allow a remote IP in Webuzo

1. Log in to your Webuzo Enduser Panel.
2. Open the Databases section and click Remote MySQL (or Remote Database Access).
3. Enter the IP address you want to allow.
4. Click Add. That address can now connect to your databases.

Then connect using your database username and password, with your server’s hostname or IP as the host (instead of localhost).

Keep it secure

• Only whitelist specific, fixed IP addresses — never % (which means “anyone”).
• Remove IPs you no longer use.
• Use a strong database password, since the database is now reachable from outside.

Frequently asked questions

My connection is refused. What is wrong?

Confirm you whitelisted the correct public IP (not a local address like 192.168.x.x), and that your database user has permission. A firewall on either end can also block port 3306.

My IP address keeps changing.

Many home connections use dynamic IPs. You will need to re-add the new IP when it changes, or connect from a machine with a static IP.

Is remote MySQL safe to leave on?

It is reasonably safe when locked to specific IPs with a strong password. For the tightest security, enable it only while you need it.