\u5728MySQL 8.04\u524d\uff0c\u6267\u884c\uff1aSET PASSWORD=PASSWORD(\u2018[\u65b0\u5bc6\u7801]\u2019);\u4f46\u662fMySQL8.0.4\u5f00\u59cb\uff0c\u8fd9\u6837\u9ed8\u8ba4\u662f\u4e0d\u884c\u7684\u3002\u56e0\u4e3a\u4e4b\u524d\uff0cMySQL\u7684\u5bc6\u7801\u8ba4\u8bc1\u63d2\u4ef6\u662f\u201cmysql_native_password\u201d\uff0c\u800c\u73b0\u5728\u4f7f\u7528\u7684\u662f\u201ccaching_sha2_password\u201d\u3002
\n\u73b0\u5728\u53ef\u4ee5\u4f7f\u7528\u4ee5\u4e0b\u7684\u65b9\u6cd5\u53bb\u4fee\u6539root\u5bc6\u7801<\/p>\n

Code: <\/strong>[\u5168\u9009]<\/a> [Expand\/Collapse]<\/a><\/div>\n
\n
\n
\n
\n
\n
use<\/span> mysql\uff1b<\/div>\n<\/li>\n
\n
ALTER<\/span> USER<\/span> ‘root’<\/span>@‘localhost’<\/span> IDENTIFIED WITH<\/span> mysql_native_password BY ‘\u65b0\u5bc6\u7801’<\/span>;<\/span><\/div>\n<\/li>\n
\n
FLUSH PRIVILEGES<\/span>;<\/span><\/div>\n<\/li>\n<\/ol>\n<\/div>\n<\/div>\n<\/div>\n
GeSHi © Codebox Plus Extension<\/div>\n<\/div>\n
\u539f\u6587\u4f5c\u8005: BG6RSH | \u67e5\u770b\u539f\u5e16<\/a><\/small><\/p>\n","protected":false},"excerpt":{"rendered":"
\u5728MySQL 8.04\u524d\uff0c\u6267\u884c\uff1aSET PASSWORD=PASSWORD(\u2018[ … \u7ee7\u7eed\u9605\u8bfb →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[105],"tags":[],"class_list":["post-1481","post","type-post","status-publish","format-standard","hentry","category-105"],"_links":{"self":[{"href":"https:\/\/www.tansoo.cn\/index.php?rest_route=\/wp\/v2\/posts\/1481","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.tansoo.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tansoo.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tansoo.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tansoo.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1481"}],"version-history":[{"count":0,"href":"https:\/\/www.tansoo.cn\/index.php?rest_route=\/wp\/v2\/posts\/1481\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.tansoo.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1481"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tansoo.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1481"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tansoo.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1481"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}