解决mysql8报错：ERROR 1410 (42000): You are not allowed to create a user with GR

Vivant

解决mysql8报错：ERROR 1410 (42000): You are not allowed to create a user with GRANT

mysql8的分配权限不能带密码隐士创建账号了，要先创建账号再设置权限

输入命令：

1. Grant all privileges on test.* to ‘test’@‘%’;

复制代码

又报错：You are not allowed to create a user with GRANT;

修改mysql数据表user中的host

1. update user set host=‘%’ where user=‘test’;

复制代码

再执行两次

1. Grant all privileges on test.* to ‘test’@‘%’;

复制代码

成功