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:
Category:MySQL Router Severity:S2 (Serious)
Version:8.2.0 OS:Debian
Assigned to: MySQL Verification Team CPU Architecture:Any

[29 Nov 2023 0:59] Emanuel Gianico
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'@'' (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:


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
[29 Nov 2023 11:28] MySQL Verification Team
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.
[29 Nov 2023 17:22] Emanuel Gianico
Okay, I understand. it should be remarked in the documentation to avoid this kind of confusions.

[30 Nov 2023 13:38] MySQL Verification Team

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