乐在其中

[offar@DEV ~]# mysql -uroot -p

mysql> CREATE USER ‘root’@’%’ IDENTIFIED BY ‘123456’;
mysql> GRANT ALL PRIVILEGES ON * . * TO ‘root’@’%’ IDENTIFIED BY ‘123456’ WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

OK，现在所有主机可以都远程通过root连接。

注：不建议对root开启远程访问权限。