mysql8.0 授予用户权限 error 1410 You are not allowed to create a user with GRANT

创建名为d1的数据库

create database d1 default charset=utf8;

进入名为d1的数据库

use d1;

注意下面符合为英文

创建用户u1

create user ‘u1’@’%’ identified by ‘password’;

给d1数据库的用户u1所有权限

grant all privileges on d1.* to ‘u1’@’%’;

刷新权限

flush privileges;