MySQL 8.4.0 error prompt Plugin' mysqlnotative_password 'is not loaded

[talksmallice]

Starting from MySQL 8.4.0, the default authentication plugin is' caching_sha2_password ', while the' mysql_cative_password 'authentication plugin is no longer enabled by default. How can I use the' caching_sha2_password 'plugin to connect now?

[tidusjar]

Has there been any progress on this?

[moemura]

execute SQL like this
ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'passwd';
Or turn on mysql_native_password

[pealmeid]

Any progress on this? On MySql server 8.4 mysql_native_password is deprecated and on 9.0 it is removed. Please provide guidance on how to proceed considering these changes.

[lauxjpn]

I am not really sure what the issue here is.

• Are you getting an exception of some sort? If so, when? (Also post the exception with the full stack trace.)
• Is this related to Pomelo? If so, please provide instructions/a minimal reproducible example for us.
• Are you trying to configure the connection string? Take a look at the supported options.
• You can find more information on the caching_sha2_password plugin in the official MySQL docs

So far, this sounds to me like you have your MySQL server (or user account) not configured correctly, in which case StackOverflow (and related sites) would be the place to ask others for help.

That being said, 8.4.1.2 Caching SHA-2 Pluggable Authentication states:

Important
To connect to the server using an account that authenticates with the caching_sha2_password plugin, you must use either a secure connection or an unencrypted connection that supports password exchange using an RSA key pair, as described later in this section. Either way, the caching_sha2_password plugin uses MySQL's encryption capabilities. See Section 8.3, “Using Encrypted Connections”.

So to properly connect, either make sure you are using an SSL/TLS connection (see the SslMode connection string option) or RSA password exchange key pair (see the ServerRSAPublicKeyFile and AllowPublicKeyRetrieval connection string options).