mysql8 You are not allowed to create a user with GRANT

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.%是指对这个下面的网段都可以使用

已标记关键词 清除标记
©️2020 CSDN 皮肤主题: 编程工作室 设计师:CSDN官方博客 返回首页