mysql 远程连接授权

1.创建user,指定远程主机ip

 create user 'ent'@'112.17.112.25' identified by 'ent110';

2.授权

 grant all privileges on *.* to 'ent'@'112.17.112.25' identified by 'ent110';

3.刷新权限

flush privileges;

4.查看

 select user,host from mysql.user order by host desc,user desc;

额外说明：

mysql 连接的匹配顺序--》

host优先匹配（明确的host在前，空串在最后），然后匹配user.