{"id":463,"date":"2020-12-09T03:27:32","date_gmt":"2020-12-08T19:27:32","guid":{"rendered":"http:\/\/log.tanxiaodian.com\/?p=463"},"modified":"2020-12-09T03:27:32","modified_gmt":"2020-12-08T19:27:32","slug":"%e9%87%8d%e7%bd%aemysql%e5%af%86%e7%a0%81-5-7","status":"publish","type":"post","link":"https:\/\/log.tanxiaodian.com\/?p=463","title":{"rendered":"\u91cd\u7f6emysql\u5bc6\u7801 5.7"},"content":{"rendered":"\n<p>\u8f6c\u81ea <a href=\"https:\/\/jingyan.baidu.com\/article\/3c48dd3425fbaba10be35893.html\">https:\/\/jingyan.baidu.com\/article\/3c48dd3425fbaba10be35893.html<\/a><\/p>\n\n\n\n<p>my.cnf\uff0c\u5728\u6587\u4ef6\u672b\u5c3e\u7f16\u8f91\u589e\u52a0\u4ee3\u7801\u00a0skip-grant-tables<\/p>\n\n\n\n<p><strong>\u91cd\u542fmysqld\u670d\u52a1\uff0c\u767b\u9646MySQL<\/strong><\/p>\n\n\n\n<p>$use&nbsp;mysql;<\/p>\n\n\n\n<p>$select&nbsp;host,user,authentication_string&nbsp;from&nbsp;user;<\/p>\n\n\n\n<p>#\u4fee\u6539root\u5bc6\u7801<\/p>\n\n\n\n<p>$update\u00a0user\u00a0set\u00a0authentication_string\u00a0=\u00a0password(&#8216;123456&#8217;)\u00a0where\u00a0user\u00a0=\u00a0&#8216;root&#8217;;<\/p>\n\n\n\n<p><strong>\u5f00\u542f\u6743\u9650\u7cfb\u7edf\uff0c\u91cd\u542fMySQL\uff0c\u65b0\u5bc6\u7801\u767b\u9646<\/strong><\/p>\n\n\n\n<p>$vim&nbsp;\/etc\/my.cnf<\/p>\n\n\n\n<p>#\u5f00\u542f\u6743\u9650\u7cfb\u7edf<\/p>\n\n\n\n<p>#skip-grant-tables<\/p>\n\n\n\n<p>#\u91cd\u542fmysql<\/p>\n\n\n\n<p>$systemctl&nbsp;restart&nbsp;mysqld<\/p>\n\n\n\n<p>#\u65b0root\u5bc6\u7801\u767b\u9646<\/p>\n\n\n\n<p>$mysql&nbsp;-uroot&nbsp;-p<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u8f6c\u81ea https:\/\/jingyan.baidu.&#8230;<\/p>\n<div class=\"more-link-wrapper\"><a class=\"more-link\" href=\"https:\/\/log.tanxiaodian.com\/?p=463\">Continue reading<span class=\"screen-reader-text\">\u91cd\u7f6emysql\u5bc6\u7801 5.7<\/span><\/a><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[2],"tags":[45],"_links":{"self":[{"href":"https:\/\/log.tanxiaodian.com\/index.php?rest_route=\/wp\/v2\/posts\/463"}],"collection":[{"href":"https:\/\/log.tanxiaodian.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/log.tanxiaodian.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/log.tanxiaodian.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/log.tanxiaodian.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=463"}],"version-history":[{"count":1,"href":"https:\/\/log.tanxiaodian.com\/index.php?rest_route=\/wp\/v2\/posts\/463\/revisions"}],"predecessor-version":[{"id":464,"href":"https:\/\/log.tanxiaodian.com\/index.php?rest_route=\/wp\/v2\/posts\/463\/revisions\/464"}],"wp:attachment":[{"href":"https:\/\/log.tanxiaodian.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=463"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/log.tanxiaodian.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=463"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/log.tanxiaodian.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=463"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}