Take a look at your user table in the mysql db. Make sure they are listed properly as being able to access from their computer. If they are listed as being able to access from their computer, list their computer's name in the /etc/hosts file along with their IP just to make sure it is not some dns issue. They should then definitely be able to connect.
Larry S. Brown Dimension Networks, Inc. (727) 723-8388 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Terry Hobart Sent: Saturday, January 11, 2003 7:29 PM To: RedHat Users Forum RedHat Subject: Mysql will not answer outside localhost 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 -- 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
