Preface - I’ve got credentials mirrored in proxysql for a mysql backend. Mysql’s backend has a default auth of native and user is configured for sha2. Proxysql is configured exactly the same as the mysql server (default native + sha2 user with same pass as mysql). I can connect to mysql directly with the mysql client and it works just fine. If I try to connect to proxysql I get an authentication error. I can connect to proxysql to users configured for native just fine.
How the heck can mysql handle this but proxysql can’t?