Re: MySQL issue

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Re: MySQL issue

C. Beamer
John Jolet wrote:

>
> On Nov 3, 2005, at 1:15 PM, Jeff Smelser wrote:
>
>> On Thursday 03 November 2005 07:49 am, C. Beamer wrote:
>>
>>
>>> ERROR 2002 (HY000): Can't connect to local MySQL server through  socket
>>> '/var/run/mysqld/mysqld.sock' (111)
>>>
>>> I
>>> I do have the file /var/run/mysqld/mysqld.sock
>>>
>>
>> Thats a connection refused message.. Make sure the proper mysql
>> files are
>> there, and you may need to restart it to load your versions of the
>> grant
>> tables.
>>
> you  might also shut down mysql, verify that all processes are gone,
> and make sure that file is gone.  that file should ONLY exist while
> mysql is running.

Both of the above tips helped.  I'm not sure what happened, but I think
that mysql was not shutting down properly.  Anyway, I finally gave up,
unmerged the upgraded mysql depcleaned and then deleted a few files that
did not get removed with the unmerge process, did a fresh install of
mysql and everything seems to be working again.

Just wanted to say thanks!  :-)

Regards,

Colleen
--
[hidden email] mailing list

Reply | Threaded
Open this post in threaded view
|

Re: MySQL issue

Daniel da Veiga
I had a problem like this, using 4.1.14, it was working perfect, then,
I modified the my.cnf file, added a few things and removed a lot of
stuff there that was useless for me, heh, bad move, after that, the
init.d script for mysql failed miserably and I was unable to cleanly
start it, like you, I unmerged, removed the old config file and
emerged it again, it was back, so this time I only put some stuff I
really NEEDED and let the rest of the .cnf alone. It is working for
about 1 month now completely flawless.

On 11/4/05, C. Beamer <[hidden email]> wrote:

> John Jolet wrote:
>
> >
> > On Nov 3, 2005, at 1:15 PM, Jeff Smelser wrote:
> >
> >> On Thursday 03 November 2005 07:49 am, C. Beamer wrote:
> >>
> >>
> >>> ERROR 2002 (HY000): Can't connect to local MySQL server through  socket
> >>> '/var/run/mysqld/mysqld.sock' (111)
> >>>
> >>> I
> >>> I do have the file /var/run/mysqld/mysqld.sock
> >>>
> >>
> >> Thats a connection refused message.. Make sure the proper mysql
> >> files are
> >> there, and you may need to restart it to load your versions of the
> >> grant
> >> tables.
> >>
> > you  might also shut down mysql, verify that all processes are gone,
> > and make sure that file is gone.  that file should ONLY exist while
> > mysql is running.
>
> Both of the above tips helped.  I'm not sure what happened, but I think
> that mysql was not shutting down properly.  Anyway, I finally gave up,
> unmerged the upgraded mysql depcleaned and then deleted a few files that
> did not get removed with the unmerge process, did a fresh install of
> mysql and everything seems to be working again.
>
> Just wanted to say thanks!  :-)
>
> Regards,
>
> Colleen
> --
> [hidden email] mailing list
>
>


--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

--
[hidden email] mailing list