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@xxxxxxxxxxxxxxx -
- VitalStream, Inc. http://www.vitalstream.com -
- -
- The moving cursor writes, and having written, blinks on. -
----------------------------------------------------------------------
