Allowing remote connections on your MySQL Database on Linux Hosting

For this article, we’ve taken the liberty of assuming that you understand technical nitty-grittys required to do this. If you do not, then we’d advise you to get in touch with a professional to help you out. If you know web stuff, then read along, it shouldn’t be too difficult for you.

At times, your web application has the need to connect to our MySQL database servers from third party host servers or even from your local machine. In this case, you need to whitelist the remote IP address from where you’ll be connecting to our database servers i.e. from third party host server IP address or your public static IP (if you’re connecting from your local machine). Here’s how you do it:

  1. Login to your
  2. In the Databasessection, Click on “Remote MySQL”
  3. Enter the IP address of your remote server or your public static IP (if you’re connecting from your local machine). If you are not sure about this IP address and want to allow connections from any host, enter a wildcard i.e. just type in “%”in the field

Click on “Add Host”

1

That’s it. You’ve just whitelisted your remote host server / your local machine to connect to our MySQL database servers and you’ll be able to connect to it seamlessly.

 

If you want to see how this works, we’ve found this super awesome free online tool to show you:

  1. As mentioned in the above steps, add a wildcard “%”in the Remote MYSQL provided in cPanel
  2. Go tohttp://ghtorrent.org/dblite/
  3. You can choose to Register on this website or Continue as Guest
  4. Once in, click on the icon to your left which says – New Connection
  5. Enter a Connectionname
  6. Set your hosting package IP address as Host
  7. Set the Port to default – 3306
  8. Enter your Database Username
  9. Enter your Database Password
  10. Click on Test
  11. You should now get a Connection successful message. Click on OK
  12. Select your Databasein the drop down provided
  13. Click on Connect

That’s it. You are now accessing our database server online from a third party server.

0 Likes
0 Dislikes
1067 Views