I just installed the standard-4.0.11 binary and the same problem exists. Error 1130: this host is not allowed to connect. Run the grant and flush privs. Access denied...
-- Steve (egrep) On Fri, 7 Mar 2003, 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
