root用户授权通过本机(localhost)访问,密码“为root”
mysql>GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY 'root' WITH GRANT OPTION;
root用户授权非本机使用root用户访问,密码“为root”
mysql>GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY 'root' WITH GRANT OPTION;