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

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

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

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

#2023-12-16 07:05 @ Arletha：

Hello! If you need data harvesting services, I'd willingly help you out. As a skilled professional in this domain, I possess the knowledge and essential tools to provide fast and accurate data extraction. This can facilitate you in deciding wisely and growing your enterprise. Feel free to reach out for assistance with web scraping.. Targeted Content Scraping

#2023-12-18 23:29 @ Franklyn：

Greetings! If you need data harvesting services, I'd gladly offer my assistance. As a skilled professional in this domain, I possess the expertise and necessary tools to provide fast and accurate data extraction. This can aid you in making well-informed decisions and expanding your enterprise. Feel free to reach out for any of your data scraping needs.. Streamlined Content Crawling

#2024-01-17 00:58 @ Anja：

Hello! If you need data harvesting services, I'd gladly help you out. As a skilled professional in this domain, I possess the expertise and necessary 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.. Resourceful Data Scrapers

添加评论





点击排行

本栏推荐

标签云

热评文章

站点信息

  • 建站时间：2021-01-01
  • 网站程序：Django 3.1.2
  • 文章统计：53篇
  • 文章评论：35条
  • 统计数据：