xtrabackup 需要的连接和权限

#------- 所需权限和特权  -------#

mysql -uroot -paaaaaa -e " CREATE USER 'eiscbk'@'localhost' IDENTIFIED BY 'eisc.cn';  GRANT BACKUP_ADMIN, PROCESS, RELOAD, LOCK TABLES, REPLICATION CLIENT ON *.* TO 'eiscbk'@'localhost';GRANT SELECT ON performance_schema.log_status TO 'eiscbk'@'localhost';GRANT SELECT ON performance_schema.keyring_component_status TO eiscbk@'localhost'FLUSH PRIVILEGES;"

权限说明：

BACKUP_ADMIN      # 查询 performance_schema.log_status 表，并运行

PROCESS                  # 选择查看在服务器上运行的所有线程

RELOAD                    # 始复制文件之前运行