trying to move the site from a server running MySQL 6.0.11-alpha to a server running the CentOS MySQL 5.0.95 Source distribution.
At first, the user could not connect to this database from cmd line. Then I ran mysql_upgrade and now the user can connect from command line. But I still get the dreaded "Error establishing a database connection"
That message, "Error establishing a database connection", usually means one of two things:
1. Database server is down (not operating)
2. You have wrong information in your wp-config.php--either the DB_HOST, DB_USER, DB_PASSWORD, or DB_NAME is incorrect.
I have verified that neither of these apply. The database is up and I copied and pasted the values from wp-config to command line and they now connect successfully from cmd line, but not if i run php index.php from cmd line - that gives the db error.
I tried resetting the MySQL user's password (with PASSWORD and OLD_PASSWORD, followed by FLUSH PRIVILEGES), tried re-issuing the GRANT statement. But I get the error no matter what, whereas other wordpress sites worked even before the mysql_upgrade - very strange.
Thanks in advance for any suggestions!