如何限制某几个ip访问mysql

Question

希望mysql里面的某个用户只有172.29.8.72和192.168.3.39可以连接上，应该怎么设置啊

Answer 1

在 mysql->user 表中指定ip

Answer 2

GRANT ALL PRIVILEGES ON *.* TO 'username'@'172.29.8.72' IDENTIFIED BY 'password' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'username'@'192.168.3.39' IDENTIFIED BY 'password' WITH GRANT OPTION;
flush privileges;

Answer 3

`CREATE USER 'root'@'172.29.8.72' IDENTIFIED BY 'yourpass';
GRANT ALL PRIVILEGES ON . TO 'root'@'172.29.8.72';#修改权限时在后面加 WITH GRANT OPTION
CREATE USER 'root'@'192.168.3.39' IDENTIFIED BY 'yourpass';
GRANT ALL PRIVILEGES ON . TO 'root'@'192.168.3.39';
flush privileges;`