Friday, April 3, 2009

Quick and Dirty way to allow remote access to your MySQL server

I usually do this in my lab environment.  I'm sure you will use it with care when you do it in production environment, and to make it more securely and restrictive.

GRANT ALL ON *.* TO 'someuser'@'somehost';

'somehost' could be '%', it will allow all hosts to access.  Again use it with great care!

Then you can use some GUI tools (e.g. MySQL-Front, my favorite GUI for MySQL) to remote access and administer your MySQL database.

http://dev.mysql.com/doc/refman/5.1/en/grant.html

No comments: