2010/09/05

MySQL remote access by root

my.cnf
#bind-address = 127.0.0.1   (disable this setting for listening any address)
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root_password' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;