Granting the create view privilege in mysql using cpanel/phpMyAdmin

mysql phpmyadmin cpanel mysql-error-1044
qw3n picture qw3n · Oct 10, 2010 · Viewed 7.9k times · Source

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

Answer

Explosion Pills picture Explosion Pills · Oct 10, 2010

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?

Related questions

#1273 - Unknown collation: 'utf8mb4_unicode_ci' cPanel

I have a WordPress database on my local machine that I want to transfer to a hosted phpMyAdmin on cPanel. However, when I try to import the database into the environment, I keep getting this error: #1273 - Unknown collation: 'utf8…

Read More
#1044 - Access denied for user 'someusr'@'localhost' to database 'somedb'

I'm trying to give admin rights to MySQL user using this SQL statement ran on cpanel>phpmyadmin>SQL GRANT ALL PRIVILEGES ON somedb.* TO 'someusr'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION; but it's giving user denied error: #1044 …

Read More
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I installed LAMP on Ubuntu 12.04 LTS (Precise Pangolin) and then set root password on phpMyAdmin. I forgot the password and now I am unable to login. When I try to change password through terminal I get: ERROR 2002 (HY000): Can't connect …

Read More