Loading...

Knowledge Base
Up to 75% off on hosting for WordPress websites and online stores

How to Set Up a Remote MySQL Database

A remote MySQL database allows access and management from external servers or applications, benefiting business owners, developers, and teams needing remote access. This guide provides step-by-step instructions for configuring a remote MySQL database through your Customer Portal, ensuring a quick and secure setup for various needs.

How to Allow Your Computer to Act as an Access Host

All IP addresses are blocked by default and must be added to an approved list before accessing the server. This means that before connecting to MySQL from another computer, you need to authorize that computer as an Access Host. If your Internet Service Provider (ISP) assigns you a dynamic IP address, your IP may change periodically. To maintain access, you will need to update the allowed IP address in the Remote MySQL settings whenever it changes.

Many of our servers block port 3306 for inbound connections. If you receive a Connection Refused error while trying to connect, please contact us via phone or chat and request that port 3306 be opened for your IP address to enable remote MySQL access.

Access Remote MySQL Database

You must add the connecting computer as an Access Host to allow a remote MySQL connection. Here are the steps below:

  1. Log in to your Customer Portal.
  2. Click Websites on the left side of the navigation menu.
    websites-tab-cp
  3. You can also go to the Hosting tab, find the hosting package you want to manage, and click the MANAGE button.
    cp-new-hosting-tab-multiple-hosting-plans-manage
  4. On the website management page, click SETTINGS for the site you want to manage.
    cp-website-settings
  5. Click the ADVANCED tab in the top menu, then select MANAGE under the Databases tile.
    cp-advanced-databases
  6. In the Database Management page, navigate to the REMOTE tab and click on it.
    cp-database-management-remote
  7. In the Remote MySQL Access section, select ADD HOST to proceed.
    cp-database-management-remote-add-host
  8. Enter the connecting IP address in the Enter IP field. You can add an optional description, then click ALLOW ACCESS to grant permission.
    cp-addhost-allow-access
  9. You should now be able to connect to your database remotely. Below is an example to guide you:
    cp-database-management-allowed-host

Remove or Edit a Remote Access Host

To remove or edit a host's access to databases on your server in the Customer Portal, follow these steps:

To Edit Allowed Host/IP Address:

  1. To make edits, find the Host/IP address you wish to modify and click the ellipsis icon.
    cp-database-management-edit
  2. Select Edit Host.
    cp-database-management-edit-host
  3. After making your changes, click SAVE to apply them.
    cp-database-management-edit-host-save

To Remove Allowed Host/IP Address:

  1. To remove a host, find the Host/IP address you wish to delete and click the ellipsis icon next to it.
    cp-database-management-edit
  2. Select Delete Host.
    cp-database-management-delete-host
  3. Click the DELETE button to confirm.
    cp-database-management-delete-host-confirm

Note: A dynamic IP address means the connecting IP may change periodically, depending on your Internet Service Provider (ISP). Be sure to update the connecting IP in Remote MySQL each time it changes.

Did you find this article helpful?

 
* Your feedback is too short

Loading...