大橙子网站建设,新征程启航

为企业提供网站建设、域名注册、服务器等服务

Accessdenied;youneed(atleastoneof)thePROCESSprivilege(s)

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

点击(此处)折叠或打开

公司主营业务:做网站、成都网站制作、移动网站开发等业务。帮助企业客户真正实现互联网宣传,提高企业的竞争能力。创新互联公司是一支青春激扬、勤奋敬业、活力青春激扬、勤奋敬业、活力澎湃、和谐高效的团队。公司秉承以“开放、自由、严谨、自律”为核心的企业文化,感谢他们对我们的高要求,感谢他们从不同领域给我们带来的挑战,让我们激情的团队有机会用头脑与智慧不断的给客户带来惊喜。创新互联公司推出通州免费做网站回馈大家。

  1. [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
  2. 170120 18:21:48 innobackupex: Starting the backup operation

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

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

新闻名称:Accessdenied;youneed(atleastoneof)thePROCESSprivilege(s)
分享路径:http://dzwzjz.com/article/ppocep.html
在线咨询
服务热线
服务热线:028-86922220
TOP