Re: [gentoo-user] ... Can't connect to local MySQL server ...

[Fredrik Lundgren]

Thanks for the suggestions!

The problem is that

# /etc/init.d/mysql start
*   ...
*   Starting mysql (/etc/mysql/my.cnf)
* MySQL NOT started (0)        [!!]

In my.cnf

....
....
[client]
# password                = your_password
port                            = 3306
socket                         = /var/run/mysqld/mysqld.sock
...
...

[mysqld]
...
...
user                        = mysql
port                        = 3306
socket                    =  /var/run/mysqld/mysqld.sock
....
...

So it appears that /var/run/mysqld/mysqld.sock somehow is corrupted
How should that be fixed?

Fredrik

----- Original Message ----- 
From: "John Jolet" <john@×××××.net>
To: <gentoo-user@l.g.o>
Sent: Sunday, February 05, 2006 1:40 AM
Subject: Re: [gentoo-user] ... Can't connect to local MySQL server ...


>
> On Feb 4, 2006, at 6:22 PM, A. Khattri wrote:
>
>> On Sun, 5 Feb 2006, Fredrik Lundgren wrote:
>>
>>> When I try to visit with
>>> $ mysql -u root -p
>>> password. *******
>>>
>>> I get
>>> ERROR 2002 (HY000): Can't connect to local MySQL server through
>>> socket
>>> 'var/run/mysqld.sock' (2)
>>>
>>> Evidently my configuration is wrong
>>>
>>> Has anyone a tip or two ?
>>
>> Maybe start mysqld?
>>
>> /etc/init.d/mysql start
>>
> and make sure it's still running.  and make sure there's an entry for
> the mysql client in the my.cnf pointing to the proper socket.
>>> and how do I get mysql to start at boot?
>>
>> Maybe use rc-update?
>>
>> rc-update add mysql default
>>
>>
>> (Yes, its in the handbook)
>>
>> --
>>
>> --
>> gentoo-user@g.o mailing list
>>
>
> --
> gentoo-user@g.o mailing list
>
>


-- 
gentoo-user@g.o mailing list