Tried this... no go... The wierd part, is that localhost works fine, but I cannot connect locally if I use the hostname. Thanks for the help!
(maybe I should go back to an old version of mysql :-) -- Steve (egrep) On Fri, 7 Mar 2003, Ben Balbo wrote: > Hi Steve, > > Really silly question, but you are reloading the tables once you > change the grants, aren't you :-) > > mysqladmin -p reload > > B. > > In response to your mail sent on Friday, March 07, 2003 at 10:48:06 AM. > > > Mysql version 3.23.55 Slackware linux 8.0 > > Mysql version 3.23.55 OpenBSD > > > I have tried 3 versions of mysql on linux and > > on OpenBSD. I have even tried compiling on linux > > from the source tarball. > > > Without the GRANT privs to allow network access: > mysql>> GRANT ALL PRIVILEGES ON db.* > > -> TO user@'192.58.197.0/255.255.255.0'; > > (example), I would get a "you are not allowed to connect" > > error. Once I applied the grant to the user: > mysql>> GRANT ALL PRIVILEGES ON db.* > > -> TO user@'%' > > the users table shows: > > | Host | User | > > --------------------------------------- > > | % | user | > > > If I coonect to the database without a host, or > > with host set to localhost, I can connect fine. If > > I connect from another machine, or just use the DNS > > name on the local machine, I get: > > <shell> mysql -h 192.168.1.24 -u test -p > > > ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using > > password: YES) > > > I have even tried connecting using the IP address. I have poured > > over the docs, and have tried all the scenarios of add hostnames > > to /etc/hosts etc. I even complied from source (glibc problem). > > No luck at all... Any ideas? I really need network access to the > > database. > > -- > > Steve (egrep) > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
