MySQL5.X给远程用户授权

5.6版本

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY '123456' WITH GRANT
OPTION;

---------------------

5.7版本

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY '123456';
mysql> flush privileges;