[Bug] MySQL 8 + nonexistent user sometimes results in auth plugin switch about trilogy HOT 1 OPEN

Nice digging!

Sometimes the test passes, but with an attempted auth switch!

Wild! I didn't realize that was an option too.

Is it possible that we shouldn't always interpret TRILOGY_PACKET_EOF as an auth switch

It's worth taking a look at what's in that packet to be sure. There's a warning in the docs about needing to check the length to make sure it's not actually some other packet that starts with an int<8>, but I am not seeing any connection-phase packets that start with an int<8> 🤷🏻‍♂️

https://dev.mysql.com/doc/dev/mysql-server/latest/page_protocol_basic_eof_packet.html

I think that, instead of skipping the conn error test, we should change it to use an existing user accouont (e.g. native) and an incorrect password, because this should still produce an access denied err without the auth switch flakiness.

👍🏻

from trilogy.