为mysql添加root远程登录权限

默认情况下,MySQL之允许本地登录,需.

默认情况下,MySQL允许本地登录,需要修改/etc/mysql/my.cnf文件:
注释这一行:
bind-address=127.0.0.1 ==> #bind-address=127.0.0.1
对于需要远程登录的用户执行如下命令:
mysql> GRANT ALL PRIVILEGES ON *.* TO root@”%” IDENTIFIED BY “yourpasswd” WITH GRANT OPTION;
mysql> flush privileges;

mysql> use mysql;
mysql> update user set host = ‘%’ where user = ‘root’;
mysql> select host, user from user;
mysql> flush privileges;