Bug #113730 Unable to connect to MySQL 5.1 database server with MySQL 8 client
Submitted: 23 Jan 15:30 Modified: 24 Jan 11:39
Reporter: Gareth Tunley Email Updates:
Status: Unsupported Impact on me:
Category:MySQL Server: C API (client library) Severity:S3 (Non-critical)
Version:8.0.35 OS:Any
Assigned to: CPU Architecture:Any

[23 Jan 15:30] Gareth Tunley
This was previously raised as https://bugs.mysql.com/bug.php?id=90994 and was supposedly fixed in version 8.0.35 - however I am still unable to connect to legacy databases using a MySQL 8 client.

Where as prior to 8.0.35 I was receiving a "bad handshake" error, I am now getting an authentication error:

$ mysql --verbose -h mydatabase.server.local -u myusername -p
Enter password:
ERROR 1045 (28000): Access denied for user 'myusername'@'' (using password: NO)

As can be seen - it's prompting for a password but then failing authentication saying "Using password: NO".

How to repeat:
Using a mysql client binary at version 8.0.35 attempt to connect to a MySQL 5.1 server.
[24 Jan 11:37] MySQL Verification Team
Hi Mr. Tunley,

Thank you for your bug report.

However, support for all  MySQL server 5.1 to 5.7 has expired long time ago.

Right now, only servers 8.0 and above are supported. You can connect with 5.7 client programs to 8.* servers by creating  users that use native , non-SSL protocol.

Let us also inform you that we logged in into 5.7 server with 8.0 client, without any problems !!!!

[24 Jan 11:39] Gareth Tunley
Thanks, but I still need to connect to 3rd party databases that are outside of my ability to upgrade (external systems, or vendor not providing upgrade).

You fixed the handshake bug referenced in 8.0.35 so why would you not also fix this?