MySQL connection error on drupal system

Solution 1:

From here : http://answers.yahoo.com/question/index?qid=20080815175416AAN41y6

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.

from here: http://drupal.org/node/73103

in your drupal folder (already on your server) update your /sites/default/settings.php file where $db_url = 'pgsql://username:password@localhost/databasename'; change to: $db_url = 'pgsql://username:[email protected]/databasename';

Hope that helps