[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: ARGGH! - User password problems
From:       "O'K Web Design" <ok-web-design () rogers ! com>
Date:       2003-07-31 20:57:06
[Download RAW message or body]

Hi

    Did you remember to flush???



----- Original Message -----
From: "Adam Fortuno KOVICK" <afortuno@comcast.net>
To: <mysql@lists.mysql.com>
Sent: July 31, 2003 4:33 PM
Subject: ARGGH! - User password problems


> All,
>
> I've been attempting to assign a password to a user with the following
> statement:
>
> UPDATE mysql.user SET password=PASSWORD('foo') WHERE user = 'acc_name';
>
> I get the typical:
>
> Query OK, 1 row affected (0.00 sec)
> Rows matched: 1  Changed: 1  Warnings: 0
>
> However, when the user attempts the login using the password they are
> unable (access is denied to acc_name with password yes). If they
> attempt to login without a password, they are successful - WTF!.
>
> There is only 1-entry in the user table for this user so I didn't
> specify a host.
>
> Next, for the same user account, if I try to login from a remote
> machine (via ODBC) I am denied access (event with the blank password!).
> The user has the following host '%' (no other hosts present), yet I
> receive an error that reads:
>
> Access denied for user: 'acc_name@192.168.0.3' (Using password: NO)
>
> HELP before I lose my mind and start pretending I am a glass of orange
> juice.
>
> Regards,
> Adam
>
>


----------------------------------------------------------------------------
----


> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/mysql?unsub=ok-web-design@rogers.com


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=mysql@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]