Nov 2, 2008
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.
<< SEO Articles < Healthaire Heat Pumps SEO Case Study | Revize Corneal Refractive Therapy - SEO Case Study >
1 Comments
Post Comment
We welcome comments on this article, provided they have something to contribute. Please note that all links will be created using the nofollow attribute. This is a spam free zone. HTML is stripped from comments, but BBCode is allowed.
samuel - SEO - Nov 10, 2008
SEO Search master is a one of the good website. and this site has containging all information (seo traing and seo placements,seo bussiness process). so visit this site immediately ok