• ADADADADAD

    Access denied; you need (at least one of) the PROCESS privilege(s)[ mysql数据库 ]

    mysql数据库 时间:2024-12-24 19:11:16

    作者:文/会员上传

    简介:

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

    点击(此处)折叠或打开[root@iZ252affh68Z ~]# innobackupex--defaults-file=/etc/my.cnf --host=10.51.xxx.xxx--user=xtra

    以下为本文的正文内容,内容仅供参考!本站为公益性网站,复制本文以及下载DOC文档全部免费。



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

    点击(此处)折叠或打开

      [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:48version_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:48version_check Connected to MySQL server
      170120 18:21:48version_check Executing a version check against the server...
      170120 18:21:51version_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 querySHOW 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';
    Access denied; you need (at least one of) the PROCESS privilege(s).docx

    将本文的Word文档下载到电脑

    推荐度:

    下载
    热门标签: accessdeniedleast