MySQL8.0报错:Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation

今天还原存储过程报错:

Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation

查了资料,原因是由于root用户没有SYSTEM_USER权限,把权限加入后即可解决:

grant system_user on *.* to 'root';
FLUSH PRIVILEGES;

评论

Your browser is out-of-date!

Update your browser to view this website correctly. Update my browser now

×