views:

31

answers:

1

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.

A: 

What version of cpanel are you using? I mine, I go to MySQL databases. All your tables are listed with users who have privileges on those tables and the users are links. When you click on one of the links, it takes you to a list of privileges that are checkboxes. Couldn't be simpler, all though I find it difficult to trust something that makes my privilege handling so simple!

Is it possible that you don't have the grants yourself to give grants?

tandu
I am using cpanel 11. And I think I have the same thing, but I do not think by selecting all privileges it allows create view. If you check I don't think it is in the list.
qw3n