问题现象: mysqldump执行备份报错,但是仍然可以备份,网上找了问题原因记录一下 - mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces
复制代码
解决方法: 用root账号登录mysql - mysql> GRANT PROCESS ON *.* TO 'test'@'localhost';
- mysql> flush privileges;
复制代码
或者用户全局访问的 命令把localhost改为% - mysql> GRANT PROCESS ON *.* TO 'test'@'%';
- mysql> flush privileges;
复制代码
|