Connections made to MySQL 8.0 (up to and including version 8.0.3) and compatibility with the new data dictionary are now supported. For information about the data dictionary, see MySQL Data Dictionary.
Support for the
caching_sha2_passwordauthentication plugin through the classic MySQL protocol was added. In addition, the
sha256_passwordplugin was extended to support authentication when RSA keys are available through non-secure connections. Caching SHA-2 pluggable authentication offers faster authentication than basic SHA-256 authentication.
Support was added for the new
caching_sha2_passwordpadding mechanism introduced in the MySQL 8.0 release series. The new padding mechanism is enabled when all of the following conditions apply:
The user account is set with the
SSL is disabled explicitly (
AllowPublicKeyRetrievalconnection option is enabled (
When enabled, the new padding mechanism is used to encode the password during RSA key encryption, which applies the correct padding to match the server.
MySqlConnection.GetSchema("PROCEDURES", restrictions)method call generated an error message, instead of returning stored procedures, when the server connection was to the MySQL 8.0 release series. (Bug #25961782)
Attempting to generate an Entity Framework model from a MySQL 5.7 database using either EF5 or EF6 produced an exception that prevented the operation from generating the expected model. (Bug #22173048, Bug #79163)