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 >
