mysql授权ip连接数据库

1.mysql -u root -p登录数据库

2.use mysql;

3.grant all privileges on *.* to root@"xxx.xxx.xxx.xxx" identified by "密码";

4.fulsh privileges;

这是已经完成，可以进行查看

select user,password,host from use;