Bug #59792 bin/mysql -uunknown -punknown .-> using password: NO
Submitted: 28 Jan 2011 10:55 Modified: 27 Jul 2011 16:57
Reporter: Ulf Wendel Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: General Severity:S3 (Non-critical)
Version:5.5.8 OS:Any
Assigned to: CPU Architecture:Any
Triage: Needs Triage: D2 (Serious) / R6 (Needs Assessment) / E6 (Needs Assessment)

[28 Jan 2011 10:55] Ulf Wendel
Description:
MySQL 5.5.8 native password plugin returns faulty error messages. It claims that no password is given although a password has been specified.

This breaks several PHP tests.

MySQL 5.1.45 does return the correct error message.

How to repeat:
----- MySQL 5.5.8 -----

/usr/local/mysql/bin/mysql --version
/usr/local/mysql/bin/mysql  Ver 14.14 Distrib 5.5.8, for Linux (x86_64) using readline 5.1

 /usr/local/mysql/bin/mysql -uunknown -punknown
ERROR 1045 (28000): Access denied for user 'unknown'@'localhost' (using password: NO)

------ MySQL 5.1.45 ------

 /usr/local/mysql/bin/mysql --version
/usr/local/mysql/bin/mysql  Ver 14.14 Distrib 5.1.45, for suse-linux-gnu (x86_64) using readline 5.1

 /usr/local/mysql/bin/mysql -uunknown -punknown
ERROR 1045 (28000): Access denied for user 'unknown'@'localhost' (using password: YES)
[28 Jan 2011 10:59] Valeriy Kravchuk
Indeed, with 5.1.54 on port 3310 and 5.5.8 on port 3312 I see:

C:\Program Files\MySQL\MySQL Server 5.1\bin>mysql -uuu -puu -P3310 test
ERROR 1045 (28000): Access denied for user 'uu'@'localhost' (using password: YES
)

C:\Program Files\MySQL\MySQL Server 5.1\bin>mysql -uuu -puu -P3312 test
ERROR 1045 (28000): Access denied for user 'uu'@'localhost' (using password: NO)
[13 May 2011 16:26] Tim Soderstrom
This actually caused a non-trivial amount of work for me to figure out. Any work on when this will be resolved? I would think it's a simple fix. What's the point of having error reporting at all if it's totally misleading and wrong?
[27 Jul 2011 16:55] Paul Dubois
Noted in 5.5.15, 5.6.3 changelogs.

For unknown users, the native password plugin reported incorrectly
that no password had been specified even when it had.