MySQL Bugs: #113730: Unable to connect to MySQL 5.1 database server with MySQL 8 client

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

Description:
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'@'192.168.1.98' (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.

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 !!!!

Unsupported.

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?