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):