Knowledgebase: MySQL
CREATE VIEW command denied
Posted by WestNIC Support on 16 November 2010 09:16 AM
If you receive "CREATE VIEW command denied" within php script, please login to cPanel > PHPMyAdmin then select browse > bring table. On the bottom of the page you will see "create view" where you can set desired privileges. Please remember: there is only one way to set "create view" privileges - through PHPMyAdmin. Also, please make sure that you select "All privileges" while adding new user to DB (cPanel > MySQL > Add user to DB > tick "All privileges").

P.S. Special thanks to James, who helped us to investigate "CREATE VIEW command denied" issue.
(501 vote(s))
This article was helpful
This article was not helpful

Comments (0)
Help Desk Software by Kayako Resolve
ERROR: This domain name does not match domain registered in the license key file (, allowed domains:, please change the product path to match the domain under Admin CP > Settings > General Settings
This product will not work properly unless untill that value is changed.

For more information please contact Kayako support at