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