I’ve just cloned this blog to a development version on my Macbook Pro. The Mac has Apache2 installed by default, so I just had to get mysql working.

Downloading MySQL and installing on Leopard is a breeze with the native package.

I migrated my database (dump/restore) and recreated my wordpress user, but still kept getting this error:

Error establishing a database connection

The user could log into the database from the console as shown:

lantrix@lexx:~ $ mysql -u wordpress -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 19
Server version: 5.1.34 MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use wordpress;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+-----------------------------+
| Tables_in_wordpress |
+-----------------------------+
| sk2_blacklist |


So what is the problem?

Google provides an answer, with a log lived post from My Macinations providing the solution. It’s all to do with correcting your php.ini with the proper MySQL socket location.

Now, back to testing my new version of the Twitter Tags wordpress plugin. #hashtags now work!