MySQL

[Andrew Choens]

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?
> 
> --andy
>