I just spent 3 hours just to look at this error of wordpress, trying to figure out why the hell wordpress can’t connect to mysql. Because i created the mysql user myself, there is definitely no reason i entered the wrong password. And the mysqld daemon did run fine as i could create user and databases from the command line.
Then i went to a conclusion that WordPress may hate my box for some reason. Yes it’s a stupid idea but you never know … So i get another blogging script that i tempted to try for a long time: Chyrp. Chyrp is designed to be lightweight, the author states he aims to make as least mysql queries as possible. And it saved my day when the installation script throwed out a error that it cannot connect to the mysql.sock at /tmp .
From there it’s easy. Once you have the clue you can find the solution: a hardlink from /tmp to /var/lib/mysql/mysql.sock and bam! WordPress fully loaded …
Really, i am starting to believe that WordPress is going to be a “Windows” for blogging. Starting as an ubiquitous platform: everybody uses it and there is even a big ecosystem around. Then it grows so big that its core becomes a mess. Let see who will overcome WordPress and be “Linux” on blogging software.