I am using cpanel and I wanted to grant a user create view
privileges. When I created the user and database in cpanel it did not have an option for that.
So I tried to do it in phpMyAdmin using :
GRANT CREATE VIEW ON (dbname).* TO '(db username)'@'localhost';
and I get the error:
#1044 - Access denied for user '(host username)'@'localhost' to database '(dbname)'
As best I can tell this isn't possible with some configurations.