rust-mysql-simple icon indicating copy to clipboard operation
rust-mysql-simple copied to clipboard

Lake of support on sha256_password authentication plugin

Open elemount opened this issue 7 years ago • 2 comments

I'm using MySQL with sha256_password authentication plugin(https://dev.mysql.com/doc/refman/5.7/en/sha256-pluggable-authentication.html). This mainly because SHA1 which MySQL defaults is not secure. Please refer http://mysqlserverteam.com/protecting-mysql-passwords-with-the-sha256_password-plugin/ and https://blog.qualys.com/ssllabs/2014/09/09/sha1-deprecation-what-you-need-to-know I fount rust-mysql-simple do not support it which block I adopt Rust language, could you add support for sha256_password plugin?

elemount avatar Jun 21 '17 03:06 elemount

Yes. I'll implement it. According to a logic of sha256_password authentication you can use SSL connection to achieve same level of security until support is implemented.

blackbeam avatar Jun 21 '17 07:06 blackbeam

Hi. Although the sha256_password authentication plugin is not yet implemented you may be interested in switching to the caching_sha2_password plugin which is supported since v14.0.0 of the mysql crate.

blackbeam avatar Jul 02 '18 19:07 blackbeam