JSOPanel Get started
Help Center › Website Owners › Connecting to your database from your own computer

Connecting to your database from your own computer

How to use a desktop database tool with your hosted database, and what to ask your provider for.

Your website reaches its database from inside the server, so nothing needs setting up for that. If you want to connect from your own computer instead, with a tool such as MySQL Workbench, DBeaver, pgAdmin or MongoDB Compass, your hosting provider has to allow it first. It is switched off by default, and only your provider can turn it on.

What to ask your provider

  • Which database you want to connect to (its full name, as shown on your Databases page).
  • The public IP address of the computer or office you will connect from. Search for "what is my IP" to find it. It has to be one address, not a range, and it is worth confirming it does not change from day to day.

Once they have allowed it, they will send you the server address, the port, a login name and a password for this connection. It is a separate login from your website's own, and it can reach that one database only.

Connecting

In your tool, enter the server address, port, login name, password and database name you were given, and switch on its option to require an encrypted connection (it may be called SSL, TLS or "require secure connection"). If your provider tells you encryption is not available, ask whether it can be set up before you send anything sensitive.

If it will not connect

  • Check that the computer you are connecting from is the address you gave. A new network, a VPN or a changed home address will not be allowed.
  • Check the login name and password exactly as sent, including capital letters.
  • Ask your provider to confirm the connection is still switched on for your address.
Tip: to just look at or change your data, the Adminer button on your Databases page opens your database in your browser, with nothing to set up.