Article ID: 119483, created on Mar 4, 2014, last review on Nov 20, 2014

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


При резервном копировании базы данных MySQL возникает ошибка "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)


У пользователя root на упомянутом в ошибке сервере (Destination host) отсутствует полномочие Show_view_priv:

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)


Выдайте полномочие 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)

и перезапустите неудавшуюся задачу.

ac82ce33439a9c1feec4ff4f2f638899 caea8340e2d186a540518d08602aa065 5356b422f65bdad1c3e9edca5d74a1ae 2554725ed606193dd9bbce21365bed4e e12cea1d47a3125d335d68e6d4e15e07 5b048d9bddf8048a00aba7e0bdadef37

Email subscription for changes to this article
Save as PDF