How to allow remote MySQL access from your computer or server

For hosting customers · Updated 2026-10-29

On this page
  1. Steps
  2. Connect
  3. Good to know
  4. Common questions

By default your databases can only be reached from this server. Remote MySQL lets chosen addresses connect directly — for example your office with a desktop tool (MySQL Workbench, HeidiSQL, DBeaver, TablePlus) or an application hosted elsewhere.

Steps

  1. Log in to the control panel (https://<server>:2083).
  2. Open Remote MySQL in the menu (section Databases).
  3. Under Allow an address, enter the IP address or range. The hint shows Your address now: — the address you are using at this moment.
    • one address: 203.0.113.10
    • a range: 203.0.113.0/24
    • an IPv6 address: 2001:db8::10
  4. Optionally enter a Note, for example Office.
  5. Click Allow.

You see Address allowed. It works within a minute.

Connect

Use the details under Connection on the same page:

SettingValue
Hostthe server name shown under Connection
Port3306
Userone of your database users, for example username_shop
Passwordthat user's password
Databasea database the user is added to

Good to know

  • Every database user of your account can connect from the allowed addresses, with its own password and the same databases as locally.
  • Everyone else is blocked by the firewall on port 3306.
  • Up to 20 addresses per account. Ranges must be /8 to /32. Wildcards such as % are not allowed.
  • Private and local addresses (192.168.…, 10.…) are refused: enter the public address of the computer or server that connects.
  • Home and mobile connections often get a new address. If the connection stops working, compare Your address now: with the list and add the new one.
  • Click Remove next to an address to block it again. With no addresses, your databases are reachable only from this server.

Common questions

I get "Access denied" from my computer although the address is allowed. Why?

Check that you use the full user name with prefix, its password, and a database the user is added to. Wait a minute after adding the address. See database connection errors.

Does Remote MySQL also work for PostgreSQL?

No. PostgreSQL databases are reachable only from this server.

Should I allow a whole range?

Only when the computer's address really changes within that range (for example a company network). The smaller the list, the safer: anyone at an allowed address can try to sign in.

Was this article helpful?

Still stuck?

Ask the AI about your exact situation — it answers from this knowledge base — or contact us.