{"id":636,"date":"2019-12-29T19:51:26","date_gmt":"2019-12-29T11:51:26","guid":{"rendered":"https:\/\/www.shineskr.com\/?p=636"},"modified":"2019-12-29T19:52:26","modified_gmt":"2019-12-29T11:52:26","slug":"mysql8-0-caching_sha2_password%e6%8a%a5%e9%94%99%e9%97%ae%e9%a2%98","status":"publish","type":"post","link":"https:\/\/www.shineskr.com\/636.html","title":{"rendered":"MySQL8.0 caching_sha2_password\u62a5\u9519\u95ee\u9898"},"content":{"rendered":"<!--wp-compress-html--><!--wp-compress-html no compression-->\n<p>\u7528docker\u6784\u5efamysql\u5bb9\u5668\u540e\uff0c\u901a\u8fc7navicat\u8fde\u63a5\u540e\u9047\u5230caching_sha2_password\u62a5\u9519\u95ee\u9898 \u3002<\/p>\n\n\n\n<p style=\"text-align:left\">\u56e0\u4e3aMySQL8.0\u91c7\u7528\u4e86\u65b0\u7684\u66f4\u5b89\u5168\u7684\u9a8c\u8bc1\u65b9\u5f0f\uff0c\u8be6\u60c5\u8bf7\u67e5\u770b<a href=\"https:\/\/mysqlserverteam.com\/mysql-8-0-4-new-default-authentication-plugin-caching_sha2_password\/\">mysql-8-0-4-new-default-authentication-plugin-caching_sha2_password<\/a><\/p>\n\n\n\n<p>\u53ef\u4ee5\u6539\u6210\u539f\u751f\u5bc6\u7801\u7684\u52a0\u5bc6\u65b9\u5f0f\u6765\u89e3\u51b3\u8be5\u95ee\u9898\u3002 <\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u67e5\u770b\u8eab\u4efd\u9a8c\u8bc1\u7c7b\u578b<\/h4>\n\n\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nmysql&gt; use mysql;\nDatabase changed\n\nmysql&gt; SELECT Host, User, plugin from user;\n+-----------+------------------+-----------------------+\n| Host      | User             | plugin                |\n+-----------+------------------+-----------------------+\n| %         | root             | caching_sha2_password |\n| localhost | mysql.infoschema | caching_sha2_password |\n| localhost | mysql.session    | caching_sha2_password |\n| localhost | mysql.sys        | caching_sha2_password |\n| localhost | root             | caching_sha2_password |\n+-----------+------------------+-----------------------+\n5 rows in set (0.00 sec)\n<\/pre>\n\n\n<p><code>root<\/code>&nbsp;\u7528\u6237\u7684\u9a8c\u8bc1\u5668\u63d2\u4ef6\u4e3a&nbsp;<strong>caching_sha2_password<\/strong><\/p>\n\n\n\n<h4 class=\"wp-block-heading\"> \u4fee\u6539\u8eab\u4efd\u9a8c\u8bc1\u7c7b\u578b(\u4fee\u6539\u5bc6\u7801) <\/h4>\n\n\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nmysql&gt; ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';\nQuery OK, 0 rows affected (0.00 sec)\n\nmysql&gt; ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';\nQuery OK, 0 rows affected (0.01 sec)\n<\/pre>\n\n\n<h4 class=\"wp-block-heading\">\u4f7f\u751f\u6548<\/h4>\n\n\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nmysql&gt; FLUSH PRIVILEGES;\n<\/pre>\n\n\n<h4 class=\"wp-block-heading\">\u9a8c\u8bc1\u662f\u5426\u751f\u6548<\/h4>\n\n\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nmysql&gt; SELECT Host, User, plugin from user;\n+-----------+------------------+-----------------------+\n| Host      | User             | plugin                |\n+-----------+------------------+-----------------------+\n| %         | root             | mysql_native_password |\n| localhost | mysql.infoschema | caching_sha2_password |\n| localhost | mysql.session    | caching_sha2_password |\n| localhost | mysql.sys        | caching_sha2_password |\n| localhost | root             | mysql_native_password |\n+-----------+------------------+-----------------------+\n5 rows in set (0.00 sec)\n<\/pre><!--wp-compress-html no compression--><!--wp-compress-html-->","protected":false},"excerpt":{"rendered":"\u7528docker\u6784\u5efamysql\u5bb9\u5668\u540e\uff0c\u901a\u8fc7navicat\u8fde\u63a5\u540e\u9047\u5230caching_sha2_password\u62a5\u9519\u95ee\u9898 \u3002 \u56e0\u4e3aMySQL8.0\u91c7\u7528\u4e86\u65b0\u7684\u66f4\u5b89\u5168\u7684\u9a8c\u8bc1\u65b9\u5f0f\uff0c\u8be6\u60c5\u8bf7\u67e5\u770bmysql-8-0-4 \u00b7\u00b7\u00b7","protected":false},"author":1,"featured_media":637,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[68,3],"tags":[73],"table_tags":[],"_links":{"self":[{"href":"https:\/\/www.shineskr.com\/api\/wp\/v2\/posts\/636"}],"collection":[{"href":"https:\/\/www.shineskr.com\/api\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.shineskr.com\/api\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.shineskr.com\/api\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.shineskr.com\/api\/wp\/v2\/comments?post=636"}],"version-history":[{"count":2,"href":"https:\/\/www.shineskr.com\/api\/wp\/v2\/posts\/636\/revisions"}],"predecessor-version":[{"id":639,"href":"https:\/\/www.shineskr.com\/api\/wp\/v2\/posts\/636\/revisions\/639"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.shineskr.com\/api\/wp\/v2\/media\/637"}],"wp:attachment":[{"href":"https:\/\/www.shineskr.com\/api\/wp\/v2\/media?parent=636"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.shineskr.com\/api\/wp\/v2\/categories?post=636"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.shineskr.com\/api\/wp\/v2\/tags?post=636"},{"taxonomy":"table_tags","embeddable":true,"href":"https:\/\/www.shineskr.com\/api\/wp\/v2\/table_tags?post=636"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}