That's what it is beginning to smell like. I have 60days of support from RedHat. When I get to work tomorrow I will start pounding their case.
Michael Pelley wrote: > I had/have a similar problem. Originally, my RH 7.0 system worked fine. > Then with the up2date-ed patches, it failed. Finally, another up2date fixed > the problem. I ***think*** that it was something like a problem with glibc. > I did the same thing - bang my head against the wall with permissions and > that wasn't the case. Unfortunately, it seems to have reared its ugly head > again with HR 8.0... More glibc problems. > > IIRC, if you add the path to the mysql.sock file in the client's MySQL > config file (my.cnf) I think that fixes it.... > > Again - this is working on memory (my RH8 system just died from a HD > failure, so I will find out if my memory is correct once I'm back > up-and-running). > > Mike > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On > Behalf Of Terry Hobart > Sent: Sunday, January 12, 2003 8:11 PM > To: [EMAIL PROTECTED] > Subject: Re: Mysql will not answer outside localhost > > I checked all that out and even re-did some users with no luck. They all > check > out with % in the Host column and Y in all the privleges. I set this machine > up befor using the rpm directly from the mysql site and it worked fine. I > wanted to use RedHat's rpm this time because I want to maintain it with rhn. > > It just continues to give me 'Lost connection to MySQL server during query'. > > I have pinged the server and it is there. The portscanner shows the port > open. > I am VERY puzzled. Another person answered questioning DNS (which is not > yet > running on this machine) but I don't remember having to have it running when > I > did this before. Plus I am setting dbtools to go directly to the ip address > of > the mysql server. > > John Nichel wrote: > > > Did you set up the users in the user table to access from remote hosts? > > > > Try this when logged in on the local host, then restart MySQL.... > > > > INSERT INTO `mysql.user` (`Host`, `User`, `Password`, `Select_priv`, > > `Insert_priv`, `Update_priv`, `Delete_priv`, `Create_priv`, `Drop_priv`, > > `Reload_priv`, `Shutdown_priv`, `Process_priv`, `File_priv`, > > `Grant_priv`, `References_priv`, `Index_priv`, `Alter_priv`) VALUES > > ('%', 'user_to_have_outside_access', PASSWORD('your_password'), 'Y', > > 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y'); > > > > Terry Hobart wrote: > > > I have an RH 8 stock installation (meaning I have not yet updated it > > > from rhn). I had it install MySQL from the disks. I cannot however > > > access it from outside the localhost box. > > > > > > I can always access it from inside the box. > > > mysql - u root -p > > > or any other user I create @localhost > > > > > > The following is what I have installed for users: > > > > > > GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY '******' > > > WITH GRANT OPTION; > > > > > > I repeated this process for other 'outside users' replacing > > > root@localhost with test@"%" + a password and [EMAIL PROTECTED] (my > > > workstation ip on the local net). But no user password combo will allow > > > me to login from my workstation. > > > > > > The linux box is on 10.1.10.3/8 > > > > > > The my.cnf: > > > > > > [mysqld] > > > datadir=var/lib.mysql > > > socket=/var/lib/mysql/mysql.sock > > > > > > [mysql.server] > > > user=mysql > > > basedir=/var/lib > > > > > > [safe_mysql] > > > err-log=/var/log/mysql.log > > > pid-file=/var/run/mysql/mysql.pid > > > > > > I remember messing with sendmail for months with this same problem until > > > > > > I found out that on 7.3 RedHat disabled outside access by default. This > > > feels like the same thing. > > > > > > PS As a side issue is there anyway to use for example 10.0.0.0/8 or > > > equivalent. It seems to only take exact addresses instead of address > > > ranges in the GRANT line. > > > > > > > > > Thanks in advance for any help > > > > > > > > > > > > > > > > > > > -- > > By-Tor.com > > It's all about the Rush > > http://www.by-tor.com > > > > -- > > redhat-list mailing list > > unsubscribe mailto:[EMAIL PROTECTED]?subject=unsubscribe > > https://listman.redhat.com/mailman/listinfo/redhat-list > > -- > redhat-list mailing list > unsubscribe mailto:[EMAIL PROTECTED]?subject=unsubscribe > https://listman.redhat.com/mailman/listinfo/redhat-list > > -- > redhat-list mailing list > unsubscribe mailto:[EMAIL PROTECTED]?subject=unsubscribe > https://listman.redhat.com/mailman/listinfo/redhat-list -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED]?subject=unsubscribe https://listman.redhat.com/mailman/listinfo/redhat-list
