mysql.sock problem

[lbooth]

I'm doing a new install and I'm see the below error on the database set-up screen

Connection to Database failed
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

I'm using localhost for the database host (I've contacted my hosting company to confirm this) but I've read a tread about the above problem but it didn't seem to offer a solution.

I've run php info and my MYSQL_SOCKET path is /var/lib/mysql/mysql.sock is this the problem and if so what should it be and how can I change this?

I'd appreciate any help or ideas please

Cheers
Lee

[Vger]

Best to wait until your hosts get back to you with confirmation about what the correct setting is for db_server. Usually it's 'localhost' or '127.0.0.1' (the ip address of localhost), but it can be the ip address of the mysql server.

Vger

[lbooth]

Still waiting on the hosting company to get back to me (they are crap at support, aren't they all....!)

I'd of expected localhost to work like you said, am I right in thinking if the MYSQL_SOCKET path is for some reason incorrect the only fix is server side?

[DrByte]

Still waiting on the hosting company to get back to me (they are crap at support, aren't they all....!)

No, some are actually excellent.
You might try out some suggested hosts by clicking the link entitled "hosting" at the top of this page.

[DrByte]

Connection to Database failed
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

This is usually a result of a server configuration issue ...
ie: it generally seems to show up when the server is set to listen only on one protocol (sockets instead of tcp) and the PHP client/connector installed in PHP is only sending via a different protocol (ie: tcp instead of sockets).

Sorry, I can't tell you how to fix that. It would seem to be a server-side problem and not something you can deal with by changing programming code.