Jump to content

Archived

This topic is now archived and is closed to further replies.

peyups

Pear connecting to mysql using a different socket

Recommended Posts

hi all,

 

m currently using the PEAR module of php4.06 on top of redhat. Our provider implemented a new installation for mysql wherein the mysql.sock file was created in another directory instead of the default (\'/tmp/mysql.sock). Using mysql_connect, this was achieved using localhost:/path/to/socket but this could not be achieved using pear class ; DB::connect(\"mysql://$dbuser:$dbpass@$dbhost:/path/to/socket/$dbname\"). I\'ve tried enclosing it in single quotes etc... it can\'t connect to that socket i think because of the forward slash (/). Any ideas? couldn\'t change the location of the mysql sockets coz we are only hosting it their.

 

All help would be very much appreciated.

 

thanks

Share this post


Link to post
Share on other sites

In the doc of PEAR :: DB, there is the following example:

Connect to database through a socket:

mysql://user:pass@unix(/path/to/socket)/pear

So basically, in your case you would have:

mysql://$dbuser:$dbpass@tcp(/path/to/socket:port):/$dbname"

Hope this helps.

 

JP.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.