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)'
I have tried a number of different ways to do this, but I am not finding a solution.