Bug #59792 bin/mysql -uunknown -punknown .-> using password: NO

• Submitted: 28 Jan 2011 10:55
• Modified: 27 Jul 2011 16:57
• Reporter: Ulf Wendel
• Status: Closed
• Category: MySQL Server: General
• Severity: S3 (Non-critical)
• Version: 5.5.8
• OS: Any
• CPU Architecture: Any

[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.