linux-mysql配置允许公网ip访问

1.登录服务器mysql后台 # mysql -uroot -p

2.进入和查询用户表 mysql> use mysql; mysql> select host,user from user;

3.给此IP赋权 mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'125.121.34.16' IDENTIFIED BY 'dyysc2018@' WITH GRANT OPTION;

4.刷新权限 mysql> flush privileges;

转载于:https://my.oschina.net/u/3755998/blog/2991251