More information on how to allow your IP to access your databases remotely can be found in our Access Hosts tutorial.
Once you have created your database and added a user to it, you should connect to the remote server where your website and database are located. Then you can continue with setting your connection to the MySQL database.
Select Window -> Database to open up Database property window:
Click on "+" sign and choose MySQL Connection. A new window will pop up - here you should enter the MySQL username, password and database, as well as the MySQL server.
In the first field type a name for the connection. In the "MySQL server" field type localhost. Then enter the MySQL username and password details and the database name as shown in the example. Click OK to connect to your database.
If you have entered all details correctly, you should be able to see your connection listed in the Databases tab:
(c) Copyright 2004-2013 SiteGround. All rights reserved