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)
<HOST> "Show_view_priv" is not allowed for "root" user on the mysql side.
Please contact Odin Technical Support to fix the issue.