0 items
24/7 Support & Sales   1300 210 210
Online Support Web Hosting

How to setup a Remote MySQL Connection

What is a MySQL connection?

A MySQL connection is a link between the computer you are using and your MySQL database. You establish this connection when you want access to your MySQL database.

In order for you to establish a MySQL connection, you must make sure first that you are able to connect to the server where your MySQL database is located. Also, your system needs a computer language such as Java, Perl, Python, and PHP in order to access your MySQL database.

If you want to know more about what is a MySQL database, click here.

How to set up a Remote MySQL Connection

If you need to access your MySQL databases from a new device or computer, you should add your machine as an access host to your server. This connection is called a Remote MySQL Connection. You can do this by adding your computer’s IP address to the Access Hosts list within your Hosting Manager.

Note: If you don’t know your IP address, you can find out by visiting whatismyipaddress.com.

To add your IP address to the Access Host list and set up your remote MySQL connection, follow the steps below:

  1. Click on My Account at the top of the page.
  2. Select Hosting Manager from the drop-down menu.
  3. Enter your username and password, and click Log In.
  4. On the Home page, click the word Databases or the [ v ] arrow symbol on the right side.
  5. Click the Remote MySQL button, which is next to MySQL Database Wizard icon.
  6. Next page, type in your computer’s IP address in the Host (% wildcard is allowed) field.
  7. Click Add Host.
  8. If the action was successful, you will get the following notification:
    √ The host “(the IP address)” was added to the access list.
    Click Go Back to get back to the Remote MySQL main page.

At the Remote MySQL page, should now be able to see your new computer’s IP address in the Access Hosts column. You should also be able to connect to your database from your new computer or device.

Note: There is no limit to how many access hosts you may add within your Hosting Manager, so you may add as many IP addresses as you need.

Congratulations, you now know how to set up a Remote MySQL connection.

If you want to delete an IP address from the Access Hosts list, follow the steps below:

  1. Click on My Account at the top of the page.
  2. Select Hosting Manager from the drop-down menu.
  3. Enter your username and password, and click Log In.
  4. On the Home page, click the word Databases or the [ v ] arrow symbol on the right side.
  5. Click the Remote MySQL button, which is next to MySQL Database Wizard icon.
  6. Next page, find the IP address you want to remove and click the corresponding Delete button to the right.
  7. You will then get the following confirmation question:
    Are you sure you wish to permanently remove “(the IP address)” as an access host?
    Click the Remove Access Host button to confirm.
  8. If the action was successful, you will get the following notification:
    √ Removed Host “(the IP address)” from the access list.
    Click Go Back to get back to the Remote MySQL main page.

Congratulations, you now know how to delete an IP address from the Access Hosts list.

If you want to know more about what is an IP address, click here.

If you want to know how to add an IP address to your Web Hosting, click here.

If you want to know how to block an IP address from your website, click here.

Was this helpful? Yes No 40% of people found this helpful.