RE: Cannot connect to MySQL (newbie)
check if mysql is running
On Fri, 3 Sep 2004 09:43:48 +0100, Graham Cossey <graham(a)cossey.plus.com>
wrote:
> I'm hoping someone can help with a problem I am having
connecting to my
> local MySQL installation.
>
> I am running FC2 and MySQL 4.0.20.
>
> When I attempt to connect to MySQL I get the following message:
>
> ERROR 2002: Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.sock' (2)
>
<snip>
Simple really isn't it... it was not running, sorry.
I found that the 'mysql' user & group did not exist, and these own the mysql
directories. So I created the user & group (with ID 27) and issued the
'/etc/init.d/mysql start' statement and it all works.
cheers
Graham