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

root@% 无法修改 root@localhost 密码

解决办法：（自己给自己授权）

grant system_user on *.* to 'root';

https://blog.csdn.net/weixin_42330311/article/details/104728396