PJR Sales and Service - Knowledgebase - I cannot create views in MySQL

Computer Co-op, CornerNET Internet Gateway, and PJR Solutions is owned by PJR Sales & Service. Quality products and online services since 1991. We can be your
Complete Computer Connection

Hosting @ $5.95

Domains @ $16.98

Home Page

Knowledgebase
You are here: Portal Home > Knowledgebase > cPanel Related Issues > MySQL management issues > I cannot create views in MySQL

I cannot create views in MySQL

Regular MySQL users do not have privileges to create views in MySQL. If you try to execute CREATE VIEW with a regular user, you will receive the following error message:

#1142 - CREATE VIEW command denied to user 'user'@'localhost' for table 'table'

If you want to create views in your databases, you should do it with your main cPanel username. It has the necessary privileges to execute CREATE VIEW on the server.

Add to Favourites
Print this Article

Also Read

How can I import a large database to my account? PhpMyAdmin times out. (Views: 11278)

I get an error 'ACCESS DENIED CREATE DATABASE db_name' when I try to import a database (Views: 10054)

I get syntax error when trying to run a MySQL query. (Views: 1060)

I don't have enough privileges for creating/dropping databases in PhpMyAdmin (Views: 2706)

I have problems accessing my MySQL database remotely (Views: 5298)