{"id":3021,"date":"2021-09-24T09:10:45","date_gmt":"2021-09-24T01:10:45","guid":{"rendered":"https:\/\/nj.transwarp.cn:8180\/?p=3021"},"modified":"2025-12-16T14:43:39","modified_gmt":"2025-12-16T06:43:39","slug":"txsql-%e7%9a%84root%e5%af%86%e7%a0%81%e4%bf%ae%e6%94%b9%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"https:\/\/kbwp.transwarp.cn\/?p=3021","title":{"rendered":"txsql \u7684root\u5bc6\u7801\u4fee\u6539\u65b9\u6cd5"},"content":{"rendered":"

\u6982\u8981\u63cf\u8ff0<\/h3>\n
\n

TxSQL \u7684 root \u7528\u6237\u88ab TxSQL \u7684 phxbinlogsvr \u89d2\u8272\u4f7f\u7528\uff0c\u56e0\u6b64 root \u7528\u6237\u7684\u5bc6\u7801\u4e0d\u80fd\u76f4\u63a5\u4f7f\u7528SQL\u8bed\u53e5\u8fdb\u884c\u4fee\u6539\uff0c\u56e0\u4e3a\u76f4\u63a5\u7684\u4fee\u6539\u4e0d\u80fd\u5c06\u8fd9\u79cd\u66f4\u6539\u901a\u77e5\u5230 phxbinlogsvr \u89d2\u8272\uff0c\u4f1a\u5bfc\u81f4 phxbinlogsvr \u65e0\u6cd5\u8fde\u63a5\u5230\u5176\u5bf9\u5e94\u7684 MySQL \u89d2\u8272\uff0c\u7136\u540e\u5bfc\u81f4 TxSQL \u762b\u75ea\u3002
\n\u672c\u6848\u4f8b\u9488\u5bf9 TDH \u96c6\u7fa4\u7684TXSQL \u670d\u52a1\u7684 root \u7528\u6237\u5bc6\u7801\u4fee\u6539\u505a\u4e00\u4e2a\u6f14\u793a\u3002<\/p>\n

\u8be6\u7ec6\u8bf4\u660e<\/h3>\n
\n

TDH \u96c6\u7fa4\u4fee\u6539TXSQL \u670d\u52a1\u7684root \u5bc6\u7801\u7684\u64cd\u4f5c\u4e3b\u8981\u5206\u4ee5\u4e0b\u51e0\u4e2a\u6b65\u9aa4\uff1a<\/p>\n

    \n
  1. \u5728 TXSQL Master \u4e3b\u8282\u70b9\uff0c\u4f7f\u7528 txsql.sh \u811a\u672c\u4fee\u6539 root \u7528\u6237\u5bc6\u7801<\/li>\n
  2. \u4f7f\u7528\u4fee\u6539\u540e\u7684\u5bc6\u7801\u4ee5\u53ca socket \u767b\u5f55 TXSQL \u6570\u636e\u5e93\u4fee\u6539 ‘root’@’%’ \u7684\u5bc6\u7801<\/li>\n
  3. \u4fee\u6539 TXSQL \u670d\u52a1\u914d\u7f6e\u4e2d\u7684 root \u7528\u6237\u5bc6\u7801<\/li>\n
  4. \u4fee\u6539\u5176\u4ed6\u4f7f\u7528 root \u5bc6\u7801\u7684\u670d\u52a1\u4e2d root \u5bc6\u7801\u7684\u914d\u7f6e<\/li>\n
  5. \u91cd\u542f TXSQL \u751f\u6548<\/li>\n<\/ol>\n

    \u5728 TXSQL Master \u4e3b\u8282\u70b9\uff0c\u4f7f\u7528 txsql.sh \u811a\u672c\u4fee\u6539 root \u7528\u6237\u5bc6\u7801<\/h4>\n

    \u8fdb\u5165TXSQL Master pod\uff0c\u6267\u884c\/usr\/bin\/txsql\/tools\/txsql.sh passwd -p <\u65e7\u5bc6\u7801> -P <\u65b0\u5bc6\u7801><\/code><\/strong><\/p>\n

    \u65e7\u5bc6\u7801\u53ef\u4ee5\u901a\u8fc7\u914d\u7f6e\u6587\u4ef6\u67e5\u770b\uff0c\u76f8\u5173\u914d\u7f6e\u6587\u4ef6\u4e3a\uff1a\/etc\/txsql1\/conf\/db.properties<\/strong>\uff0c\u5177\u4f53\u53c2\u89c1\u4e0b\u56fe\uff1a<\/p>\n

    \u6267\u884c\u4fee\u6539\u5bc6\u7801\u540e\u7684\u8f93\u51fa\u5982\u4e0b\uff1a<\/p>\n

    \"file\"<\/p>\n

    \u4fee\u6539 TXSQL \u670d\u52a1\u914d\u7f6e\u4e2d\u7684 root \u7528\u6237\u5bc6\u7801<\/h4>\n

    \u9488\u5bf9\u65e7\u7248\u672c\u7684Manager\uff0c\u53ef\u4ee5\u5728 Manager \u9875\u9762\u4e0a\u76f4\u63a5\u4fee\u6539 TxSQL \u914d\u7f6e\u4e2d\u7684 root \u7528\u6237\u7684\u5bc6\u7801\uff0c\u4fee\u6539\u4e4b\u540e\u914d\u7f6eTxSQL\u670d\u52a1\u3002<\/p>\n

    \u8f83\u65b0\u7248\u672c\u7684TDH\u7684 Manager \u9875\u9762\u53d6\u6d88\u4e86\u660e\u6587\u7684txsql\u5bc6\u7801\u4fee\u6539\uff0c\u9700\u8981\u9010\u4e2a\u4fee\u6539pod\u5185 \/usr\/bin\/txsql\/etc\/db.properties<\/code><\/strong> \u6587\u4ef6\u4e2d\u914d\u7f6e\u7684root\u7528\u6237\u7684\u5bc6\u7801\u3002<\/p>\n

    \"file\"<\/p>\n

    \u540c\u65f6\u8fdb\u5165\u5230 Manager \u7684 MariaDB \u4e2d\u4fee\u6539\u5bf9\u5e94\u7684\u914d\u7f6e\u914d\u7f6e\u9879\u4e3a root.password<\/code><\/strong><\/p>\n

    select * from service_config where serviceId=(select id from service where type = 'TXSQL'); <\/code><\/pre>\n
    \"file\"<\/p>\n
    \u7136\u540e\u66f4\u65b0\u8be5\u914d\u7f6e\u9879root.password<\/code><\/strong>\u7684 value \u503c\u4e3a\u65b0\u5bc6\u7801<\/p>\n
    update service_config set value='1qaz2wsX' where name='root.password' and serviceId=(select id from service where type = 'TXSQL');<\/code><\/pre>\n
    \"file\"<\/p>\n
    \u4fee\u6539\u5176\u4ed6\u4f7f\u7528 root \u5bc6\u7801\u7684\u670d\u52a1\u4e2d root \u5bc6\u7801\u7684\u914d\u7f6e\u3002<\/h4>\n
    \u5982\u679c\u6709\u5176\u4ed6\u4f7f\u7528root \u5bc6\u7801\u7684\u670d\u52a1\uff0c\u4e5f\u9700\u8981\u4f7f\u7528\u7c7b\u4f3c\u7b2c\u4e09\u6b65\u7684\u65b9\u6cd5\u4fee\u6539 root \u7528\u6237\u5bc6\u7801<\/p>\n
    \u91cd\u542f TXSQL \u751f\u6548<\/h4>\n
    \u91cd\u542ftxsql\u751f\u6548\uff0c\u6b64\u5904\u4e00\u5b9a\u662f\u5728manager \u9875\u9762\u91cd\u542ftxsql\uff0c\u4e0d\u80fd\u53ea\u662f\u5728\u540e\u53f0\u5220\u9664 txsql \u7684pod\u3002<\/p>\n
    \u4f7f\u7528\u65b0\u5bc6\u7801\u767b\u5f55\u9a8c\u8bc1\u3002<\/p>\n
    \"file\"<\/p>\n","protected":false},"excerpt":{"rendered":"
    \u6982\u8981\u63cf\u8ff0 TxSQL \u7684 root \u7528\u6237\u88ab TxSQL \u7684 phxbinlogsvr \u89d2\u8272\u4f7f\u7528\uff0c\u56e0\u6b64 root ..<\/p>\n
    <\/div>\n
    Read more<\/a><\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-3021","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"acf":[],"_links":{"self":[{"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts\/3021","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3021"}],"version-history":[{"count":3,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts\/3021\/revisions"}],"predecessor-version":[{"id":17799,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts\/3021\/revisions\/17799"}],"wp:attachment":[{"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3021"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3021"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3021"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}