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
