设置mysql远程连接权限

window 命令：

1.

mysql -h localhost -uroot -p

2.输入pqssword

3.use mysql; (此DB存放MySQL的各种配置信息)

4.
select host,user from user; (查看用户的权限情况)

5.
select host, user, password from user;

6.
Grant all privileges on *.* to 'root'@'%' identified by 'ytj001' with grant option;
//修改密码

7.运行生效：
flush privileges;    (运行此句才生效，或者重启MySQL)