Dave Robbins writes.... > > 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 Yeah....looks right. WOW....still looks like a firewall problem. the server IS running, cause you can connect to it. You haven't done anything to /etc/hosts.deny and /etc/hosts.allow have you? Think by default they are empty, which should be okay. > > 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 Agreed. Telnet is ultimately going to disconnect, but you should get a connection initially anyhow. > 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 > -- Jay Crews jpc@jaycrews.com -- Psyche-list mailing list Psyche-list@redhat.com https://listman.redhat.com/mailman/listinfo/psyche-list
