Connecting to MySQL with alternate sock

[jameseymour]

Hello,

I have taken a look around and haven't found an answer suitable for me.

I need to connect to a MySQL db through an alternate sock file. I can not edit any php config files like php.ini. I tried the following just hoping it would work...but it didn't.

$connection = mysql_connect('/export/home/stauffer/web/www-data/tmp/mysql.sock', 'username', 'password');
if (!$connection) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($connection);

Is there a way to point to a different sock file in php? Thanks.

[NogDog]

Maybe try this variant?

 $connection = mysql_connect('localhost:/export/home/stauffer/web/www-data/tmp/mysql.sock', 'username', 'password');

[jameseymour]

Thanks boss, worked like a dream.

[bradgrafelman]

Don't forget to mark this thread resolved.