[SOLVED] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

Burningmace · 09-08-2009, 03:30 PM

My website's hosting is throwing the following error when trying to connect via a subdomain using 'localhost' as the MySQL host:

Code:

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

On other subdomains, we connect to MySQL using the full URL (e.g. forums.domain.com) but when I do that with this new domain I get the following error:

Code:

Lost connection to MySQL server at 'reading initial communication packet', system error: 111

I also tried using "domain.com" as the server, and that also resulted in an error 111.

Any ideas?

alexroux · 09-09-2009, 04:27 AM

The first error (2 -> No such file or directory ) comes from the fact that you have no mysql server running on localhost.

The second one (111 -> Connection refused) shows that either mysql port is blocked (firewall for instance) or that no mysql server is running on forums.domain.com.

Are you sure that the machine with mysql server is reachable from your new subdomain? If not, you have found your problem. Be also sure to use the correct url to join the mysql server.

Burningmace · 09-10-2009, 06:15 AM

For some reason when we deleted the schema and the associated MySQL account from their control panel and then re-created it, it worked fine. Doesn't really make any sense at all, but our hosting is often quite glitchy with stuff like this. I get the feeling that the config files weren't updated properly to allow access to the other domain.

xiutuo · 09-11-2009, 01:41 AM

I think there are two mysql server...
and the lib file: libmysqlclient.so** at the same path .
1. mysql server one: install by yum or rpm with os cdrom
2. mysql server two: install by source...
there are infilct between the mysqlclient.so