需要在root用户下,给 test 赋予 process 权限,语句如下
GRANT PROCESS ON *.* TO 'test'@'%';
可以根据提示 赋予权限
如提示 Access Denied; you need the SYSTEM_USER privilege(s)
可以使用语句赋予 SYSTEM_USER 权限
GRANT SYSTEM_USER ON *.* TO 'test'@'%';
也可赋予所有权限
GRANT ALL privileges on *.* to 'test'@'%' with GRANT option;
撤销用户所有权限
REVOKE ALL privileges ON *.* FROM 'test'@'%';
更多推荐
Mysql8.0 错误1227 Access Denied; you need the PROCESS(SYSTEM_USER) privilege(s) 问题
发布评论