Re: ERROR 1045: Access denied for user:

[gerald_clark]

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