优测吧 TroubleShooting 连接MySQL报“Error No.2058 Plugin caching_sha2_password could not be loaded”错误的解决办法

连接MySQL报“Error No.2058 Plugin caching_sha2_password could not be loaded”错误的解决办法

点击数:5566

原因:

MySQL新版默认使用caching_sha2_password作为身份验证插件,而旧版是使用mysql_native_password

当连接MySQL时报错“plugin caching_sha2_password could not be loaded”时,可换回旧版插件。

解决方法:

1. 远程命令行登录mysql

mysql -hlocalhost -uroot -p123456 -P3306

2. 操作mysql数据库命令:

use mysql;

查看各用户名使用的身份验证插件:

mysql> select Host,User,plugin from mysql.user;                                                                        
+-----------+------------------+-----------------------+                        
| Host      | User             | plugin                |                        
+-----------+------------------+-----------------------+                        
| %         | root             | caching_sha2_password |                        
| localhost | mysql.infoschema | caching_sha2_password |                        
| localhost | mysql.session    | caching_sha2_password |                        
| localhost | mysql.sys        | caching_sha2_password |                        
| localhost | root             | caching_sha2_password |                        
+-----------+------------------+-----------------------+  

3. 修改root用户的本地和远程客户端连接的身份验证插件

本地连接:

alter user root@localhost identified with mysql_native_password by '123456'; 
FLUSH PRIVILEGES;

远程连接:

alter user root@'%' identified with mysql_native_password by '123456';
FLUSH PRIVILEGES;

4. 此时再次通过客户端登录mysql,问题解决,一切正常

本文来自网络,不代表优测吧立场,转载请注明出处:http://www.youceba.com/544/

作者: zhuifeng

上一篇
下一篇
0 0 投票数
Article Rating
订阅评论
提醒
guest
283 评论
最新
最旧 最多投票
内联反馈
查看所有评论
trackback
13 小时 前

porn watch

thank you for publish post :

trackback
6 天 前

连接MySQL报“Error No.2058 Plugin caching_sha2_password could not be loaded”错误的解决办法

http://vault.lozanotek.com/archive/2007/04/12/Thrid_ASP.NET_MVP_Expert_Chat_April_19th_1130_PST.aspx

trackback
11 天 前

连接MySQL报“Error No.2058 Plugin caching_sha2_password could not be loaded”错误的解决办法

https://www.andarina.es/2017/09/30/proxima-salida-alcala-la-real-ermitas-y-zumaques/

trackback
12 天 前

连接MySQL报“Error No.2058 Plugin caching_sha2_password could not be loaded”错误的解决办法

https://www.studiorotelli.com/lillecito-internazionale-e-il-regime-ordinario-di-responsabilita/

trackback

vidalista 20 ingredients

super vidalista

trackback

vipspark.vipspark.ru

vipspark.vipspark.ru

trackback
1 月 前

psychophysics.ru

psychophysics.ru

trackback
1 月 前

vitaliy-abdulov.ru

vitaliy-abdulov.ru

trackback
1 月 前

video.vipspark.ru

video.vipspark.ru

trackback
1 月 前

连接MySQL报“Error No.2058 Plugin caching_sha2_password could not be loaded”错误的解决办法

https://www.fabiolissi.com/giugno-htsi-unique-piece/

trackback
1 月 前

连接MySQL报“Error No.2058 Plugin caching_sha2_password could not be loaded”错误的解决办法

http://www.sjalensstjarna.se/bowenterapi/

trackback

film.poip-nsk.ru – film online

film.poip-nsk.ru – film online

trackback

poip-nsk.ru – Movie Watch

poip-nsk.ru – Movie Watch

trackback
1 月 前

连接MySQL报“Error No.2058 Plugin caching_sha2_password could not be loaded”错误的解决办法

http://www.karate-sbg.at/index.php/component/k2/item/1?start=190300

trackback
1 月 前

连接MySQL报“Error No.2058 Plugin caching_sha2_password could not be loaded”错误的解决办法

https://www.bradyhelms.com/conductive-ink-and-electrically-stimulated-healing-in-mice/

trackback

bit.ly/pamfir-pamfir-2023-ua-pamfir

bit.ly/pamfir-pamfir-2023-ua-pamfir

