Both ip's are in the user table along with the % wildcard. -- Steve (egrep)
On Fri, 7 Mar 2003, gerald_clark wrote: > You grant IP address does not match the IP address of the client failing > the connection. > > Steve Pirk wrote: > > >That was a great suggestion (getting rid of the > >"blank" user), but alas, it did not work. Here > >are the three examples: (first one fail because the > >blank user was removed) > > > >[EMAIL PROTECTED]:~$ mysql > >ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) > > > >[EMAIL PROTECTED]:~$ mysql -u depot -h localhost -p > >Enter password: > >Welcome to the MySQL monitor. Commands end with ; or \g. > >Your MySQL connection id is 5711 to server version: 3.23.55 > > > >Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > > >mysql> quit > >Bye > > > >[EMAIL PROTECTED]:~$ mysql -u depot -h depotmon -p > >Enter password: > >ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using > >password: YES) > > > >-- > >Steve (egrep) > > > >On Thu, 6 Mar 2003, Paul DuBois wrote: > > > > > > > >>At 11:07 +1100 3/7/03, 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. > >>> > >>> > >>Yep, it's silly. :-) Because GRANT automatically refreshes the > >>in-memory copies of the grant tables. > >> > >>Steve, try this: > >> > >>mysql> DELETE FROM mysql.user WHERE User = ''; > >>mysql> FLUSH PRIVILEGES; > >> > >>(FLUSH PRIVILEGES *is* necessary here, because the DELETE directly modifies > >>the grant tables, and you have to tell the server to refresh the in-memory > >>copies). > >> > >>Then try to connect again. Bet it'll work. > >> > >> > >> > >>>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
