mysql> GRANT ALL PRIVILEGES ON *.* TO root@'ip' IDENTIFIED BY 'password' WITH GRANT OPTION;
mysql> flush privileges;
注释:ip为你想授权的远程ip,password为你的mysql密码
mysql> GRANT ALL PRIVILEGES ON *.* TO root@'ip' IDENTIFIED BY 'password' WITH GRANT OPTION;
mysql> flush privileges;
注释:ip为你想授权的远程ip,password为你的mysql密码