{"id":1936,"date":"2024-03-18T02:36:47","date_gmt":"2024-03-17T18:36:47","guid":{"rendered":"http:\/\/www.ccwifi.cc\/blogs\/?p=1936"},"modified":"2024-03-18T02:36:47","modified_gmt":"2024-03-17T18:36:47","slug":"%e6%8a%80%e6%9c%af%e5%88%86%e4%ba%abmysqlsh%e5%91%bd%e4%bb%a4%e8%a1%8c%e6%a8%a1%e5%bc%8f9695","status":"publish","type":"post","link":"https:\/\/www.ccwifi.cc\/blogs\/2024\/03\/18\/%e6%8a%80%e6%9c%af%e5%88%86%e4%ba%abmysqlsh%e5%91%bd%e4%bb%a4%e8%a1%8c%e6%a8%a1%e5%bc%8f9695\/","title":{"rendered":"\u6280\u672f\u5206\u4eab | mysqlsh \u547d\u4ee4\u884c\u6a21\u5f0f &amp; \u5bc6\u7801\u4fdd\u5b58"},"content":{"rendered":"<div>\n<p>\u5728\u7ebfwifi\u8dd1\u5305 \u91d1\u521a\u5305\u8dd1\u5305 cap\u8dd1\u5305 hccapx ewsa\u5728\u7ebf \u5c31\u6765 <strong><a href=\"https:\/\/ccwifi.cc\" target=\"_blank\" rel=\"noopener\">\u63e1\u624b\u5305\u8dd1\u5305<\/a><\/strong><\/p>\n<p>\u5404\u4f4d\u597d \u53c8\u89c1\u9762\u4e86 \u6211\u662f\u66f9\u64cd \u4eca\u5929\u7ed9\u5927\u5bb6\u5e26\u6765\u4e00\u7bc7\u65b0\u7684\u6559\u7a0b<\/p>\n<p>\u5e0c\u671b\u5404\u4f4d\u7ec6\u5fc3\u5b66\u4e60 \u4f4e\u8c03\u7528\u7f51<\/p>\n<\/div>\n<pre><code class=\"language-text\">mysqlsh [options] -- shell_object object_method [arguments]\n<\/code><\/pre>\n<p>\u5728\u547d\u4ee4\u884c\u6a21\u5f0f\u4e0b\uff0c\u8981\u5b9e\u73b0\u7c7b\u4f3c\u4e8e&#8221;mysql -e &#8220;show processlist;&#8221;&#8221;\u7684\u6548\u679c\uff0c\u5373\u6267\u884c\u5b8c\u547d\u4ee4\u540e\u7acb\u5373\u9000\u51fa\u767b\u5f55\uff0c\u4e0d\u9700\u8981\u4ea4\u4e92\uff0c\u6211\u4eec\u53ef\u4ee5\u5728\u811a\u672c\u4e2d\u4f7f\u7528mysql shell\u3002\u540c\u6837\u5730\uff0c\u5728\u7ef4\u62a4InnoDB Cluster\u65f6\uff0c\u6211\u4eec\u53ef\u4ee5\u5728\u811a\u672c\u4e2d\u8c03\u7528mysql shell\u6765\u67e5\u770bMGR\u96c6\u7fa4\u7684\u72b6\u6001\u6216\u6267\u884c\u64cd\u4f5c\u3002\u4ee5\u4e0b\u662f\u8bed\u6cd5\u793a\u4f8b\uff1a<\/p>\n<pre><code class=\"language-text\">mysqlsh -h172.16.22.1 -P3306 -uroot -p -- cluster status\n<\/code><\/pre>\n<pre><code class=\"language-text\">mysqlsh -h172.16.22.1 -P3306 -uroot -p\nvar cluster=dba.getCluster()\ncluster.status()\n<\/code><\/pre>\n<p><img decoding=\"async\" src=\"http:\/\/www.ccwifi.cc\/blogs\/wp-content\/uploads\/2024\/03\/1710700607897_0.png\" alt=\"hashcat\u600e\u4e48\u4f7f\u7528\u9ed8\u8ba4\u5bc6\u7801\"><\/p>\n<pre><code class=\"language-text\">JS &gt; option -l\n ...\n credentialStore.excludeFilters  []\n credentialStore.helper          default\n credentialStore.savePasswords   prompt\n ...\n<\/code><\/pre>\n<p>\u793a\u4f8b\uff1a\u53ef\u4ee5\u76f4\u63a5\u8f93\u51fa\u96c6\u7fa4\u72b6\u6001\u4fe1\u606f\uff0c\u7b49\u540c\u4e8e\uff1a<\/p>\n<pre><code class=\"language-text\">shell.options.setPersist(\"credentialStore.helper\", \"\")\n<\/code><\/pre>\n<p>\u901a\u8fc7\u4e0b\u9762\u4ecb\u7ecd\u7684\u5bc6\u7801\u4fdd\u5b58\u65b9\u6cd5\uff0c\u53ef\u4ee5\u907f\u514d\u5728\u811a\u672c\u4e2d\u66b4\u9732\u5bc6\u7801\uff0c\u4e5f\u53ef\u4ee5\u907f\u514d\u4ea4\u4e92\u5f0f\u8f93\u5165\u5bc6\u7801\uff0c\u4ece\u800c\u65b9\u4fbf\u5730\u67e5\u8be2\u72b6\u6001\u6216\u8fdb\u884c\u7ef4\u62a4\u64cd\u4f5c\uff0c\u4f8b\u5982\uff1a<\/p>\n<pre><code class=\"language-text\">shell.options.setPersist(\"credentialStore.savePasswords\",\"always\")\n<\/code><\/pre>\n<p>\u5982\u679ccredentialStore.helper\u663e\u793a\u4e3a\u7a7a\uff0c\u5219\u65e0\u6cd5\u4f7f\u7528\u5bc6\u7801\u5b58\u50a8\u548c\u68c0\u7d22\u529f\u80fd\u3002\u901a\u5e38\u662f\u56e0\u4e3a\u6ca1\u6709\u5b89\u88c5mysql<em>config<\/em>editor\u3002\u56e0\u4e3amysql shell\u7684\u5bc6\u7801\u4fdd\u5b58\u5b9e\u9645\u4e0a\u4e5f\u662f\u4f7f\u7528mysql<em>config<\/em>editor\u5b9e\u73b0\u7684\u3002\u4e0b\u9762\u5c06\u8be6\u7ec6\u89e3\u91ca\u5177\u4f53\u7528\u6cd5\u3002<\/p>\n<p>credentialStore.savePasswords\u53c2\u6570\u7528\u4e8e\u63a7\u5236\u6bcf\u6b21\u8fde\u63a5\u65f6\u4fdd\u5b58\u5bc6\u7801\u7684\u884c\u4e3a\uff1a<\/p>\n<p><!-- \u6587\u7ae0\u6765\u6e90:https:\/\/zhuanlan.zhihu.com\/p\/347083164 --><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6280\u672f\u5206\u4eab | mysqlsh \u547d\u4ee4\u884c\u6a21\u5f0f &amp; \u5bc6\u7801\u4fdd\u5b58\u547d\u4ee4\u884c\u6a21\u5f0fmysql shell \u5982\u4f55\u5b9e\u73b0\u7c7b\u4f3c mysql -e show processlist; \u7684\u6548\u679c\uff1f\u5373\u6267\u884c\u5b8c\u5c31\u9000\u51fa\u767b\u5f55\uff0c\u4e0d\u9700\u8981\u4ea4\u4e92\uff0c\u6211\u4eec\u7ecf\u5e38\u5728\u811a\u672c\u4e2d\u8fd9\u6837\u4f7f\u7528\u3002\u90a3\u4e48\u540c\u6837\u7684<\/p>\n","protected":false},"author":1,"featured_media":1937,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"topic":[],"class_list":["post-1936","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-1"],"_links":{"self":[{"href":"https:\/\/www.ccwifi.cc\/blogs\/wp-json\/wp\/v2\/posts\/1936","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ccwifi.cc\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ccwifi.cc\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ccwifi.cc\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ccwifi.cc\/blogs\/wp-json\/wp\/v2\/comments?post=1936"}],"version-history":[{"count":0,"href":"https:\/\/www.ccwifi.cc\/blogs\/wp-json\/wp\/v2\/posts\/1936\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ccwifi.cc\/blogs\/wp-json\/wp\/v2\/media\/1937"}],"wp:attachment":[{"href":"https:\/\/www.ccwifi.cc\/blogs\/wp-json\/wp\/v2\/media?parent=1936"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ccwifi.cc\/blogs\/wp-json\/wp\/v2\/categories?post=1936"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ccwifi.cc\/blogs\/wp-json\/wp\/v2\/tags?post=1936"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.ccwifi.cc\/blogs\/wp-json\/wp\/v2\/topic?post=1936"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}