MySQL Mysqldump备份时的错误提示

MySQL Mysqldump备份时的错误提示

执行mysqldump备份数据库时，命令如下：

mysqldump  -h8.137.112.148 -udbusername -pdbpassword dbname > /opt/backup_mysql/bkdata/$(date "+%Y%m%d%H%M%S")

出现以下错误：

mysqldump: Couldn't execute 'SELECT COLUMN_NAME,                       JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specified"')                FROM information_schema.COLUMN_STATISTICS                WHERE SCHEMA_NAME = 'dbname' AND TABLE_NAME = 'admin';': Unknown table 'COLUMN_STATISTICS' in information_schema (1109)

需要在命令中增加参数 --column-statistics=0

mysqldump --column-statistics=0 -h8.137.112.148 -udbusername -pdbpassword dbname > /opt/backup_mysql/bkdata/$(date "+%Y%m%d%H%M%S")

现现以下错误：

mysqldump: Error: 'Access denied; you need (at