mysql配置白名单访问 1.登录 mysql -uroot -pmysql 2.切换至mysql库 use mysql; 3.查看有白名单权限的用户 select Host,User from user; 4.指定ip有权限访问mysql GRANT ALL ON *.* to root@'192.168.1.4' IDENTIFIED BY 'your-root-password'; 如果没有密码则不用填, GRANT ALL ON *.* to root@'192.168.1.4' ; @后面的是指定白名单的ip 5.删除白名单用户的权限 DELETE FROM user WHERE User='username' and Host='host'; 6.刷新 修改权限之后都要刷新才会生效 FLUSH PRIVILEGES; |
|