Linux 系统下 限制IP 访问mysql 数据库
Step 1:进入mysql 终端命令
# mysql -uroot -p
# 输入密码
# 退出命令界面 按Ctrl+D
Step 2:mysql 配置可以允许访问的IP
# GRANT ALL PRIVILEGES ON *.* TO 'root'@’10.10.50.127’ IDENTIFIED BY 'Abcd1234' WITH GRANT OPTION;
# flush privileges;
命令1 :允许用户root, IP为10.15.50.107的主机连接到mysql服务器,并使用Abcd1234作为密码
命令2 : flush privileges 立即生效
Step 3:修改mysql数据库中的user表,使相应的用户能从某一主机登陆
# use mysql;
# update user set host = '%' where user = 'root';
# select host, user from user;
# delete from user where host = '%' where user = 'root';