Nov 2, 2008I am transferring my clients sites from a shared hosting to vps, and had the following MySQL 5.0.51a database error:
CREATE VIEW command denied to user
A quick Google told me that there are issues with permissions and upgrading between MySQL versions.
use putty to ssh to your vps/dedicated server
Don't try connecting to the MySQL database, just issue the following command at the normal ssh command line:
Presto, I tried the same CREATE VIEW command MySQL command, and it worked!!!!
The command looks at all the databases on the server, and upgrades them all.