Are you ‘root’@’localhost’ when backing up?
No.
mysqlbackup@[email protected]
And does he/you have privileges to underlying tables?
I thought so, but now that I look at these again, I believe that the problem is that this user needs execute, right? The problem is, why doesn’t this fail if run by that same user for only that view?
SHOW GRANTS;
GRANT SELECT, LOCK TABLES, SHOW VIEW ON *.* TO 'mysqlbackup'@'app02.pridedallas.com' IDENTIFIED BY PASSWORD