mysql - CREATE VIEW command denied to user

I 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.

The solution:
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:

mysql_upgrade

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.

Tags: MySQL