MySQL Bugs: #113271: Error with authentication vanilla conf

Bug #113271	Error with authentication vanilla conf
Submitted:	29 Nov 2023 0:59	Modified:	30 Nov 2023 13:38
Reporter:	Emanuel Gianico	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Router	Severity:	S2 (Serious)
Version:	8.2.0	OS:	Debian
Assigned to:	MySQL Verification Team	CPU Architecture:	Any

Description:
I bootstrapped mysqlrouter normally, without any error to try the new feature for r/w splitting but i faced with this error when connecting to the port :6450

ERROR 1045 (28000): Access denied for user 'xxx'@'192.168.10.61' (using password: NO)

This doesn't happen with the other ports -:6446, :6447- works fine.

I suspect maybe the problem is with the following variables:

client_ssl_mode=PREFERRED
server_ssl_mode=PREFERRED

required by access_mode=auto

Is this intended? I check my mysql-server and it doesn't use SSL for auth. Neither the mysql client. 
I'm using mysql_native_password. My MySQL server is 8.0.35. 

How to repeat:
Just install vanilla mysql-router-8.2.0 and try to connect to a mysql 8.0.35 with mysql_native_password

Hi Mr. Gianico,

Thank you for your bug report.

However, SSL encryption is obligatory as native passwords are not supported any more.

This requires a confirmation from our specialists for the router.

Okay, I understand. it should be remarked in the documentation to avoid this kind of confusions.

Thanks,
Emanuel.

Hi,

If you look at https://dev.mysql.com/doc/refman/8.0/en/native-pluggable-authentication.html

" As of MySQL 8.0.34, the mysql_native_password authentication plugin is deprecated and subject to removal in a future version of MySQL.  "