DRUPAL PROBLEM: Can't connect to local MySQL server through socket <span title="'/var/run/mysqld/mysqld.sock'">'/var/run/mysqld/mysqld.s...</span> (2)?

Question

I've been trying to solve this problem for ages. I've trawled the web and it seems lots of people are having the same problem....yet nobody can seem to answer it. I've just downloaded Drupal 6.4 released two days ago.

I get this problem when I try to set up the database on the drupal installer. It appears to be looking for this mysql.sock file that isn't there. In fact the not even the preceeding folders (var/run/mysqld) are there.

Before anybody asks, yes mysql is running and the database name and password are correct.

Can somebody with big brains finally put this problem to bed for the rest of us?!?!?

Answer 1

First you need to find out where the mysqld.sock file is being created. Once you have all you need to do is create a symlink to the location of your socket in /var/run/mysqld/.

ln -s [path to your mysqld.sock file] /var/run/mysqld/mysqld/mysqld.sock

I am unsure where your mysqld.sock file is located since it changes from system to system.

You could also change the path of the sock file when mysqld starts but this could break other things.