Protected by Sectigo SSL

How can I connect remotely to my MySQL database?

Once logged into your hosting control panel go to Web Tools > Remote MySQL and this will take you to the page that you can create the remote access from:


Select the database you want to connect to from the Database User drop-down and then add your publically facing IP to the IP Address field (check at http://www.whatsmyip.org/ if you're not sure how to find this) and then click Add Host.

Once added it can take up to thirty minutes for this connection to be become fully active and you can then use your software to connect to the server listed on the page using the port number specified in the Manage Access Hosts section:


For the above example the details to add to your software would be as follows (example is shown with SequelPro):

 

  • Email, SSL
  • 1 Users Found This Useful
Was this answer helpful?

Related Articles

Can I use Microsoft SQL Server Management Studio to manage my MSSQL database?

We run Microsoft SQL Server 2008 on our servers, only Microsoft SQL Server Management Studio 2008...

How can I connect to a MySQL database through .NET?

MySQL Connection Strings on a Windows hosted siteAll Windows shared servers have the...

Can I connect to a MSSQL database from my linux shared hosting account?

Yes, you can connect to MSSQL databases through PHP5 via the ms_sql extension and the ms_sqli...

How do I connect to MySQL with ASP?

This applies to Windows Hosting accounts only. You will need to use a DSNless connection which...

I'm getting SQL errors on MySQL 5 saying it can't find a column - but it's there!

1054 - Unknown column 'a.c' in 'on clause'This can happen if you're doing something like:SELECT *...