25
2023
04
25
2023
04
error 2059: Authentication plugin ‘caching_sha2_password‘ cannot be loaded: /usr/lib64/mysql/plugin/
报错内容
error 2059: 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
作者:hqy | 分类:技术文章 | 浏览:820 | 评论:0
25
2023
04
MySql错误 1251 - Client does not support authentication protocol requested by server 解决方案
一、问题描述
使用Navicat客户端连接本地mysql,报错:1251- Client does not support authentication protocol requested by server;consider upgrading Mysql client。
作者:hqy | 分类:技术文章 | 浏览:1714 | 评论:0
25
2023
04
25
2023
04
解决mysql: [Warning] World-writable config file ‘/etc/mysql/mysql.conf.d/mysqld.cnf ‘ is ignored.问题
问题描述:
将/etc/mysql/mysql.conf.d/mysqld.cnf这个文件修改权限sudo chmod 777 mysqld.cnf,且重启数据库后,再次执行mysql -u root -p时,出现此警告。
#问题描述:
queena@queena-Lenovo:/etc/mysql/mysql.conf.d$ sudo chmod 777 mysqld.cnf
queena@queena-Lenovo:/etc/mysql/mysql.conf.d$ vim mysqld.cnf
作者:hqy | 分类:技术文章 | 浏览:939 | 评论:0