{"id":131826,"date":"2020-07-05T01:31:28","date_gmt":"2020-07-04T17:31:28","guid":{"rendered":"http:\/\/4563.org\/?p=131826"},"modified":"2020-07-05T01:31:28","modified_gmt":"2020-07-04T17:31:28","slug":"mac-os-%e4%b8%8bmysql%e5%bf%98%e8%ae%b0%e5%af%86%e7%a0%81%e5%90%8e%e5%a6%82%e4%bd%95%e9%87%8d%e7%bd%ae%e5%af%86%e7%a0%81","status":"publish","type":"post","link":"http:\/\/4563.org\/?p=131826","title":{"rendered":"Mac Os \u4e0bMySQL\u5fd8\u8bb0\u5bc6\u7801\u540e\u5982\u4f55\u91cd\u7f6e\u5bc6\u7801"},"content":{"rendered":"<p>Mac Os \u4e0bMySQL\u5fd8\u8bb0\u5bc6\u7801\u540e\u5982\u4f55\u91cd\u7f6e\u5bc6\u7801<\/p>\n<h3><a href=\"https:\/\/www.studytime.xin\/article\/#\u505c\u6b62-mysql-server\" title=\"\u505c\u6b62 mysql server\"><\/a>\u505c\u6b62 mysql server<\/h3>\n<p>\u901a\u5e38\u662f\u5728 \u2018\u7cfb\u7edf\u504f\u597d\u8bbe\u7f6e\u2019 &gt; MySQL &gt; \u2018Stop MySQL Server\u2019<\/p>\n<h3><a href=\"https:\/\/www.studytime.xin\/article\/#\u6253\u5f00\u547d\u4ee4\u884c\u8f93\u5165\uff1asudo-usr-local-mysql-bin-mysqld-safe-skip-grant-tables\" title=\"\u6253\u5f00\u547d\u4ee4\u884c\u8f93\u5165\uff1asudo \/usr\/local\/mysql\/bin\/mysqld_safe --skip-grant-tables\"><\/a>\u6253\u5f00\u547d\u4ee4\u884c\u8f93\u5165\uff1a<code>sudo \/usr\/local\/mysql\/bin\/mysqld_safe --skip-grant-tables<\/code><\/h3>\n<h3><a href=\"https:\/\/www.studytime.xin\/article\/#\u6253\u5f00\u53e6\u4e00\u4e2a\u65b0\u7ec8\u7aef\uff1asudo-usr-local-mysql-bin-mysql-u-root\" title=\"\u6253\u5f00\u53e6\u4e00\u4e2a\u65b0\u7ec8\u7aef\uff1asudo \/usr\/local\/mysql\/bin\/mysql -u root\"><\/a>\u6253\u5f00\u53e6\u4e00\u4e2a\u65b0\u7ec8\u7aef\uff1a<code>sudo \/usr\/local\/mysql\/bin\/mysql -u root<\/code><\/h3>\n<h3><a href=\"https:\/\/www.studytime.xin\/article\/#\u91cd\u7f6e\u5bc6\u7801\" title=\"\u91cd\u7f6e\u5bc6\u7801\"><\/a>\u91cd\u7f6e\u5bc6\u7801<\/h3>\n<figure>\n<table>\n<tr>\n<td>\n<pre><span>1<\/span><br><span>2<\/span><br><\/pre>\n<\/td>\n<td>\n<pre><span>UPDATE mysql.user SET authentication_string&#x3D;PASSWORD(&#39;\u65b0\u5bc6\u7801&#39;) WHERE User&#x3D;&#39;root&#39;;<\/span><br><span>FLUSH PRIVILEGES;<\/span><br><\/pre>\n<\/td>\n<\/tr>\n<\/table>\n<\/figure>\n<h3><a href=\"https:\/\/www.studytime.xin\/article\/#\u91cd\u542fMySQL\u5373\u53ef\" title=\"\u91cd\u542fMySQL\u5373\u53ef\"><\/a>\u91cd\u542fMySQL\u5373\u53ef<\/h3>\n<h3><a href=\"https:\/\/www.studytime.xin\/article\/#\u7279\u6b8a\u8bf4\u660e\" title=\"\u7279\u6b8a\u8bf4\u660e\"><\/a>\u7279\u6b8a\u8bf4\u660e<\/h3>\n<p>\u4ee5\u4e0a\u65b9\u6cd5\u9488\u5bf9 mysql V5.7.9, \u65e7\u7248\u7684mysql\u8bf7\u4f7f\u7528\uff1a<br \/><code>UPDATE mysql.user SET Password=PASSWORD(&#39;\u65b0\u5bc6\u7801&#39;) WHERE User=&#39;root&#39;;<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Mac Os \u4e0bMySQL\u5fd8\u8bb0\u5bc6\u7801&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[],"tags":[],"_links":{"self":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/131826"}],"collection":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=131826"}],"version-history":[{"count":0,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/131826\/revisions"}],"wp:attachment":[{"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=131826"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=131826"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=131826"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}