{"id":248,"date":"2020-06-12T13:34:26","date_gmt":"2020-06-12T05:34:26","guid":{"rendered":"http:\/\/www.gbase8.cn\/?p=248"},"modified":"2020-09-17T06:19:15","modified_gmt":"2020-09-16T22:19:15","slug":"gbase-8a%e9%9b%86%e7%be%a4%e4%b8%b4%e6%97%b6%e4%bf%ae%e6%94%b9%e5%af%86%e7%a0%81%e5%92%8c%e6%81%a2%e5%a4%8d%e5%af%86%e7%a0%81","status":"publish","type":"post","link":"https:\/\/www.gbase8.cn\/en\/248","title":{"rendered":"GBase 8a cluster temporary password modification and password recovery, plain text password"},"content":{"rendered":"<p>\u7b2c\u4e00\u6b65,\u5907\u4efd\u539f\u59cb\u5bc6\u7801\u6210SQL\u5f62\u5f0f<br><code>select concat('set password for ',trim(user),'=''',password,''';') a from gbase.user into outfile '\/home\/gbase\/setpassword.sql';<\/code><\/p>\n\n\n\n<p>\u751f\u6210\u7684\u6587\u4ef6\u5185\u5bb9\u5982\u4e0b<br><code>set password for root='E9D057131C22A0D76B4AAD2C61655BDFA706E637'; <\/code><\/p>\n\n\n\n<p><code>set password for gbase='9C0ADBD7F08FA9D49D82760B104110C55B943B8D';<\/code><\/p>\n\n\n\n<p>\u7136\u540e\u968f\u610f\u4fee\u6539\u6570\u636e\u5e93\u7528\u6237\u7684\u5bc6\u7801<\/p>\n\n\n\n<p>\u9700\u8981\u8fd8\u539f\u662f\uff0c\u4f7f\u7528<br>source \/home\/gbase\/setpassword.sql<\/p>\n\n\n\n<p>\u5373\u53ef\u8fd8\u539f\u3002<\/p>\n\n\n\n<p>\u5982\u4e0a\u65b9\u6848\uff0c\u4e5f\u662f\u4e00\u4e2a\u76f4\u63a5\u8bbe\u7f6e\u5bc6\u7801\uff0c\u907f\u514d\u51fa\u73b0\u660e\u6587\u7684\u65b9\u6848\u3002<\/p>","protected":false},"excerpt":{"rendered":"<p>GBase 8a cluster temporary password modification and password recovery, plain text password<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,4],"tags":[31],"class_list":{"0":"post-248","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"hentry","6":"category-gbase8a","8":"tag-31"},"_links":{"self":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/248","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/comments?post=248"}],"version-history":[{"count":5,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/248\/revisions"}],"predecessor-version":[{"id":1400,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/248\/revisions\/1400"}],"wp:attachment":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media?parent=248"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/categories?post=248"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/tags?post=248"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}