HOW CAN WE HELP YOU TODAY?

1
Knowledgebase: Shared Hosting
Allowing remote connections on your MySQL Database on Linux Hosting
Posted by Noble M on 19 June 2014 03:11 PM

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 cPanel


  2. In the Databases section, 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

  4. Click on "Add Host"


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 to http://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 Connection name

  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 Database in the drop down provided

  13. Click on Connect

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

 

(9 vote(s))
This article was helpful
This article was not helpful