How to allow remote MySQL access from your computer or server
On this page
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
- Log in to the control panel (
https://<server>:2083). - Open Remote MySQL in the menu (section Databases).
- 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
- one address:
- Optionally enter a Note, for example
Office. - Click Allow.
You see Address allowed. It works within a minute.
Connect
Use the details under Connection on the same page:
| Setting | Value |
|---|---|
| Host | the server name shown under Connection |
| Port | 3306 |
| User | one of your database users, for example username_shop |
| Password | that user's password |
| Database | a 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.
Thank you — this helps us improve the article.
Still stuck?
Ask the AI about your exact situation — it answers from this knowledge base — or contact us.
Related articles
- MySQL connection details: host, port, socket and examples
The database host (localhost), port 3306, socket path, name and user format to connect WordPress, PHP, Laravel, Node.js or Python to MySQL, with examples.
- How to add a user to a MySQL database (privileges)
Give a database user access to a MySQL database with Grant all privileges, remove its access again, and understand which privileges the user gets.
- Error establishing a database connection or access denied
Fix "Error establishing a database connection" and MySQL "Access denied for user" errors: wrong name prefix, password, privileges, host or remote access.