{"id":5232,"date":"2023-10-21T21:29:41","date_gmt":"2023-10-21T13:29:41","guid":{"rendered":"http:\/\/blog.coolcoding.cn\/?p=5232"},"modified":"2023-10-21T22:28:13","modified_gmt":"2023-10-21T14:28:13","slug":"mysql%e4%bf%ae%e6%94%b9root%e5%af%86%e7%a0%81","status":"publish","type":"post","link":"https:\/\/blog.coolcoding.cn\/?p=5232","title":{"rendered":"\u5fd8\u4e86mysql\u7684root\u5bc6\u7801"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code>\u5728my.ini \u6216\u8005 myc.cnf\u7684[mysqld]\u4e2d\u6dfb\u52a0:\nskip-grant-tables\n\n\u7136\u540e\u53ef\u4ee5\u76f4\u63a5\u767b\u5f55\nmysql -uroot -p\n\n\u5982\u679c\u4fee\u6539root\u5bc6\u7801\u62a5\u9519\nERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement\n\u5219\u6267\u884c\nflush privileges;\nset password for root@localhost=password('\u4f60\u7684\u5bc6\u7801');\n\n--------------------------\n\n\u5176\u5b83\n\u5982\u679c\u5fd8\u8bb0wordpress\u5bc6\u7801,\u5219\u67e5\u770bwp-config.php\u6587\u4ef6\n\u6216\u8005\u5220\u9664wp-config.php\n<\/code><\/pre>\n\n\n\n<p>wordpress\u4fee\u6539\u7ba1\u7406\u5458\u5bc6\u7801<\/p>\n","protected":false},"excerpt":{"rendered":"<p>wordpress\u4fee\u6539\u7ba1\u7406\u5458\u5bc6\u7801<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.coolcoding.cn\/index.php?rest_route=\/wp\/v2\/posts\/5232"}],"collection":[{"href":"https:\/\/blog.coolcoding.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.coolcoding.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.coolcoding.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.coolcoding.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5232"}],"version-history":[{"count":2,"href":"https:\/\/blog.coolcoding.cn\/index.php?rest_route=\/wp\/v2\/posts\/5232\/revisions"}],"predecessor-version":[{"id":5234,"href":"https:\/\/blog.coolcoding.cn\/index.php?rest_route=\/wp\/v2\/posts\/5232\/revisions\/5234"}],"wp:attachment":[{"href":"https:\/\/blog.coolcoding.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5232"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.coolcoding.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5232"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.coolcoding.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5232"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}