Home / server / Questions / 223467
Accepted
Jason Swett
Asked: 2011-01-18 10:10:41 +0800 CST

View-related privileges in MySQL

  • 772

How do I grant view-related privileges to a user in MySQL (without granting all privileges)? I get this error when I try to do a mysqldump:

mysqldump: Couldn't execute 'show create table `view_household`': SHOW VIEW command denied to user 'backup'@'localhost' for table 'view_household' (1142)
mysql

1 Answers

  1. Best Answer

    grant show view on *.* to 'backup'@'localhost'

    • 11