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
