CREATE VIEW command denied

[kirti]

I am getting the following error message
CREATE VIEW command denied to user 'kirti_admin'@'localhost' for table 'messages',

though i have added the user 'kirti_admin' to the database and granted all the privileges to the user.

 

[kirti]

Re: MySQL privileges issues

Please tell me how can i get all the privileges for my database.
I am denied to create or replace VIEW.

 

[vishal]

You can set your user privileges in your CPANEL . In database section.
Double check it;

 

[kirti]

Yes in the database section (in cPanel) I have selected all the privileges, still the error.
I have checked it many times.