MySQL开启远程登陆

MySQL开启远程登陆
mysql> use mysql;
mysql>GRANT ALL PRIVILEGES ON . TO ‘root’@'%'WITH GRANT OPTION;
mysql>FLUSH PRIVILEGES;
mysql>EXIT;

或者
mysql> use mysql;
mysql> update user set host = ‘%’ where user = ‘root’;
mysql> FLUSH PRIVILEGES;