Pages

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

No comments:

Post a Comment