mysql8 You are not allowed to create a user with GRANT 按照网上的做法update user host='%' where user='test'不行
创建用户的时候就直接创建好对应的ip
create user 'test'@'192.168.%' identified by 'test1111' PASSWORD EXPIRE NEVER;
ALTER USER 'test'@'192.168.%' IDENTIFIED WITH mysql_native_password BY 'test111';
flush privileges;
192.168.%是指对这个下面的网段都可以使用