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

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

[Fredrik Lundgren]

All Gentoos,

In the rebuild of my crashed Gentoo box
I recently emerged dev-db/mysql 5.0.18-r30
and defined the password for root.

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 ?

and how do I get mysql to start at boot?



Best wishes Fredrik



-- 
gentoo-user@gentoo.org mailing list

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

[A. Khattri]

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 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@gentoo.org mailing list

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

[John Jolet]

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@gentoo.org mailing list
>

-- 
gentoo-user@gentoo.org mailing list

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@jolet.net>
To: <gentoo-user@lists.gentoo.org>
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@gentoo.org mailing list
>>
>
> -- 
> gentoo-user@gentoo.org mailing list
>
>


-- 
gentoo-user@gentoo.org mailing list

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

[John Jolet]

On Feb 4, 2006, at 7:37 PM, Fredrik Lundgren wrote:

> 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?
>
not necessarily.  make sure mysql is not running.  check for the  
existence of /var/run/mysqld/mysqld.sock...if it exists, delete it.   
it shouldn't exist with mysql not running.

> Fredrik
>
> ----- Original Message ----- From: "John Jolet" <john@jolet.net>
> To: <gentoo-user@lists.gentoo.org>
> 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@gentoo.org mailing list
>>>
>>
>> -- 
>> gentoo-user@gentoo.org mailing list
>>
>>
>
>
> -- 
> gentoo-user@gentoo.org mailing list
>

-- 
gentoo-user@gentoo.org mailing list

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

[Fredrik Lundgren]

Dear list,

It appears as if mysql 5.0.18-r30
sets up:
datadir             = /var/lib/mysql-500

while my.cnf was from earlier version (I thought I deleted it with 
etc-update) indicating:
datadir            =/var/lib/mysql

After correction in my.cnf to:
datadir            =/var/lib/mysql-500

everything works OK!

Fredrik
----- Original Message ----- 
From: "John Jolet" <john@jolet.net>
To: <gentoo-user@lists.gentoo.org>
Sent: Sunday, February 05, 2006 3:13 AM
Subject: Re: [gentoo-user] ... Can't connect to local MySQL server ...


>
> On Feb 4, 2006, at 7:37 PM, Fredrik Lundgren wrote:
>
>> 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?
>>
> not necessarily.  make sure mysql is not running.  check for the 
> existence of /var/run/mysqld/mysqld.sock...if it exists, delete it. 
> it shouldn't exist with mysql not running.
>
>> Fredrik
>>
>> ----- Original Message ----- From: "John Jolet" <john@jolet.net>
>> To: <gentoo-user@lists.gentoo.org>
>> 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@gentoo.org mailing list
>>>>
>>>
>>> -- 
>>> gentoo-user@gentoo.org mailing list
>>>
>>>
>>
>>
>> -- 
>> gentoo-user@gentoo.org mailing list
>>
>
> -- 
> gentoo-user@gentoo.org mailing list
>
> 


-- 
gentoo-user@gentoo.org mailing list

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

[Harm Geerts]

On Sunday 05 February 2006 04:22, Fredrik Lundgren wrote:
> Dear list,
>
> It appears as if mysql 5.0.18-r30
> sets up:
> datadir             = /var/lib/mysql-500
>
> while my.cnf was from earlier version (I thought I deleted it with
> etc-update) indicating:
> datadir            =/var/lib/mysql
>
> After correction in my.cnf to:
> datadir            =/var/lib/mysql-500
>
> everything works OK!
You might want to have a look at the slotted mysql upgrade guide to make sure 
you've updated all the settings.
http://www.gentoo.org/doc/en/mysql-upgrade-slotted.xml
-- 
gentoo-user@gentoo.org mailing list