Re: ERROR 1045: Access denied for user:

2003-03-07 Thread Steve Pirk
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 (ge

Re: ERROR 1045: Access denied for user:

2003-03-07 Thread Steve Pirk
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&

Re: ERROR 1045: Access denied for user:

2003-03-07 Thread Steve Pirk
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]:~$ m

RE: ERROR 1045: Access denied for user:

2003-03-07 Thread Steve Pirk
Yep, tried that... but I will try it again... -- Steve (egrep) On Thu, 6 Mar 2003, Roger Davis wrote: > Or > > mysql>> flush privileges; > > Roger > > -Original Message- > From: Ben Balbo [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 06, 2003 7:08 PM > To: MySQL List > Subject: Re: E

Re: ERROR 1045: Access denied for user:

2003-03-07 Thread Steve Pirk
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 y

Re: ERROR 1045: Access denied for user:

2003-03-07 Thread Steve Pirk
Did not see a reference to reloading tables in the docs. This is just weird enough for me to vpn in and try again :-) Thanks! -- 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 :-)

ERROR 1045: Access denied for user:

2003-03-06 Thread Steve Pirk
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.