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

[Stephan_Craft]

I use mysql 3.5 years and recently I have a very frustration problem!

Here’s what I get from time to time:

SQL error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11)

SQL error code:

Date: Monday 14th of July 2008 10:06:25 PM

 

I try to increase - max_connections=1000, but nothing…

In /etc/my.cnf file mysql.sock direction is right.

 

[mysqld]

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

 

someone write that it can be because of the localhost, so I try this

bind-address=My-Server-IP

 

but still this error appears((

 

I notice another thing, when my DB size was over 2GB, I start to get this error… maybe this is a coincident I don’t know.

 

this is mysql status:

mysql Ver 14.7 Distrib 4.1.22, for unknown-linux-gnu (x86_64) using readline 4.3

 

Connection id: 808144

Current database: sadmin_fou

Current user: sadmin_fou@localhost

SSL: Not in use

Current pager: stdout

Using outfile: ''

Using delimiter: ;

Server version: 4.1.22-standard

Protocol version: 10

Connection: Localhost via UNIX socket

Server characterset: latin1

Db characterset: latin1

Client characterset: latin1

Conn. characterset: latin1

UNIX socket: /var/lib/mysql/mysql.sock

Uptime: 5 hours 45 min 22 sec

 

PHP:

PHP 4.4.8 (cli) (built: Feb 16 2008 12:49:24)

Copyright © 1997-2008 The PHP Group

Zend Engine v1.3.0, Copyright © 1998-2004 Zend Technologies

with eAccelerator v0.9.5.2, Copyright © 2004-2006 eAccelerator, by eAccelerator

with Zend Extension Manager v1.2.0, Copyright © 2003-2006, by Zend Technologies

with Zend Optimizer v3.2.8, Copyright © 1998-2007, by Zend Technologies

 

 

Please help me solve this problem.

 

 

Regards,

Stephan.

[AjBaz100]

on the end of your connection string you could try putting the path to the socket.

[fenway]

Have you looked through this?