Enable MySQL for remote access
Wednesday, May 13th, 2009
When installing MySQL on a server and want to access it from an other machine than itself, this is easy done and should work on most platforms.
1. After installation of MySQL open up MySQL prompt.
# mysql -u root
2. Change to mysql database as default database and update access for root account.
mysql> use mysql
mysql> update db set Host=’%’ where db=’mysql’;
mysql> exit
3. Restart MySQL and you should be able to access it from another host and configure it the way you want.
# /etc/rc.d/mysql restart
