mysqlphpmyadmincpanelmysql-error-1044

Granting the create view privilege in mysql using cpanel/phpMyAdmin

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)'

Solution

  • As best I can tell this isn't possible with some configurations.