优测吧 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”错误的解决办法

点击数:1926

原因:

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
123 评论
最新
最旧 最多投票
内联反馈
查看所有评论
trackback

hydroxychloroquine drugs

hydroxychloroquine weight loss

trackback

hydroxychloroquine news

hydroxychloroquine used to treat

trackback

stromectol usa

ivermectin 200

trackback
27 天 前

cialis over the counter

cialis over the counter at walmart

trackback
28 天 前

ivermectin msds

otc ivermectin

trackback

ivermectin horse paste for humans

ivermectin 0.08 oral solution

trackback
29 天 前

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

http://uuphost.org/stonybrookhsc/individual-development-award/

trackback

ivermectin prescription

ivermectin at tractor supply

trackback

ivermectin resistance

ivermectin price canada

trackback

ivermectine vente libre

how to order ivermectin online

trackback

walmart cost for cialis

cialis prices at walmart pharmacy

trackback
1 月 前

lucky slots

lucky lands

trackback
1 月 前

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

https://www.terminallaplata.com/component/k2/item/43-circular-conjunta-0000001-del-11-de-marzo-del-2020.html?start=60530

trackback

stromectol without prescription

cost of stromectol

trackback

stromectol usa

ivermectin 3mg

trackback

ivermectin 3 mg

ivermectin covid

trackback

ivermectin 3mg price

ivermectin lotion 0.5

trackback
2 月 前

stromectol brand

how to get ivermectin australia

trackback

xanaxonline

buy xanax online

trackback
2 月 前

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

https://www.vita-sportiva.it/gp-san-marino-liberate-gli-autodromi/

trackback
2 月 前

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

http://yuuki0.com/

trackback

stromectol online pharmacy

ivermectin us fda

trackback

stromectol uk buy

ivermectin cream 5

trackback
2 月 前

furosemide cost australia

furosemide 25 mg tablet

trackback
2 月 前

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

https://dropzonemag.com/knowledge-base/how-to-make-teaser-out-of-old-spare-multicolored-braid-you-have-lying-around/

trackback
2 月 前

buy lasix online no prescription

generic lasix online

trackback
2 月 前

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

https://www.coconhairenbeauty.nl/2017/10/06/nieuw-extra-spaarkaarten-bij-cocon-skincare/

trackback
2 月 前

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

https://yasna.sk/2019/08/08/random-adventures-of-a-lifetime/

trackback
2 月 前

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

https://holafmradio.com/index.php/2018/09/05/la-mujer-del-flujo-de-sangre-una-experiencia-de-fe/

trackback
2 月 前

ivermectin 6

ivermectin 6mg tablets for humans for sale

trackback

ivermectin 3 mg online

order ivermectin 6mg online

trackback

ivermectin 3mg for sale

ivermectin 6mg dosage

trackback
2 月 前

stromectol over the counter

cost of ivermectin medicine

trackback

ivermectin lice oral

ivermectin 1 cream generic

trackback
2 月 前

cost of ivermectin medicine

generic ivermectin for humans

trackback

stromectol ivermectin for humans

generic ivermectin for humans

trackback

ivermectin lotion price

ivermectin lotion for scabies

trackback

where to buy ivermectine us

ivermectin study nih

trackback

gambling games online real money

best online casinos usa

trackback

ivermectin tablets over counter

ivermectin gold

trackback
2 月 前

20mg cialis online tadalafil

cialis with dapoxetine

trackback
3 月 前

how can i get cheap cialis

cialis generic

trackback

sildenafil amazon

tadalafil vs sildenafil

trackback
3 月 前

dosage for ivermectin

ivermectin wormer

trackback

real money gambling

best casino game to win money online

trackback

ivermectin 2

stromectol preis

trackback
3 月 前

cheap tadalafil

buy cialis online

trackback

ivermectin 1%

stromectol tab

trackback
3 月 前

borgata online

nj online casino borgata

trackback

best liquid tadalafil

side effects of tadalafil

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