点击数: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,问题解决,一切正常
porn watch
thank you for publish post :
连接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
连接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/
连接MySQL报“Error No.2058 Plugin caching_sha2_password could not be loaded”错误的解决办法
https://www.studiorotelli.com/lillecito-internazionale-e-il-regime-ordinario-di-responsabilita/
vidalista 20 ingredients
super vidalista
vipspark.vipspark.ru
vipspark.vipspark.ru
psychophysics.ru
psychophysics.ru
vitaliy-abdulov.ru
vitaliy-abdulov.ru
video.vipspark.ru
video.vipspark.ru
连接MySQL报“Error No.2058 Plugin caching_sha2_password could not be loaded”错误的解决办法
https://www.fabiolissi.com/giugno-htsi-unique-piece/
连接MySQL报“Error No.2058 Plugin caching_sha2_password could not be loaded”错误的解决办法
http://www.sjalensstjarna.se/bowenterapi/
film.poip-nsk.ru – film online
film.poip-nsk.ru – film online
poip-nsk.ru – Movie Watch
poip-nsk.ru – Movie Watch
连接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
连接MySQL报“Error No.2058 Plugin caching_sha2_password could not be loaded”错误的解决办法
https://www.bradyhelms.com/conductive-ink-and-electrically-stimulated-healing-in-mice/
bit.ly/pamfir-pamfir-2023-ua-pamfir
bit.ly/pamfir-pamfir-2023-ua-pamfir
连接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/
studio-tatuage.ru
studio-tatuage.ru
yug-grib.ru
yug-grib.ru
2023
2023
Medicines information. Long-Term Effects. aripiprazole tab 10mg side effects?
Medication dope in return patients. Cautions aripiprazole tab 10mg side effects?
tqmFEB3B
tqmFEB3B
Medicine information leaflet. What side effects can this medication cause? paxil?
Medicines message for the sake of patients. Cautions. how much is paxil pills?
fildena canada
fildena usa
Pills information. What side effects? paroxetine 10 mg?
Pills advice leaflet. Cautions. paxil withdrawal symptoms?
klondayk2022
klondayk2022
irannews.ru
irannews.ru
Pills communication sheet. Brand names. where to buy propecia without prescription?
Medication dope in return patients. Cautions cost of propecia pill?
uluro-ado
uluro-ado
rusnewsweek
rusnewsweek
24hours-news
24hours-news
icf
icf
slot สล็อตออนไลน์ ยอดนิยม เล่นได้เงินจริง เล่นได้บน โทรศัพท์มือถือ รองรับทุกระบบ สมัครเป็นสมาชิกใหม่ รับโบนัสฟรี 100% ที่ PG เดียวของโลก เกมสล็อตออนไลน์ เป็นที่นิยมมหาศาล
ทดลองเล่นสล็อต pg ไม่ เด้ง เคยเป็นไหมทดลองเล่นสล็อตออนไลน์บนเว็บพนันออนไลน์ ลองเล่นเกมใหม่ๆ เกมภาพสวยๆ เล่นได่แปบเดียวก็เด้ง ต้องมาทดลองเล่นที่เราเลย กับ PG-SLOT.GAME
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?
www
www
bep5w0Df
bep5w0Df
连接MySQL报“Error No.2058 Plugin caching_sha2_password could not be loaded”错误的解决办法
https://safe.africa/index.php/sample-page/
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?
连接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/
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?
bit.ly/3GQNK0J
bit.ly/3GQNK0J
bit.ly/3ig2UT5
bit.ly/3ig2UT5
vidalista-20 centurion laboratories
vidalista 20mg
bit.ly/3ARFdXA
bit.ly/3ARFdXA
bit.ly/3gGFqGq
bit.ly/3gGFqGq
bit.ly/3OEzOZR
bit.ly/3OEzOZR
How many cigarettes are in a vape zyban drug?
Which CBD is best to quit smoking cost of zyban?
What are the signs of love in a woman and buying kamagra online?
How can I find I am in love and ajanta kamagra?
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?