MySQL

[Rick Stevens]

Andrew Choens wrote:
> The saga continues.  But strangely seems to have a happy ending.
> 
> I don't know what the heck I did right.  I've listed my steps, as random
> as they are in the hopes that someone searching the net for this issue
> might get some help from this.  I did many things, and finally got lucky
> or something.  If you get into this situation and can't get out drop me
> an email, I learned a lot about mysql in the process of all this.
> 
> I got mad and removed the mysql rpms again.  I updated slocate with a
> slocate -u (as root) and then removed anything that even looked like
> mysql.  I deleted several directories. 
> 
> Then I reinstalled the rpms that came with fedora and then immediately
> upgraded to the latest and greatest.  I made sure that any errors
> introduced by me (intentionally or otherwise) in terms of the mysql
> directories was removed with my earlier dissection.  Ignore the stuff in
> OpenOffice.org and other programs.  Look for the stuff
> in /var, /usr/share, /etc, "etc."  Delete it all.  Just for cleanliness,
> get the lock out too.
> 
> I dunno.  It worked for me.  I don't know why.
> 
> 
> 
> On Thu, 2004-12-02 at 20:38 -0500, Andrew Choens wrote:
> 
>>On Thu, 2004-12-02 at 15:21 -0600, Richard Shade wrote:
>>
>>>I had the same problem, what I did was remove all mysql packages then I
>>>installed mysql via the FC3, CD's, then I upgraded to 4.1.7 via the
>>>mysql rpms, then I symlink libmysql.so.14 -> libmysql.so.14 so that
>>>php-mysql will work. Then I started mysql, ran
>>>mysql_upgrade_grant_tables. Everything worked great. Let me know if this
>>>helps
>>> 
>>
>>I tried going back to the 3.23 rpms on the cds.  I got them installed
>>and out of curiosity, I tried to enter via mysql.  Well, I'm still
>>getting :
>>
>>
>>>ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
>>
>>So, I've got the 3.23 rpms installed and I'm no closer.  I'm combing the mysql forums again to see if I can find something to help myself.
>>
>>There is something wrong with my system that makes it an unfriendly host for mysql.
>>
>>Any Ideas?

You have to check the my.ini file and such to ensure you are spawning
the daemon in the mode that makes it listen on the UNIX domain socket.
By default, it listens on TCP/IP sockets only.

And this is what bugs me.  The daemon, by default, goes over TCP/IP.
The mysql client defaults to Unix-domain sockets.  Go figure.
----------------------------------------------------------------------
- Rick Stevens, Senior Systems Engineer     rstevens at vitalstream.com -
- VitalStream, Inc.                       http://www.vitalstream.com -
-                                                                    -
-      The moving cursor writes, and having written, blinks on.      -
----------------------------------------------------------------------