trackback
2 月 前

连接MySQL报“Error No.2058 Plugin caching_sha2_password could not be loaded”错误的解决办法

https://www.betnews4u.com/pamela-stevens-unveils-casino-in-downtown-las-vegas-2/

trackback
2 月 前

studio-tatuage.ru

studio-tatuage.ru

trackback
2 月 前

yug-grib.ru

yug-grib.ru

trackback
2 月 前

2023

2023

trackback

Medicines information. Long-Term Effects. aripiprazole tab 10mg side effects?

Medication dope in return patients. Cautions aripiprazole tab 10mg side effects?

trackback
5 月 前

tqmFEB3B

tqmFEB3B

trackback

Medicine information leaflet. What side effects can this medication cause? paxil?

Medicines message for the sake of patients. Cautions. how much is paxil pills?

trackback
5 月 前

fildena canada

fildena usa

trackback

Pills information. What side effects? paroxetine 10 mg?

Pills advice leaflet. Cautions. paxil withdrawal symptoms?

trackback
5 月 前

klondayk2022

klondayk2022

trackback
5 月 前

irannews.ru

irannews.ru

trackback

Pills communication sheet. Brand names. where to buy propecia without prescription?

Medication dope in return patients. Cautions cost of propecia pill?

trackback
5 月 前

uluro-ado

uluro-ado

trackback
5 月 前

rusnewsweek

rusnewsweek

trackback
5 月 前

24hours-news

24hours-news

trackback
icf
5 月 前

icf

icf

slot slot
5 月 前

slot สล็อตออนไลน์ ยอดนิยม เล่นได้เงินจริง เล่นได้บน โทรศัพท์มือถือ รองรับทุกระบบ สมัครเป็นสมาชิกใหม่ รับโบนัสฟรี 100% ที่ PG เดียวของโลก เกมสล็อตออนไลน์ เป็นที่นิยมมหาศาล

ทดลองเล่นสล็อต pg ไม่ เด้ง

ทดลองเล่นสล็อต pg ไม่ เด้ง เคยเป็นไหมทดลองเล่นสล็อตออนไลน์บนเว็บพนันออนไลน์ ลองเล่นเกมใหม่ๆ เกมภาพสวยๆ เล่นได่แปบเดียวก็เด้ง ต้องมาทดลองเล่นที่เราเลย กับ PG-SLOT.GAME

trackback

Can you see eggs in period blood where can i get viagra pills?

How many times a man falls in love viagra canadian pharmacy no prescription?

trackback
www
5 月 前

www

www

trackback
5 月 前

bep5w0Df

bep5w0Df

trackback
6 月 前

连接MySQL报“Error No.2058 Plugin caching_sha2_password could not be loaded”错误的解决办法

https://safe.africa/index.php/sample-page/

trackback

Why am I losing strength in my legs what happens if a woman takes viagra pills?

How long is washed sperm good for in uterus where do i get viagra?

trackback
6 月 前

连接MySQL报“Error No.2058 Plugin caching_sha2_password could not be loaded”错误的解决办法

https://www.fundamental.is/emma-moore-of-fundamental-inc-mentioned-in-aol-business-article-for-texting-etiquette/

trackback

What is the main cause of vitamin B12 deficiency and the hoodia gordonii gnc?

Can you get Phentermine over the counter and diet pill that really works?

trackback
6 月 前

bit.ly/3GQNK0J

bit.ly/3GQNK0J

trackback
6 月 前

bit.ly/3ig2UT5

bit.ly/3ig2UT5

trackback

vidalista-20 centurion laboratories

vidalista 20mg

trackback
6 月 前

bit.ly/3ARFdXA

bit.ly/3ARFdXA

trackback
6 月 前

bit.ly/3gGFqGq

bit.ly/3gGFqGq

trackback
6 月 前

bit.ly/3OEzOZR

bit.ly/3OEzOZR

trackback

How many cigarettes are in a vape zyban drug?

Which CBD is best to quit smoking cost of zyban?

trackback

What are the signs of love in a woman and buying kamagra online?

How can I find I am in love and ajanta kamagra?

trackback

What is romance to a woman and does cialis keep you hard after coming?

What is a low value woman without cialis price per pill?

返回顶部
283
0
希望看到您的想法,请您发表评论x