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

甲骨文技術支援發表於2017-01-22
AST


在幫一個朋友的資料庫匯出的時候遇到錯誤，如下：

點選(此處)摺疊或開啟

  1. [root@iZ252affh58Z ~]# 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
  2. 170120 18:21:48 innobackupex: Starting the backup operation

  4. IMPORTANT: Please check that the backup run completes successfully.
  5.            At the end of a successful backup run innobackupex
  6.            prints "completed OK!".

  8. 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).
  9. 170120 18:21:48 version_check Connected to MySQL server
  10. 170120 18:21:48 version_check Executing a version check against the server...
  11. 170120 18:21:51 version_check Done.
  12. 170120 18:21:51 Connecting to MySQL server host: 10.51.xxx.xxx, user: xtrabk, password: set, port: 3306, socket: /mnt/mysql/mysql.sock
  13. Using server version 5.7.12-log
  14. Error: failed to execute query
  15. 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';

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/20893244/viewspace-2132811/，如需轉載，請註明出處，否則將追究法律責任。

相關文章