https:\/\/dev.mysql.com\/doc\/refman\/8.4\/en\/native-pluggable-authentication.html#native-pluggable-authentication-installation<\/a><\/p>\n\n\n\n<\/p>\n\n\n\n
\u89e3\u51b3\u529e\u6cd5\uff1a<\/p>\n\n\n\n
1\u3001\u589e\u52a0\u914d\u7f6e<\/p>\n\n\n\n
[mysqld]
skip-grant-tables<\/pre>\n\n\n\n2\u3001\u91cd\u542fmysql<\/p>\n\n\n\n
kubectl delete pod mysql-server-7d794599bd-q9xgn<\/p>\n\n\n\n
3\u3001\u514d\u5bc6\u767b\u5f55\u5230mysql\u91cc\u9762<\/p>\n\n\n\n
kubectl exec -it mysql-server-7d794599bd-q9xgn — bash<\/p>\n\n\n\n
mysql -uroot -p<\/p>\n\n\n\n
4\u3001\u4fee\u6539\u52a0\u5bc6\u89c4\u5219<\/p>\n\n\n\n
USE mysql;
FLUSH PRIVILEGES;
UPDATE mysql.user SET plugin='caching_sha2_password', authentication_string='' WHERE user='root' AND host='localhost';
FLUSH PRIVILEGES;
ALTER USER 'root'@'localhost' IDENTIFIED WITH 'caching_sha2_password' BY 'newpassword';
FLUSH PRIVILEGES;<\/pre>\n\n\n\n5\u3001\u53bb\u9664\u589e\u52a0\u7684\u914d\u7f6e<\/p>\n\n\n\n
skip-grant-tables<\/p>\n\n\n\n
6\u3001\u91cd\u542fmysql<\/p>\n\n\n\n
kubectl delete pod mysql-server-7d794599bd-q9xga<\/p>\n\n\n\n
7\u3001\u91cd\u65b0\u767b\u5f55<\/p>\n\n\n\n
\u5e78\u4e8f\u65b0\u7248\u672c\u7684wordpress\u652f\u6301caching_sha2_password\u63d2\u4ef6\uff0c\u7701\u53bb\u4e86\u6211\u8f6c\u6362\u63d2\u4ef6\u7684\u65f6\u95f4<\/p>\n","protected":false},"excerpt":{"rendered":"
\u53d1\u751f\u4e86\u4e00\u4ef6\u975e\u5e38\u975e\u5e38\u975e\u5e38\u86cb\u75bc\u7684\u4e8b\u60c5 \u7531\u4e8eMySQL\u6570\u636e\u662f\u4ece5.7.x\u4e00\u8def\u5347\u7ea7\u800c\u6765\uff0c\u4e00\u76f4\u6cbf\u7528\u4e4b\u524d\u7684mysql_na […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20,2],"tags":[],"class_list":["post-781","post","type-post","status-publish","format-standard","hentry","category-kubernetes","category-mysql"],"blocksy_meta":[],"views":2280,"_links":{"self":[{"href":"https:\/\/www.luyouli.com\/index.php?rest_route=\/wp\/v2\/posts\/781","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.luyouli.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.luyouli.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.luyouli.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.luyouli.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=781"}],"version-history":[{"count":9,"href":"https:\/\/www.luyouli.com\/index.php?rest_route=\/wp\/v2\/posts\/781\/revisions"}],"predecessor-version":[{"id":796,"href":"https:\/\/www.luyouli.com\/index.php?rest_route=\/wp\/v2\/posts\/781\/revisions\/796"}],"wp:attachment":[{"href":"https:\/\/www.luyouli.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=781"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.luyouli.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=781"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.luyouli.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=781"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"\"](\"https:\/\/www.luyouli.com\/wp-content\/uploads\/2024\/07\/image-3.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/www.luyouli.com\/wp-content\/uploads\/2024\/07\/image.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/www.luyouli.com\/wp-content\/uploads\/2024\/07\/image-1.png\")
<\/figure>\n\n\n\n