5kits zhao

How do I enable remote access to MySQL database server?

* bind-address : local IP address to bind to. If you wish mysql listen on all IPs, don’t use this option.

For example if you want to allow access to database called ‘foo’ for user ‘bar’ and remote IP 192.168.0.1 then you need to type following commands at “mysql>” prompt:

mysql> GRANT ALL ON foo.* TO bar@’192.168.0.1′ IDENTIFIED BY ‘PASSWORD’;
mysql> REVOKE GRANT OPTION ON foo.* FROM bar@’192.168.0.1′;

references

http://kb.parallels.com/en/1134

Leave a Reply