[maemo-developers] ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.so

[From: Darius Jack]

--- On Thu, 21/8/08, maemo at bitblit.net <maemo at bitblit.net> wrote:

> From: maemo at bitblit.net <maemo at bitblit.net>
> Subject: Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.so
> To: "Darius Jack" <dariusjack2006 at yahoo.ie>
> Cc: "maemo-developers at maemo.org" <maemo-developers at maemo.org>
> Date: Thursday, 21 August, 2008, 12:16 AM
> On Wed, 20 Aug 2008, Darius Jack wrote:
> 
> > any solution to a known problem ( a lot of entries in
> Google)
> > (Linux + mysql + php )
> > mysql worked worked fine, testing mysql commands
> > to create a user with select, usage privileges on a
> tabase.*
> > and it worked 
> > on shutdown
> > and reboot
> > can't run mysql
> > mysqld starts to run and stops, looking for a socket
> (none).
> 
> Im guessing the fact the unix socket is in /tmp is a
> problem because /tmp 
> is probably wiped during the boot process.
> 
> Might be better off telling MySQL to use TCP sockets and
> bind to 127.0.0.1 
> instead.
> 
> 
> -- 
> Aj.

exactly, no socket in /tmp
I don't think this error is atributed to any specific distribution
as Google gives thousands of valid links when making query for
ERROR 2002 (HY000): Can't connect to local MySQL server..

I still need smart working solution.
One implemented like uninstall, install mysql back
worked for me.
Mayby I should write a shell script, save package to local disk first
and on failed running of mysql
to perform uninstall and install procedure back.

Any other idea to set the issue self-repaired status ?

Darius
http://www.tinyurl.com/dariusjack

Send instant messages to your online friends http://uk.messenger.yahoo.com