Changing the mySQL connection 'socket'

[Guest daverock]

Hi there,

I need to connect to a replicated db in a new location, and the host has informed me that i need to:

--- change the connection to the DB to use the socket “/tmp/mysql2.sock†----

Have you got any ideas about how this can be done?

Let me know...

Cheers,

Dave.

[bsmither]

Seriously, just a wild-a**ed guess:

Look in your hosted space's copy of the php.ini file. (Ask your host provider where this might be.)

Two-thirds of the way to the bottom is a section called [MySQL]. Within that section is a key called "mysql.default_socket". Set the value of that key to "/tmp/mysql2.sock".

Hopefully, the php parser that interprets the code on your site will use this new version of the php.ini file. Sit back and see what blows up - or doesn't.

[Guest daverock]

thanks bsmither,

after a bit it turns out this will work in global.inc.php:

$glob['dbhost'] = ':/tmp/mysql2.sock';

works.