摘要：
报错提示升级mysql到5.7后 在导出数据库的是提示如下报错mysqldump: Error: 'Access denied; you need (at least on... 报错提示
升级mysql到5.7后 在导出数据库的是提示如下报错
mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces
解决办法
用户只有本机可以访问的执行如下命令授权PROCESS 权限
mysql> GRANT PROCESS ON *.* TO '数据库用户名'@''localhost''; Query OK, 0 rows affected (0.00 sec) mysql> flush privileges; Query OK, 0 rows affected (0.00 sec).
用户全局可以访问的执行如下命令授权PROCESS 权限
mysql> GRANT PROCESS ON *.* TO '数据库用户名'@''%''; Query OK, 0 rows affected (0.00 sec) mysql> flush privileges; Query OK, 0 rows affected (0.00 sec).
