Symptoms

MySQL database backup task failed with "Couldn't execute 'show create table object_2': SHOW VIEW command denied to user 'root'@'IP' for table 'object_2' (1142)":

Task name       Backup '<DB_NAME>' into group '<GROUP>'
Last execution output   Destination host '<HOST>' (#27), IP '<IP>' : Internal error: /bin/sh /bin/sh -c /usr/local/pem/bin/mysql_backup.sh 'root' '' <IP> 3306 '<DB_NAME>' '/usr/local/pem/Backups/database/backup_data' failed with code 2 saying: STDOUT: '' STDERR 'mysqldump: Couldn't execute 'show create table `object_2`': SHOW VIEW command denied to user 'root'@'<IP>' for table 'object_2' (1142)

Cause

On <HOST> "Show_view_priv" is not allowed for "root" user on the mysql side.

Resolution

Please contact Odin Technical Support to fix the issue.

Internal content

Link on internal Article