MySQL Forums
Forum List  »  Quality Assurance

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11)
Posted by: Stephan Craft
Date: July 15, 2008 10:04PM

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.


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

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 4.4.8 (cli) (built: Feb 16 2008 12:49:24)
Copyright (c) 1997-2008 The PHP Group
Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies
with eAccelerator v0.9.5.2, Copyright (c) 2004-2006 eAccelerator, by eAccelerator
with Zend Extension Manager v1.2.0, Copyright (c) 2003-2006, by Zend Technologies
with Zend Optimizer v3.2.8, Copyright (c) 1998-2007, by Zend Technologies

Please help me solve this problem.


Edited 3 time(s). Last edit at 07/15/2008 10:19PM by Stephan Craft.

Options: ReplyQuote

Written By
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11)
July 15, 2008 10:04PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.