cached_sha2_password support on MySQL 8 is broken in latest connector (8.12.1307)
Posted: Thu 10 Jan 2019 09:40
Hi. (Using 8.12.1307, download an hour ago. .NET Full)
I'm the lead dev of LLBLGen Pro and we use devart dotconnect for mysql as the ado.net provider for MySQL. A customer of ours needs to connect to a MySQL 8.0 database using an account which has 'cached_sha2_password'. We don't specify an authentication plugin in the connection string (just server, user id, port nr). This results in:
Exception type: InvalidOperationException
Unknown authentication plugin 'caching_sha2_password'.
This is odd, considering https://www.devart.com/dotconnect/mysql ... nType.html
Exception type: NotSupportedException
Keyword not supported: 'default auth plugin'.
so I'm at a loss how to use this at all. Is this even supported? Using 'Standard' as Authentication Type on the MySQL 8 user works fine.
I'm the lead dev of LLBLGen Pro and we use devart dotconnect for mysql as the ado.net provider for MySQL. A customer of ours needs to connect to a MySQL 8.0 database using an account which has 'cached_sha2_password'. We don't specify an authentication plugin in the connection string (just server, user id, port nr). This results in:
Exception type: InvalidOperationException
Unknown authentication plugin 'caching_sha2_password'.
This is odd, considering https://www.devart.com/dotconnect/mysql ... nType.html
So I tried to reproduce this and I can with a default user having 'cached_sha2_password' as authentication type set in MySQL 8. I see there's a connection string argument 'Default Auth Plugin' (https://www.devart.com/dotconnect/mysql ... nType.html), so we tried to specify ";Default Auth Plugin=cached_sha2_password" in the connectionstring, but this gives:This option may be omitted because the client may receive the name of the authentication plugin when performing handshake, but you may use this option to shorten client/server negotiation and avoid a round trip in the protocol.
Exception type: NotSupportedException
Keyword not supported: 'default auth plugin'.
so I'm at a loss how to use this at all. Is this even supported? Using 'Standard' as Authentication Type on the MySQL 8 user works fine.