点击数: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,问题解决,一切正常
hydroxychloroquine drugs
hydroxychloroquine weight loss
hydroxychloroquine news
hydroxychloroquine used to treat
stromectol usa
ivermectin 200
cialis over the counter
cialis over the counter at walmart
ivermectin msds
otc ivermectin
ivermectin horse paste for humans
ivermectin 0.08 oral solution
连接MySQL报“Error No.2058 Plugin caching_sha2_password could not be loaded”错误的解决办法
http://uuphost.org/stonybrookhsc/individual-development-award/
ivermectin prescription
ivermectin at tractor supply
ivermectin resistance
ivermectin price canada
ivermectine vente libre
how to order ivermectin online
walmart cost for cialis
cialis prices at walmart pharmacy
lucky slots
lucky lands
连接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
stromectol without prescription
cost of stromectol
stromectol usa
ivermectin 3mg
ivermectin 3 mg
ivermectin covid
ivermectin 3mg price
ivermectin lotion 0.5
stromectol brand
how to get ivermectin australia
xanaxonline
buy xanax online
连接MySQL报“Error No.2058 Plugin caching_sha2_password could not be loaded”错误的解决办法
https://www.vita-sportiva.it/gp-san-marino-liberate-gli-autodromi/
连接MySQL报“Error No.2058 Plugin caching_sha2_password could not be loaded”错误的解决办法
http://yuuki0.com/
stromectol online pharmacy
ivermectin us fda
stromectol uk buy
ivermectin cream 5
furosemide cost australia
furosemide 25 mg tablet
连接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/
buy lasix online no prescription
generic lasix online
连接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/
连接MySQL报“Error No.2058 Plugin caching_sha2_password could not be loaded”错误的解决办法
https://yasna.sk/2019/08/08/random-adventures-of-a-lifetime/
连接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/
ivermectin 6
ivermectin 6mg tablets for humans for sale
ivermectin 3 mg online
order ivermectin 6mg online
ivermectin 3mg for sale
ivermectin 6mg dosage
stromectol over the counter
cost of ivermectin medicine
ivermectin lice oral
ivermectin 1 cream generic
cost of ivermectin medicine
generic ivermectin for humans
stromectol ivermectin for humans
generic ivermectin for humans
ivermectin lotion price
ivermectin lotion for scabies
where to buy ivermectine us
ivermectin study nih
gambling games online real money
best online casinos usa
ivermectin tablets over counter
ivermectin gold
20mg cialis online tadalafil
cialis with dapoxetine
how can i get cheap cialis
cialis generic
sildenafil amazon
tadalafil vs sildenafil
dosage for ivermectin
ivermectin wormer
real money gambling
best casino game to win money online
ivermectin 2
stromectol preis
cheap tadalafil
buy cialis online
ivermectin 1%
stromectol tab
borgata online
nj online casino borgata
best liquid tadalafil
side effects of tadalafil