MySQL : Open access from outside
Because your application on a remote server had to connect to the server that host your MySQL database, or you want to administrate remotely your MySQL DB you had to know for security purposes, remote access is not allowed by default.
So, first you have to change the settings in the /etc/mysql/my.cnf file :
nano /etc/mysql/my.cnf
You had to look for bind-address setting. By default bind-address = 127.0.0.1. So you have to remplace the address which will be authorized to connect from. Only one address can be set. If you want to connect from every ip address, you had to set 0.0.0.0
Save the new file.
Run PhpmyAdmin. Click on Privileges Tab and edit your database user.
In the Login Information frame, in host, instead of localhost set % then save by pressing Execute.
Back to SSH run :
/etc/init.d/mysql stop
/etc/init.d/mysql start



