Remote MySQL connection using a program like MySQL-Front

If you have a Helm/Windows hosting account please go to the point 3.

1.- In Linux/cPanel hosting accounts, login in cPanel, then go to the "MySQL databases" section and create the database, the database username and password and then grant permissions for the MySQL username to access the MySQL dbase. If you already have the database created please go to the point 2.

2.- Scroll down to the section "Access Hosts" and add your ISP hostname or ip (This is the ip or the hostname of your internet connection, if you do not know this information, please contact your ISP)

You could also use "%" (without quotes) to allow wildcard or allow anyone to connect to the database in the server but we do not recommend it because this will allow anyone connect to your database in the server.

3.- Go to your remote MySQL management program, like MySQL-Front and use the following information to connect to the MySQL database in the server:

Host: yourdomainname.com
Port: 3306
Database: user_dbasename
Username: user_dbaseusername (this IS NOT your hosting panel access username, is the database username you have created.)
Password: yourdatabasepassword (this IS NOT your hosting panel access password, is the password you used to create the dbase username.)

Now you must be able to connect remotely to your database in the server from your local computer!