Shulou(Shulou.com)06/01 Report--

An error was encountered while exporting a friend's database, as follows:

Click (here) to collapse or open

[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 querySHOW ENGINE INNODB STATUS: Access denied; you need (at least one of) the PROCESS privilege (s) for th

According to the prompt, the PROCESS permission is missing, and the problem is solved after it is granted.

Grant process on *. * to xtrabk@'10.51.xxx.xxx'

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.