Cannot connect to MySQL (newbie)
graham at cossey.plus.com
Fri Sep 3 09:18:11 UTC 2004
>check if mysql is running
>On Fri, 3 Sep 2004 09:43:48 +0100, Graham Cossey <graham at cossey.plus.com>
>> 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)
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.
More information about the users