您现在的位置是：网站首页> 学习笔记> 数据库数据库

SQLyog连接 Mysql 8.0.11 报error no.1251- Client does not support authentic...

2021-01-02 [mysql] 3043人已围观

SQLyog连接 Mysql 8.0.11 报 error no.1251- Client does not support authentication protocol 错误原因是： mysql8 之前的版本中加密规则是mysql_native_password, 而在mysql8之后,加密规则是caching_sha2_password, 所以解决方法就是把加密规则改过来：

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root'; #随便更新个密码 

FLUSH PRIVILEGES; #刷新权限

上一篇：win10看不到win7共享的文件夹的解决方法

下一篇：使用Oracel Net Nanager配置Oracle数据库远程访问

文章评论

#2023-11-19 08:56 @ Janet：

Hello! Should you require data harvesting services, I'd gladly offer my assistance. Being proficient in this domain, I possess the knowledge and essential tools to deliver swift and precise results. This can facilitate you in deciding wisely and growing your enterprise. Feel free to reach out for any of your data scraping needs.. Progressive Information Aggregation

#2023-11-29 14:48 @ Constance：

Hello! If you need web scraping services, I'd gladly help you out. As a skilled professional in this domain, I possess the knowledge and essential tools to deliver swift and precise results. This can facilitate you in deciding wisely and growing your business. Feel free to reach out for any of your data scraping needs.. Responsive Web Crawling