mysql8限制IP远程访问

1、新建用户并限制IP访问所有数据库

drop user 'test'@'183.195.3.117';
CREATE user 'test'@'183.195.3.117' IDENTIFIED by 'Master@2222';
GRANT ALL on *.* TO 'test'@'183.195.3.117';
flush privileges;

2、更新用户并限制IP访问test库

update user set host='183.195.6.199' where user='test' and host='localhost';
GRANT ALL on test.* TO 'test'@'183.195.6.199';
flush privileges;

3、新建用户不限IP访问任何数据库

CREATE user 'test'@'%' IDENTIFIED by 'Master@2222';
GRANT ALL on *.* TO 'test'@'%';
flush privileges;

对用户授权，允许指定用户远程访问，最简单的方式是将mysql库中user表中的对应的用户的host设置为%，亦即允许该用户从任意ip远程访问