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:
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
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.
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' |
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.
