Koozali.org: home of the SME Server

Problem with MySQL

Paolo

Problem with MySQL
« on: October 11, 2001, 02:56:45 PM »
I've a server e-smith 4.1.2.
I've installed Post Nuke and I've used it for 2 or 3 days. Now mysql show:
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

When I restart mysql I've:
Stopping MySQL:                                            [ FAILED ]
Starting MySQL:                                             [   OK   ]

I've updated mysql with MySQL-3.23.41-1 but the error remains.

Regards
Paolo

Alejandro

Re: Problem with MySQL
« Reply #1 on: October 11, 2001, 07:22:06 PM »
The socket file (mysql.sock) has been deleted
You should try next time to protect it  somehow (sticky bit or something)

I had that problem time ago but i don't remember how I solved it, Think it was with some command in mysql prompt.
Maybe I re-entered the grant sequence or something like that.
I will search my papers to see what I can find.
Ale

Paolo

Re: Problem with MySQL
« Reply #2 on: October 11, 2001, 09:02:11 PM »
Thanks Ale,

I've been resolved that problem with grant .

Regards
Paolo