Enable Remote Access To MySQL
By default remote access to MySQL database server is disabled for security reasons. However, some time you need to provide remote access to database server from home or a web server. So here is one more tip arround MySQL
Open your configuration file from MySQL:
Search for the entry:
bind-address = 127.0.0.1
and remove this entry or comment out this line!!
Restart your server:
One important thing is to GRANT root access from anywhere:
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;
And be happy!