database connect problems

[filch]

Ran into an unusual issue here connecting to a database. I am getting the following error after setting up the connection info in the install script:

The following error occurred:

Sorry, we were unable to connect to the database using the information you supplied. The error message the database returned is: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Please double-check your database settings and click the Continue button again.

I am able to connect using a standard connection script like:

Code:

<?php
$link = mysql_connect('invincinetcom.domaincommysql.com', 'invincinetcom', '#########!');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_select_db(########);
?>

Any ideas on this?

Dave

[mrGarvin]

Are you using a a service like MAMP or WAMP? Sounds like a typical problem with the changes made to the location of the MySQL socket.

Do a web search for "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock" together with your system (MAMP, WAMP) and you will find the solution...I don't think it has anything to do with FormTools.