{"id":1210,"date":"2020-09-09T19:47:08","date_gmt":"2020-09-09T11:47:08","guid":{"rendered":"https:\/\/www.zeroheart.xyz\/wordpress\/?p=1210"},"modified":"2020-09-09T19:47:08","modified_gmt":"2020-09-09T11:47:08","slug":"%e4%b8%8d%e5%b0%8f%e5%bf%83%e6%8a%8amysql%e7%9a%84root%e6%9d%83%e9%99%90%e5%b9%b2%e6%8e%89%e4%ba%86%e6%80%8e%e4%b9%88%e5%8a%9e%ef%bc%9f%ef%bc%9f","status":"publish","type":"post","link":"https:\/\/www.zeroheart.xyz\/wordpress\/?p=1210","title":{"rendered":"\u4e0d\u5c0f\u5fc3\u628amysql\u7684root\u6743\u9650\u5e72\u6389\u4e86\u600e\u4e48\u529e\uff1f\uff1f"},"content":{"rendered":"\n<p>1.service mysqld stop<\/p>\n\n\n\n<p>2.\/usr\/bin\/mysqld_safe &#8211;skip-grant-tables &amp;<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">3.\u628a\u6743\u9650\u8d4b\u56de\u6765<br>update user set  <code>Select_priv<\/code> = 'Y',<code>Insert_priv<\/code> = 'Y',<code>Update_priv<\/code> = 'Y',<code>Delete_priv<\/code> = 'Y',<code>Create_priv<\/code> = 'Y', <code>Drop_priv<\/code> = 'Y',<code>Reload_priv<\/code> = 'Y',<code>Shutdown_priv<\/code> = 'Y',<code>Process_priv<\/code> = 'Y',<code>File_priv<\/code> = 'Y', <code>Grant_priv<\/code> = 'Y',<code>References_priv<\/code> = 'Y',<code>Index_priv<\/code> = 'Y',<code>Alter_priv<\/code> = 'Y',<code>Show_db_priv<\/code> = 'Y',<code>Super_priv<\/code> = 'Y',<code>Create_tmp_table_priv<\/code> = 'Y',<code>Lock_tables_priv<\/code> = 'Y',<code>Execute_priv<\/code> = 'Y',<code>Repl_slave_priv<\/code> = 'Y',<code>Repl_client_priv<\/code> = 'Y',<code>Create_view_priv<\/code> = 'Y',<code>Show_view_priv<\/code> = 'Y',<code>Create_routine_priv<\/code> = 'Y',<code>Alter_routine_priv<\/code> = 'Y',<code>Create_user_priv<\/code> = 'Y',<code>Event_priv<\/code> = 'Y',<code>Trigger_priv<\/code> = 'Y',<code>Create_tablespace_priv<\/code> = 'Y' where user='root' and host='%'<\/pre>\n\n\n\n<p>4.flush privileges;<\/p>\n\n\n\n<p>5.\u91cd\u542f\u4e00\u4e0bservice mysql restart<\/p>\n","protected":false},"excerpt":{"rendered":"<p>1.service mysqld stop 2.\/usr\/bin\/mysqld_safe &#8211;ski [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[62,65],"_links":{"self":[{"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1210"}],"collection":[{"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1210"}],"version-history":[{"count":6,"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1210\/revisions"}],"predecessor-version":[{"id":1216,"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1210\/revisions\/1216"}],"wp:attachment":[{"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1210"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1210"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1210"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}