Search Engine: Elastic
  • Article for your preferred language does not exist. Below is international version of the article.

Article ID: 119483, created on Jan 5, 2014, last review on Nov 19, 2014

  • Applies to:
  • Operations Automation 5.5
  • Operations Automation 5.4


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/ '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)


On <HOST> "Show_view_priv" is not allowed for "root" user:

mysql> SELECT * FROM mysql.user WHERE User = 'root' and Host = '<IP>'\G;
*************************** 1. row ***************************
                 User: root
             Password: ************************
       Show_view_priv: N         <<=============== Set to "NO"
1 row in set (0.01 sec)


Allow "Show_view_priv":

mysql> update mysql.user set Show_view_priv = 'Y' where user = 'root' and Host = '<IP>';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> flush privileges;
Query OK, 0 rows affected (0.04 sec)

and resubmit the failed task.

ac82ce33439a9c1feec4ff4f2f638899 caea8340e2d186a540518d08602aa065 5356b422f65bdad1c3e9edca5d74a1ae 2554725ed606193dd9bbce21365bed4e e12cea1d47a3125d335d68e6d4e15e07 5b048d9bddf8048a00aba7e0bdadef37

Email subscription for changes to this article
Save as PDF