{"id":1466,"date":"2020-12-27T19:03:52","date_gmt":"2020-12-27T11:03:52","guid":{"rendered":"http:\/\/cnliutz.uicp.io\/?p=1466"},"modified":"2020-12-27T19:03:52","modified_gmt":"2020-12-27T11:03:52","slug":"wordpress-mysql%e6%95%b0%e6%8d%ae%e5%ba%93%e4%bf%ae%e6%94%b9%e7%bd%91%e7%ab%99%e8%ae%bf%e9%97%ae%e5%9c%b0%e5%9d%80","status":"publish","type":"post","link":"http:\/\/g1n29wqq.ipyingshe.net:5347\/?p=1466","title":{"rendered":"WordPress mysql\u6570\u636e\u5e93\u4fee\u6539\u7f51\u7ad9\u8bbf\u95ee\u5730\u5740"},"content":{"rendered":"\n<p>\u53d1\u5e03\u4e8e<a href=\"http:\/\/192.168.104.102\/?p=1222\"><time datetime=\"2020-08-10T15:55:06+08:00\">2020\u5e748\u670810\u65e5<\/time><\/a><\/p>\n\n\n\n<p>#mysql -u root -p<br>>show databases;<br>>use database wordpress;<br>>show tables;<br>>show columns from \u8868\u540d(table_name) ;<br>>desc \u8868\u540d;<br>>select * from wp_options where option_id=\u201d1\u2033 ;    #option_name=&#8221;siteurl&#8221;<br>>select * from wp_options where option_id=\u201d2\u2033;     #option_name=&#8221;home&#8221;<br>>update wp_options set option_value=\u201dhttp:\/\/cnliutz.wicp.vip\u201d where option_id=\u201d1\u2033;      #where  option_value=&#8221;siteurl&#8221;<br>>update wp_options set option_value=\u201dhttp:\/\/cnliutz.wicp.vip\u201d where option_id=\u201d2\u2033;       #where option_value=&#8221;home&#8221;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u53d1\u5e03\u4e8e2020\u5e748\u670810\u65e5 #mysql -u root -p>show dat <span class=\"readmore\"><a href=\"http:\/\/g1n29wqq.ipyingshe.net:5347\/?p=1466\">Continue Reading<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1466","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"http:\/\/g1n29wqq.ipyingshe.net:5347\/index.php?rest_route=\/wp\/v2\/posts\/1466","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/g1n29wqq.ipyingshe.net:5347\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/g1n29wqq.ipyingshe.net:5347\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/g1n29wqq.ipyingshe.net:5347\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/g1n29wqq.ipyingshe.net:5347\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1466"}],"version-history":[{"count":1,"href":"http:\/\/g1n29wqq.ipyingshe.net:5347\/index.php?rest_route=\/wp\/v2\/posts\/1466\/revisions"}],"predecessor-version":[{"id":1467,"href":"http:\/\/g1n29wqq.ipyingshe.net:5347\/index.php?rest_route=\/wp\/v2\/posts\/1466\/revisions\/1467"}],"wp:attachment":[{"href":"http:\/\/g1n29wqq.ipyingshe.net:5347\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1466"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/g1n29wqq.ipyingshe.net:5347\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1466"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/g1n29wqq.ipyingshe.net:5347\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1466"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}