centos authentication plugin ‘caching_sha2_password’

在CentOS系统中，MySQL的认证插件'caching_sha2_password'的加载出现了错误。错误信息为ERROR 2059 (HY000): Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory。

在MySQL 8.0版本中，默认的认证插件是'caching_sha2_password'而不是'mysql_native_password'。所以，如果你想在CentOS中使用'mysql_native_password'认证插件，可以通过以下步骤进行修改：
1. 进入MySQL命令行界面：mysql -u root -p
2. 使用以下命令修改'root'用户的认证方式为'mysql_native_password'：ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'mysqlmysql';
3. 如果你想修改远程登录的'root'用户的认证方式，可以使用以下命令：ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '******';（其中******为你设置的密码）

通过以上步骤，你可以在CentOS中将认证插件修改为'mysql_native_password'，以解决'caching_sha2_password'插件加载错误的问题。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *3* [Authentication plugin ‘caching_sha2_password‘ cannot be loaded: /usr/lib64/mysql/plugin/caching_...](https://blog.csdn.net/tianlangstudio/article/details/112754979)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
- *2* [extrabackup --backup 报错 failed: Authentication plugin caching_sha2_password cannot be loaded](https://blog.csdn.net/ctypyb2002/article/details/106902258)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]