Enable Remote access to Mysql Server [Ubuntu]

When your installing mysql from apt get you would face this problem. Actually its not a problem but a security for our local mysql server to prevent access from others. :)

If you want enable the remote access here are the steps. Just 3 steps

Step 1
Edit the mysql configuration file

 sudo gedit /etc/mysql/my.cnf  

Comment the following line

 bind-address = 127.0.0.1  

• To comment add # 

Save the my.cnf file.

Step 2

Restart the mysql server

 sudo /etc/init.d/mysql restart  

Step 3
Grant database access to particular IP address

 GRANT ALL ON foo.* TO bar@'202.54.10.20' IDENTIFIED BY 'PASSWORD';  

That's IT. You just unsecure your database :P