maybe im not being really direct but it’s cause im not sure how.
I got a new server, centos 5.4 installed
i have installed apache, php, mysql. everything is up and running and working fine.
i download latest.zip, set the wp-config.php as i usually do.
set up new databse, new database user with permission to all.
then when i go to the websites, Error establishing a database connection
I have another server with like 30 blogs, all set up the same way, only difference is the other one is Debian and this one is Centos.
If anyone have any idea what it could be, i have searched other posts, and read installation manual and etc yet nothing worked.
OK, so, ive been looking around a bit, same problem seem to have been resolved to many people by running this line
SET PASSWORD FOR some_user@some_host = OLD_PASSWORD(‘your_old password_here’);
Yet, it didn’t work for me, but i found how to make it work.
I changed the hosts of the mysql user i creat, instead of “any”, i set it only to “localhost” and that seem to solve the problem, not sure how it started initially cause in my other server i just put “any” and it works.
