Access denied; you need (at least one of) the PROCESS privilege(s)

发布时间：2020-08-07 08:50:20 来源：ITPUB博客阅读：2159 作者：dbasdk 栏目：MySQL数据库

在帮一个朋友的数据库导出的时候遇到错误，如下：

点击(此处)折叠或打开

[root@iZ252affh68Z ~]# innobackupex --defaults-file=/etc/my.cnf --host=10.51.xxx.xxx --user=xtrabk --password=xxxxxx --stream=tar /tmp | gzip > /mnt/backup/mysql_full/xtra_fullbak_2017-01-20.tar.gz
170120 18:21:48 innobackupex: Starting the backup operation
IMPORTANT: Please check that the backup run completes successfully.
At the end of a successful backup run innobackupex
prints "completed OK!".
170120 18:21:48 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;host=10.51.xxx.xxx;port=3306;mysql_socket=/mnt/mysql/mysql.sock' as 'xtrabk' (using password: YES).
170120 18:21:48 version_check Connected to MySQL server
170120 18:21:48 version_check Executing a version check against the server...
170120 18:21:51 version_check Done.
170120 18:21:51 Connecting to MySQL server host: 10.51.xxx.xxx, user: xtrabk, password: set, port: 3306, socket: /mnt/mysql/mysql.sock
Using server version 5.7.12-log
Error: failed to execute query
SHOW ENGINE INNODB STATUS: Access denied; you need (at least one of) the PROCESS privilege(s) for th

根据提示是缺少PROCESS权限，赋予后问题解决

grant process on *.* to xtrabk@'10.51.xxx.xxx';

向AI问一下细节

猜你喜欢