Copyright notice: This article is an original article and follows
CC 4.0 BY-NC-ND
Copyright agreement. If you want to repost this article, please attach the original source link and this statement.
Source link:
https://www.v2know.com/MainPage/PreView/1022
SQLyog錯誤號碼2058最快解決方法
先進入mysql的命令行
select user,host,plugin from mysql.user;
看看他們的plugin用的什麽方式
mysql> select user,host,plugin from mysql.user;
+------------------+-----------+-----------------------+
| user | host | plugin |
+------------------+-----------+-----------------------+
| root | % | caching_sha2_password |
| debian-sys-maint | localhost | caching_sha2_password |
| mysql.infoschema | localhost | caching_sha2_password |
| mysql.session | localhost | caching_sha2_password |
| mysql.sys | localhost | caching_sha2_password |
| root | localhost | mysql_native_password |
+------------------+-----------+-----------------------+
6 rows in set (0.00 sec)
這個已經是我部分修改好的，
如果你需要遠程鏈接mysql，你必須
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'your_password';
FLUSH PRIVILEGES;
這樣才能擺脫caching_sha2_password的驗證問題。
當然如果你沒有root@%這個用戶，那你就必須創建了：
CREATE USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'new_password';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;
説到底，這只是最快的解決方法。（只適合測試環境）
最好的解決方案還是去弄懂caching_sha2_password的驗證。