Have you ever looked through your server logs and seen something like this?<\/p>\n
\n[MY-013360] [Server] Plugin mysql_native_password reported: ”mysql_native_password’ is deprecated and will be removed in a future release. Please use caching_sha2_password instead’<\/p>\n<\/blockquote>\n
This is because, as you can see in the MySQL 8.1.0 release notes<\/a>, the plugin is now deprecated.<\/p>\n
Luckily, the warning also tells you the solution – switch to
caching_sha2_password<\/code> instead. However it doesn’t tell you how<\/em> to do that.<\/p>\nThis needs to be done on a per-user basis, and you also need to know the password of the user. To find out which users to update, run the following SQL:<\/p>\n
SELECT user, host, plugin FROM mysql.user;<\/pre>\n(Note, you can enter a SQL console on the host machine with something like
mysql -u root -p<\/code>)<\/em><\/p>\nThis will give you an output something like this:<\/p>\n
mysql> SELECT user, host, plugin FROM mysql.user ORDER BY user;\n+------------------+--------------+-----------------------+\n| user | host | plugin |\n+------------------+--------------+-----------------------+\n| debian-sys-maint | localhost | mysql_native_password |\n| example_user | localhost | mysql_native_password |\n| mysql.infoschema | localhost | caching_sha2_password |\n| mysql.session | localhost | mysql_native_password |\n| mysql.sys | localhost | caching_sha2_password |\n| mysqld_exporter | localhost | mysql_native_password |\n| root | localhost | mysql_native_password |\n+------------------+--------------+-----------------------+<\/pre>\nAs you can see, some users are configured with the
mysql_native_password<\/code> plugin. All we need to do is alter the users<\/a> and update them tocaching_sha2_password<\/code>.<\/p>\nHere’s an example:<\/p>\n
ALTER USER 'mysqld_exporter'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'StrongPassword';<\/pre>\nYou might want to
FLUSH PRIVILEGES;<\/code> once you’re done.<\/p>\n","protected":false},"excerpt":{"rendered":"Have you ever looked through your server logs and seen something like this? [MY-013360] [Server] Plugin mysql_native_password reported: ”mysql_native_password’ is deprecated and will be removed in a future release. Please use caching_sha2_password instead’ This is because, as you can see … Continue reading