damned, don't make me use that security tool again lost all connection to the web! yikes, that sucked seems to be back to normal now my understanding is that if I want a user foo to be able to connect from a remote client, I need to grant all on *.* to foo@localhost identfied as bar grant all on *.* to foo@192.168.10.% identidied as bar for use/passwd foo/bar that syntax might not be perfect but you get the point from the local machine I can connect as foo with no problem I really don't think it's a permission issue because of the way telnet acts from the remote client, it exits immediately I think I had this prob a long time ago on a diferent machine and the solution was some command to mysql I think it;s just not answering on that port Dave On Tue, 2003-01-28 at 18:24, Jay Crews wrote: > Dave Robbins writes.... > > > > > > I'm pretty sure when I installed I picked no firewall > > I'm behind the router and I figured it did the job > > I went to the security GUI tool thingy and it said security is set on > > high. I'm running apache/postfix and can use ftp, ssh > > I set the security level to none and clicked "make it so" > > I re-entered the GUI tool and the level was still set to high > > somethin ain't right > > stay tuned for the next installment > > Yeah....that's something that > has been pointed out a few times here. > The tool doesn't read the current setting. It just > defaults to high when you start the tool. > But if you set it to none, that should be okay....I guess. > > But I think you can simply turn off/on iptables with the > 'service' command too, without changing any of the specific > filters. When I do, "chkconfig --list | grep ^ip" I get, > > ==> ip6tables 0:off 1:off 2:on 3:on 4:on 5:on 6:off > ==> ipchains 0:off 1:off 2:on 3:on 4:on 5:on 6:off > ==> iptables 0:off 1:off 2:on 3:on 4:on 5:on 6:off > > I think you can just toggle these on or off with, > "service iptables off" without messing with the actual rules. > If after turning it off, it works, then you'll have to figure out > the specific rules. > > > But lets assume the firewall is ok (since that is your thought.) > You did do the MySQL GRANTS correctly for the USER/HOST that you are trying > to come in on. You realize there is a "pairing" thing going on there, right? > > Another question........are you able to connect as a user, other than root > or the default MySQL login, to the database? > ie Create a MySQL user, give him a passwd, and login from the localhost. > (Be sure to do it from localhost so we can narrow that part down.) > > How are you trying to login? > >From another Linux box on the LAN with something like, > mysql -ujoe_user -h192.168.1.10 -p > > -- Jay Crews > jpc@jaycrews.com > > > > -- > Psyche-list mailing list > Psyche-list@redhat.com > https://listman.redhat.com/mailman/listinfo/psyche-list -- Psyche-list mailing list Psyche-list@redhat.com https://listman.redhat.com/mailman/listinfo/psyche-list
