Massive repairs to MySQL server authentication

gwynne commented 4 years ago

Connecting to MySQL 8.0 servers now works over both TLS and non-TLS.
Connecting to MySQL 8.0 servers configured to use caching_sha2_password now works.
Connecting to MySQL 8.0 servers configured to use mysql_native_password by default but caching_sha2_password for specific users now works.
The "caching" part of caching_sha2_password now works.
Failing to authenticate to a server while .wait()-ing on a new connection no longer crashes.
It is no longer necessary to disable TLS certificate validation at any time (though TLS connections do still require trusted certificates).

gwynne commented 4 years ago

@0xTim I have some work to handle this issue in progress locally, should be done shortly 🙂

0xTim commented 4 years ago

If only we could wait for apple/swift-crypto#27 to be implemented and actually use it with Vapor 4!

gwynne commented 3 years ago

Closing in favor of #53

vapor / mysql-nio