The warning [MY-013360] [Server] Plugin mysql_native_password reported in your MySQL logs indicates that the mysql_native_password plugin is deprecated and will be removed in a future release. You are advised to use the caching_sha2_password authentication plugin instead.
Here's what you can do to address this warning:
Change Authentication Plugin for Users: For your own users, you can change the authentication plugin with the following SQL command:
Код |
---|
ALTER USER user IDENTIFIED WITH caching_sha2_password BY 'password';
|
Replace user with the username and password with the user's password.
Built-in Users: For built-in users like mysql.sys, mysql.session, and debian-sys-maint, you should not change the password. The method for these users will be changed by the installer when the feature is finally removed.
Suppress the Warning: If you want to suppress just this particular warning message, you can add the following line to your MySQL configuration file
Код |
---|
log_error_suppression_list='MY-013360'
|
This will prevent the warning from being logged.
Upd ate Default Authentication Plugin: If you're using a configuration management tool like Helm for Kubernetes, you can se t the default_authentication_plugin to caching_sha2_password in your configuration to prevent this warning from appearing.
Remember to back up your database before making any changes and test these changes in a development environment first. If you're not comfortable making these changes yourself, consider reaching out to a database administrator or a professional for assistance.