Mysql5.6设置Root远程连接登陆

mysql>use mysql;  
mysql> GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "密码";    //为root添加远程连接的能力  
mysql> flush privileges;  
mysql> exit  
mysql>select host,user from user; //查看修改是否成功。

ps：修改密码命令：

ALTER USER 'root'@'localhost' IDENTIFIED BY '123456'; //(5.6以前)
UPDATE user SET Password = PASSWORD('123456') WHERE user = 'root' and Host='%';// (5.6以后)