{"id":18191,"date":"2025-04-19T00:38:32","date_gmt":"2025-04-18T16:38:32","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/18191.html"},"modified":"2025-04-19T00:38:32","modified_gmt":"2025-04-18T16:38:32","slug":"mysql%e7%a8%8b%e5%ba%8f%e4%b9%8b%ef%bc%9a%e4%bd%bf%e7%94%a8%e7%b1%bb%e4%bc%bcuri%e7%9a%84%e5%ad%97%e7%ac%a6%e4%b8%b2%e6%88%96%e9%94%ae%e5%80%bc%e5%af%b9%e8%bf%9e%e6%8e%a5%e5%88%b0%e6%9c%8d%e5%8a%a1","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/18191.html","title":{"rendered":"MySQL\u7a0b\u5e8f\u4e4b\uff1a\u4f7f\u7528\u7c7b\u4f3cURI\u7684\u5b57\u7b26\u4e32\u6216\u952e\u503c\u5bf9\u8fde\u63a5\u5230\u670d\u52a1\u5668"},"content":{"rendered":"<p>\u672c\u8282\u4ecb\u7ecd\u4f7f\u7528\u7c7b\u4f3cURI\u7684\u8fde\u63a5\u5b57\u7b26\u4e32\u6216\u952e\u503c\u5bf9\u6765\u6307\u5b9a\u5982\u4f55\u4e3aMySQLShell\u7b49\u5ba2\u6237\u7aef\u5efa\u7acb\u5230MySQL\u670d\u52a1\u5668\u7684\u8fde\u63a5\u3002<\/p>\n<p>\u4ee5\u4e0bMySQL\u5ba2\u6237\u7aef\u652f\u6301\u4f7f\u7528\u7c7b\u4f3cURI\u7684\u8fde\u63a5\u5b57\u7b26\u4e32\u6216\u952e\u503c\u5bf9\u8fde\u63a5\u5230MySQL\u670d\u52a1\u5668&#xff1a;<\/p>\n<ul>\n<li>MySQL Shell<\/li>\n<li>\u5b9e\u73b0X DevAPI\u7684MySQL\u8fde\u63a5\u5668<\/li>\n<\/ul>\n<p>\u672c\u8282\u8bb0\u5f55\u4e86\u6240\u6709\u6709\u6548\u7684\u7c7b\u4f3cURI\u7684\u5b57\u7b26\u4e32\u548c\u952e\u503c\u5bf9\u8fde\u63a5\u53c2\u6570\u7684\u5f71\u54cd&#xff0c;\u5176\u4e2d\u8bb8\u591a\u4e0e\u547d\u4ee4\u884c\u9009\u9879\u6307\u5b9a\u7684\u76f8\u4f3c&#xff1a;<\/p>\n<ul>\n<li>\u4f7f\u7528\u7c7b\u4f3cURI\u7684\u5b57\u7b26\u4e32\u6307\u5b9a\u7684\u53c2\u6570\u4f7f\u7528myuser&#064;example.com:3306\/main-schema\u7b49\u8bed\u6cd5\u3002<\/li>\n<li>\u4f7f\u7528\u952e\u503c\u5bf9\u6307\u5b9a\u7684\u53c2\u6570\u4f7f\u7528\u4ee5\u4e0b\u8bed\u6cd5{user:&#039;myuser&#039;, host:&#039;example.com&#039;, port:3306, schema:&#039;main-schema&#039;}\u3002<\/li>\n<\/ul>\n<p>\u8fde\u63a5\u53c2\u6570\u4e0d\u533a\u5206\u5927\u5c0f\u5199\u3002\u5982\u679c\u6307\u5b9a&#xff0c;\u6bcf\u4e2a\u53c2\u6570\u53ea\u80fd\u7ed9\u51fa\u4e00\u6b21\u3002\u5982\u679c\u4e00\u4e2a\u53c2\u6570\u88ab\u6307\u5b9a\u591a\u6b21&#xff0c;\u5219\u4f1a\u53d1\u751f\u9519\u8bef\u3002<\/p>\n<h5>\u57fa\u7840\u8fde\u63a5\u53c2\u6570<\/h5>\n<\/p>\n<p>\u4ee5\u4e0b\u8ba8\u8bba\u63cf\u8ff0\u4e86\u6307\u5b9a\u4e0eMySQL\u7684\u8fde\u63a5\u65f6\u53ef\u7528\u7684\u53c2\u6570\u3002\u8fd9\u4e9b\u53c2\u6570\u53ef\u4ee5\u4f7f\u7528\u7b26\u5408\u57fa\u672c\u7c7b\u4f3cURI\u8bed\u6cd5\u7684\u5b57\u7b26\u4e32&#xff08;\u8bf7\u53c2\u9605\u4f7f\u7528\u7c7b\u4f3cURI\u7684\u8fde\u63a5\u5b57\u7b26\u4e32\u8fdb\u884c\u8fde\u63a5&#xff09;\u6216\u4f5c\u4e3a\u952e\u503c\u5bf9&#xff08;\u8bf7\u53c2\u9605\u4f7f\u7528\u952e\u503c\u5bf9\u8fdb\u884c\u8fde\u63a5&#xff09;\u63d0\u4f9b\u3002<\/p>\n<ul>\n<li>scheme&#xff1a;\u8981\u4f7f\u7528\u7684\u4f20\u8f93\u534f\u8bae\u3002X\u534f\u8bae\u8fde\u63a5\u4f7f\u7528mysqlx&#xff0c;\u7ecf\u5178MySQL\u534f\u8bae\u8fde\u63a5\u4f7f\u7528mysql\u3002\u5982\u679c\u672a\u6307\u5b9a\u534f\u8bae&#xff0c;\u670d\u52a1\u5668\u4f1a\u5c1d\u8bd5\u731c\u6d4b\u534f\u8bae\u3002\u652f\u6301\u57df\u540d\u7cfb\u7edfSRV\u7684\u8fde\u63a5\u5668\u53ef\u4ee5\u4f7f\u7528mysqlx&#043;srv\u65b9\u6848&#xff08;\u8bf7\u53c2\u9605\u4f7f\u7528DNS SRV\u8bb0\u5f55\u7684\u8fde\u63a5&#xff09;\u3002<\/li>\n<li>\n<p>user&#xff1a;MySQL\u4e3a\u7528\u6237\u5e10\u6237\u63d0\u4f9b\u9274\u6743\u8fc7\u7a0b\u3002<\/p>\n<\/li>\n<li>\n<p>password&#xff1a;\u7528\u4e8e\u9274\u6743\u8fc7\u7a0b\u7684\u5bc6\u7801\u3002\u5728\u8fde\u63a5\u89c4\u8303\u4e2d\u6307\u5b9a\u663e\u5f0f\u5bc6\u7801\u4e0d\u5b89\u5168\u4e14\u4e0d\u63a8\u8350\u3002\u7a0d\u540e\u7684\u8ba8\u8bba\u5c06\u5c55\u793a\u5982\u4f55\u5bfc\u81f4\u5bc6\u7801\u51fa\u73b0\u4ea4\u4e92\u5f0f\u63d0\u793a\u3002<\/p>\n<\/li>\n<li>\n<p>host&#xff1a;\u8fd0\u884c\u670d\u52a1\u5668\u5b9e\u4f8b\u7684\u4e3b\u673a\u3002\u8be5\u503c\u53ef\u4ee5\u662f\u4e3b\u673a\u540d\u3001IPv4\u5730\u5740\u6216IPv6\u5730\u5740\u3002\u5982\u679c\u672a\u6307\u5b9a\u4e3b\u673a&#xff0c;\u5219\u9ed8\u8ba4\u4e3alocalhost\u3002<\/p>\n<\/li>\n<li>\n<p>port&#xff1a;\u76ee\u6807MySQL\u670d\u52a1\u5668\u4fa6\u542c\u8fde\u63a5\u7684TCP\/IP\u7f51\u7edc\u7aef\u53e3\u3002\u5982\u679c\u672a\u6307\u5b9a\u7aef\u53e3&#xff0c;\u5219X\u534f\u8bae\u8fde\u63a5\u9ed8\u8ba4\u4e3a33060&#xff0c;\u7ecf\u5178MySQL\u534f\u8bae\u8fde\u63a5\u9ed8\u8ba4\u4e3a3306\u3002<\/p>\n<\/li>\n<li>\n<p>socket&#xff1a;Unix\u5957\u63a5\u5b57\u6587\u4ef6\u7684\u8def\u5f84\u6216Windows\u547d\u540d\u7ba1\u9053\u7684\u540d\u79f0\u3002\u503c\u662f\u672c\u5730\u6587\u4ef6\u8def\u5f84\u3002\u5728\u7c7b\u4f3cURI\u7684\u5b57\u7b26\u4e32\u4e2d&#xff0c;\u5b83\u4eec\u5fc5\u987b\u4f7f\u7528\u767e\u5206\u6bd4\u7f16\u7801\u6216\u7528\u62ec\u53f7\u5305\u56f4\u8def\u5f84\u8fdb\u884c\u7f16\u7801\u3002\u62ec\u53f7\u6d88\u9664\u4e86\u767e\u5206\u6bd4\u7f16\u7801\u5b57\u7b26\u7684\u9700\u8981&#xff0c;\u4f8b\u5982\/\u76ee\u5f55\u5206\u9694\u7b26\u5b57\u7b26\u3002\u4f8b\u5982&#xff0c;\u8981\u4f7f\u7528Unix\u5957\u63a5\u5b57\u8fde\u63a5\u4e3aroot&#064;localhost\/tmp\/mysql.sock&#xff0c;\u4f7f\u7528\u767e\u5206\u6bd4\u7f16\u7801\u6307\u5b9a\u8def\u5f84\u4e3aroot&#064;localhost?socket&#061;%2Ftmp%2Fmysql.sock&#xff0c;\u6216\u4f7f\u7528\u62ec\u53f7\u4f5c\u4e3aroot&#064;localhost?socket&#061;(\/tmp\/mysql.sock)\u3002<\/p>\n<\/li>\n<li>\n<p>schema&#xff1a;\u8fde\u63a5\u7684\u9ed8\u8ba4\u6570\u636e\u5e93\u3002\u5982\u679c\u672a\u6307\u5b9a\u6570\u636e\u5e93&#xff0c;\u5219\u8fde\u63a5\u6ca1\u6709\u9ed8\u8ba4\u6570\u636e\u5e93\u3002<\/p>\n<\/li>\n<\/ul>\n<p>Unix\u5bf9localhost\u7684\u5904\u7406\u53d6\u51b3\u4e8e\u4f20\u8f93\u534f\u8bae\u7684\u7c7b\u578b\u3002\u4f7f\u7528\u7ecf\u5178MySQL\u534f\u8bae\u7684\u8fde\u63a5\u5904\u7406localhost\u4e0e\u5176\u4ed6MySQL\u5ba2\u6237\u7aef\u76f8\u540c\u7684\u65b9\u5f0f&#xff0c;\u8fd9\u610f\u5473\u7740localhost\u88ab\u5047\u5b9a\u4e3a\u57fa\u4e8e\u5957\u63a5\u5b57\u7684\u8fde\u63a5\u3002\u5bf9\u4e8e\u4f7f\u7528X\u534f\u8bae\u7684\u8fde\u63a5&#xff0c;localhost\u7684\u884c\u4e3a\u4e0d\u540c\u4e4b\u5904\u5728\u4e8e\u5b83\u88ab\u5047\u5b9a\u4e3a\u8868\u793a\u73af\u56de\u5730\u5740&#xff0c;\u4f8b\u5982IPv4\u5730\u5740127.0.0.1\u3002<\/p>\n<h5>\u9644\u52a0\u8fde\u63a5\u53c2\u6570<\/h5>\n<p>\u60a8\u53ef\u4ee5\u6307\u5b9a\u8fde\u63a5\u7684\u9009\u9879&#xff0c;\u901a\u8fc7\u9644\u52a0?attribute&#061;value\u4f5c\u4e3a\u7c7bURI\u5b57\u7b26\u4e32\u4e2d\u7684\u5c5e\u6027&#xff0c;\u6216\u8005\u4f5c\u4e3a\u952e\u503c\u5bf9\u3002\u4ee5\u4e0b\u9009\u9879\u53ef\u7528&#xff1a;<\/p>\n<ul>\n<li>\n<p>ssl-mode&#xff1a;\u8fde\u63a5\u6240\u9700\u7684\u5b89\u5168\u72b6\u6001\u3002\u4ee5\u4e0b\u6a21\u5f0f\u662f\u5141\u8bb8\u7684&#xff1a;DISABLED\u3001PREFERRED\u3001REQUIRED\u3001VERIFY_CA\u3001VERIFY_IDENTITY&#xff0c;\u91cd\u8981&#xff1a;VERIFY_CA\u5e76\u4e14VERIFY_IDENTITY\u662f\u6bd4\u9ed8\u8ba4\u7684PREFERRED\u66f4\u597d\u7684\u9009\u62e9&#xff0c;\u56e0\u4e3a\u5b83\u4eec\u6709\u52a9\u4e8e\u9632\u6b62\u4e2d\u95f4\u4eba\u653b\u51fb\u3002<\/p>\n<\/li>\n<li>\n<p>ssl-ca&#xff1a;PEM\u683c\u5f0f\u7684X.509\u8bc1\u4e66\u9881\u53d1\u673a\u6784\u6587\u4ef6\u7684\u8def\u5f84\u3002<\/p>\n<\/li>\n<li>\n<p>ssl-capath&#xff1a;\u5305\u542bPEM\u683c\u5f0f\u7684X.509\u8bc1\u4e66\u6388\u6743\u6587\u4ef6\u7684\u76ee\u5f55\u7684\u8def\u5f84\u3002<\/p>\n<\/li>\n<li>\n<p>ssl-cert&#xff1a;PEM\u683c\u5f0f\u7684X.509\u8bc1\u4e66\u6587\u4ef6\u7684\u8def\u5f84\u3002<\/p>\n<\/li>\n<li>\n<p>ssl-cipher&#xff1a;\u7528\u4e8e\u901a\u8fc7TLSv1.2\u4f7f\u7528TLS\u534f\u8bae\u7684\u8fde\u63a5\u7684\u52a0\u5bc6\u5bc6\u7801\u3002<\/p>\n<\/li>\n<li>\n<p>ssl-crl&#xff1a;\u5305\u542bPEM\u683c\u5f0f\u8bc1\u4e66\u540a\u9500\u5217\u8868\u7684\u6587\u4ef6\u7684\u8def\u5f84\u3002<\/p>\n<\/li>\n<li>\n<p>ssl-crlpath&#xff1a;\u5305\u542bPEM\u683c\u5f0f\u8bc1\u4e66\u540a\u9500\u5217\u8868\u6587\u4ef6\u7684\u76ee\u5f55\u7684\u8def\u5f84\u3002<\/p>\n<\/li>\n<li>\n<p>ssl-key&#xff1a;PEM\u683c\u5f0f\u7684X.509\u5bc6\u94a5\u6587\u4ef6\u7684\u8def\u5f84\u3002<\/p>\n<\/li>\n<li>tls-version&#xff1a;\u7ecf\u5178MySQL\u534f\u8bae\u52a0\u5bc6\u8fde\u63a5\u5141\u8bb8\u7684TLS\u534f\u8bae\u3002\u6b64\u9009\u9879\u4ec5\u53d7MySQLShell\u652f\u6301\u3002tls-version&#xff08;\u5355\u6570&#xff09;\u7684\u503c\u662f\u9017\u53f7\u5206\u9694\u7684\u5217\u8868&#xff0c;\u4f8b\u5982TLSv1.2\u3001TLSv1.3\u3002\u6709\u5173\u8be6\u7ec6\u4fe1\u606f&#xff0c;\u8bf7\u53c2\u9605\u201c\u52a0\u5bc6\u8fde\u63a5TLS\u534f\u8bae\u548c\u5bc6\u7801\u201d\u3002\u6b64\u9009\u9879\u53d6\u51b3\u4e8e\u672a\u8bbe\u7f6e\u4e3aDISABLED\u7684ssl-mode\u9009\u9879\u3002<\/li>\n<li>TLS-\u7248\u672c&#xff1a;\u52a0\u5bc6X\u534f\u8bae\u8fde\u63a5\u5141\u8bb8\u7684TLS\u534f\u8bae\u3002TLS-\u7248\u672c\u7684\u503c&#xff08;\u590d\u6570&#xff09;\u662f\u4e00\u4e2a\u6570\u7ec4&#xff0c;\u4f8b\u5982[TLSv1.2&#xff0c; TLSv1.3]\u3002\u6709\u5173\u8be6\u7ec6\u4fe1\u606f&#xff0c;\u8bf7\u53c2\u9605&#xff0c;\u201c\u52a0\u5bc6\u8fde\u63a5TLS\u534f\u8bae\u548c\u5bc6\u7801\u201d\u3002\u6b64\u9009\u9879\u53d6\u51b3\u4e8e\u672a\u8bbe\u7f6e\u4e3aDISABLED\u7684ssl\u6a21\u5f0f\u9009\u9879\u3002<\/li>\n<li>tls-ciphersuites&#xff1a;\u5141\u8bb8\u7684TLS\u5bc6\u7801\u5957\u4ef6\u3002tls-ciphersuites\u7684\u503c\u662fTLS\u5bc6\u7801\u5957\u4ef6\u4e2d\u5217\u51fa\u7684IANA\u5bc6\u7801\u5957\u4ef6\u540d\u79f0\u5217\u8868\u3002\u6709\u5173\u8be6\u7ec6\u4fe1\u606f&#xff0c;\u8bf7\u53c2\u9605\u201c\u52a0\u5bc6\u8fde\u63a5TLS\u534f\u8bae\u548c\u5bc6\u7801\u201d\u3002\u6b64\u9009\u9879\u53d6\u51b3\u4e8e\u672a\u8bbe\u7f6e\u4e3aDISABLED\u7684ssl-mode\u9009\u9879\u3002<\/li>\n<li>\n<p>auth-method&#xff1a;\u7528\u4e8e\u8fde\u63a5\u7684\u9274\u6743\u65b9\u6cd5\u3002\u9ed8\u8ba4\u4e3aAUTO&#xff0c;\u8868\u793a\u670d\u52a1\u5668\u5c1d\u8bd5\u731c\u6d4b\u3002\u4ee5\u4e0b\u65b9\u6cd5\u662f\u5141\u8bb8\u7684&#xff1a;AUTO\u3001MYSQL41\u3001SHA256_MEMORY\u3001FROM_CAPABILITIES\u3001FALLBACK\u3001PLAIN&#xff0c;\u5bf9\u4e8eX\u534f\u8bae\u8fde\u63a5&#xff0c;\u4efb\u4f55\u914d\u7f6eauth-method\u90fd\u5c06\u88ab\u8986\u76d6\u5230\u4ee5\u4e0b\u9274\u6743\u65b9\u6cd5\u5e8f\u5217&#xff1a;MYSQL41\u3001SHA256_MEMORY\u3001PLAIN\u3002<\/p>\n<\/li>\n<li>\n<p>get-server-public-key&#xff1a;\u5411\u670d\u52a1\u5668\u8bf7\u6c42\u57fa\u4e8eRSA\u5bc6\u94a5\u5bf9\u7684\u5bc6\u7801\u4ea4\u6362\u6240\u9700\u7684\u516c\u94a5\u3002\u901a\u8fc7SSL\u6a21\u5f0f\u7684\u7ecf\u5178MySQL\u534f\u8bae\u8fde\u63a5\u5230MySQL8&#043;\u53f0\u670d\u52a1\u5668\u65f6\u4f7f\u7528DISABLED\u3002\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b&#xff0c;\u60a8\u5fc5\u987b\u6307\u5b9a\u534f\u8bae\u3002\u4f8b\u5982&#xff1a;<\/p>\n<p> mysql:\/\/user&#064;localhost:3306?get-server-public-key&#061;true <\/p>\n<p>\u6b64\u9009\u9879\u9002\u7528\u4e8e\u4f7f\u7528caching_sha2_password\u9274\u6743\u63d2\u4ef6\u8fdb\u884c\u8eab\u4efd\u9a8c\u8bc1\u7684\u5ba2\u6237\u7aef\u3002\u5bf9\u4e8e\u8be5\u63d2\u4ef6&#xff0c;\u9664\u975e\u8bf7\u6c42&#xff0c;\u5426\u5219\u670d\u52a1\u5668\u4e0d\u4f1a\u53d1\u9001\u516c\u94a5\u3002\u5bf9\u4e8e\u672a\u4f7f\u7528\u8be5\u63d2\u4ef6\u8fdb\u884c\u8eab\u4efd\u9a8c\u8bc1\u7684\u5e10\u6237&#xff0c;\u6b64\u9009\u9879\u5c06\u88ab\u5ffd\u7565\u3002\u5982\u679c\u4e0d\u4f7f\u7528\u57fa\u4e8eRSA\u7684\u5bc6\u7801\u4ea4\u6362&#xff0c;\u4e5f\u4f1a\u5ffd\u7565\u6b64\u9009\u9879&#xff0c;\u4f8b\u5982\u5ba2\u6237\u7aef\u4f7f\u7528\u5b89\u5168\u8fde\u63a5\u8fde\u63a5\u5230\u670d\u52a1\u5668\u65f6\u3002<\/p>\n<p>\u5982\u679c\u7ed9\u51faserver-public-key-path&#061;file_name\u5e76\u6307\u5b9a\u6709\u6548\u7684\u516c\u94a5\u6587\u4ef6&#xff0c;\u5219\u5b83\u4f18\u5148\u4e8eget-server-public-key\u3002<\/p>\n<\/li>\n<li>\n<p>server-public-key-path&#xff1a; PEM\u683c\u5f0f\u6587\u4ef6\u7684\u8def\u5f84\u540d&#xff0c;\u5176\u4e2d\u5305\u542b\u670d\u52a1\u5668\u8fdb\u884c\u57fa\u4e8eRSA\u5bc6\u94a5\u5bf9\u7684\u5bc6\u7801\u4ea4\u6362\u6240\u9700\u7684\u516c\u94a5\u7684\u5ba2\u6237\u7aef\u526f\u672c\u3002\u901a\u8fc7SSL\u6a21\u5f0f\u7684\u7ecf\u5178MySQL\u534f\u8bae\u8fde\u63a5\u5230MySQL8&#043;\u670d\u52a1\u5668\u65f6\u4f7f\u7528DISABLED\u3002<\/p>\n<p>\u6b64\u9009\u9879\u9002\u7528\u4e8e\u4f7f\u7528sha256_password&#xff08;\u5df2\u5f03\u7528&#xff09;\u6216caching_sha2_password\u9274\u6743\u63d2\u4ef6\u8fdb\u884c\u8eab\u4efd\u9a8c\u8bc1\u7684\u5ba2\u6237\u7aef\u3002\u5bf9\u4e8e\u672a\u4f7f\u7528\u8fd9\u4e9b\u63d2\u4ef6\u4e4b\u4e00\u8fdb\u884c\u8eab\u4efd\u9a8c\u8bc1\u7684\u5e10\u6237&#xff0c;\u6b64\u9009\u9879\u5c06\u88ab\u5ffd\u7565\u3002\u5982\u679c\u4e0d\u4f7f\u7528\u57fa\u4e8eRSA\u7684\u5bc6\u7801\u4ea4\u6362&#xff0c;\u4e5f\u4f1a\u5ffd\u7565\u6b64\u9009\u9879&#xff0c;\u4f8b\u5982\u5ba2\u6237\u7aef\u4f7f\u7528\u5b89\u5168\u8fde\u63a5\u8fde\u63a5\u5230\u670d\u52a1\u5668\u65f6\u3002<\/p>\n<p>\u5982\u679c\u7ed9\u51faserver-public-key-path&#061;file_name\u5e76\u6307\u5b9a\u6709\u6548\u7684\u516c\u94a5\u6587\u4ef6&#xff0c;\u5219\u5b83\u4f18\u5148\u4e8eget-server-public-key\u3002<\/p>\n<\/li>\n<li>ssh&#xff1a;\u4f7f\u7528SSH\u96a7\u9053\u8fde\u63a5\u5230SSH\u670d\u52a1\u5668\u4ee5\u8bbf\u95eeMySQL\u670d\u52a1\u5668\u5b9e\u4f8b\u7684URI\u3002URI\u683c\u5f0f\u4e3a[user&#064;]host[:port]\u3002\u4f7f\u7528uri\u9009\u9879\u6307\u5b9a\u76ee\u6807MySQL\u670d\u52a1\u5668\u5b9e\u4f8b\u7684URI\u3002<\/li>\n<li>\n<p>uri&#xff1a;\u8981\u901a\u8fc7SSH\u96a7\u9053\u4ecessh\u9009\u9879\u6307\u5b9a\u7684\u670d\u52a1\u5668\u8bbf\u95ee\u7684MySQL\u670d\u52a1\u5668\u5b9e\u4f8b\u7684URI\u3002URI\u683c\u5f0f\u4e3a[scheme:\/\/][user&#064;]host[:port]\u3002\u4e0d\u8981\u4f7f\u7528\u57fa\u672c\u8fde\u63a5\u53c2\u6570&#xff08;scheme\u3001user\u3001host\u3001port&#xff09;\u6765\u6307\u5b9aSSH\u96a7\u9053\u7684MySQL\u670d\u52a1\u5668\u8fde\u63a5&#xff0c;\u53ea\u9700\u4f7f\u7528uri\u9009\u9879\u3002<\/p>\n<\/li>\n<li>\n<p>ssh-password&#xff1a;\u8fde\u63a5\u5230SSH\u670d\u52a1\u5668\u7684\u5bc6\u7801\u3002\u8b66\u544a&#xff1a;\u5728\u8fde\u63a5\u89c4\u8303\u4e2d\u6307\u5b9a\u663e\u5f0f\u5bc6\u7801\u4e0d\u5b89\u5168\u4e14\u4e0d\u63a8\u8350\u3002MySQLShell\u4f1a\u5728\u9700\u8981\u5bc6\u7801\u65f6\u4ee5\u4ea4\u4e92\u65b9\u5f0f\u63d0\u793a\u8f93\u5165\u5bc6\u7801\u3002<\/p>\n<\/li>\n<li>\n<p>ssh-config-file&#xff1a;\u8fde\u63a5SSH\u670d\u52a1\u5668\u7684SSH\u914d\u7f6e\u6587\u4ef6\u3002\u5982\u679c\u672a\u6307\u5b9aMySQLShell\u914d\u7f6e\u9009\u9879ssh.configFile&#xff0c;\u53ef\u4ee5\u4f7f\u7528\u8be5\u9009\u9879\u5c06\u81ea\u5b9a\u4e49\u6587\u4ef6\u8bbe\u7f6e\u4e3a\u9ed8\u8ba4\u503c\u3002\u5982\u679c\u672a\u8bbe\u7f6essh.configFile&#xff0c;\u5219\u9ed8\u8ba4\u4e3a\u6807\u51c6SSH\u914d\u7f6e\u6587\u4ef6~\/.ssh\/config\u3002<\/p>\n<\/li>\n<li>\n<p>ssh-identity-file&#xff1a;\u7528\u4e8e\u8fde\u63a5\u5230SSH\u670d\u52a1\u5668\u7684\u6807\u8bc6\u6587\u4ef6\u3002\u5982\u679c\u672a\u6307\u5b9a\u6b64\u9009\u9879&#xff0c;\u5219\u9ed8\u8ba4\u4e3a\u5728SSH\u4ee3\u7406&#xff08;\u5982\u679c\u4f7f\u7528&#xff09;\u3001SSH\u914d\u7f6e\u6587\u4ef6\u6216SSH\u914d\u7f6e\u6587\u4ef6\u5939&#xff08;~\/. ssh\/id_rsa~\/.ssh\/id_rsa<\/p>\n<\/li>\n<li>\n<p>ssh-identity-pass&#xff1a;\u6807\u8bc6\u6587\u4ef6\u7684\u5bc6\u7801\u7531ssh-identity-file\u9009\u9879\u6307\u5b9a\u3002\u8b66\u544a&#xff1a;\u5728\u8fde\u63a5\u89c4\u8303\u4e2d\u6307\u5b9a\u663e\u5f0f\u5bc6\u7801\u4e0d\u5b89\u5168\u4e14\u4e0d\u63a8\u8350\u3002MySQLShell\u4f1a\u5728\u9700\u8981\u5bc6\u7801\u65f6\u4ee5\u4ea4\u4e92\u65b9\u5f0f\u63d0\u793a\u8f93\u5165\u5bc6\u7801\u3002<\/p>\n<\/li>\n<li>\n<p>connect-timeout&#xff1a;\u4e00\u4e2a\u6574\u6570\u503c&#xff0c;\u7528\u4e8e\u914d\u7f6e\u5ba2\u6237\u7aef&#xff08;\u5982MySQLShell&#xff09;\u5728\u505c\u6b62\u5c1d\u8bd5\u8fde\u63a5\u5230\u65e0\u54cd\u5e94MySQL\u670d\u52a1\u5668\u4e4b\u524d\u7b49\u5f85\u7684\u79d2\u6570\u3002<\/p>\n<\/li>\n<li>\n<p>compression&#xff1a;\u6b64\u9009\u9879\u8bf7\u6c42\u6216\u7981\u7528\u8fde\u63a5\u7684\u538b\u7f29\u3002<\/p>\n<p>\u6b64\u9009\u9879\u53ef\u7528\u7684\u503c\u662f&#xff1a;required&#xff0c;\u8bf7\u6c42\u538b\u7f29&#xff0c;\u5982\u679c\u670d\u52a1\u5668\u4e0d\u652f\u6301&#xff0c;\u5219\u5931\u8d25&#xff1b;preferred&#xff0c;\u8bf7\u6c42\u538b\u7f29\u5e76\u56de\u9000\u5230\u672a\u538b\u7f29\u7684\u8fde\u63a5&#xff1b;disabled&#xff0c;\u8bf7\u6c42\u672a\u538b\u7f29\u7684\u8fde\u63a5&#xff0c;\u5982\u679c\u670d\u52a1\u5668\u4e0d\u5141\u8bb8&#xff0c;\u5219\u5931\u8d25\u3002preferred\u662fX\u534f\u8bae\u8fde\u63a5\u7684\u9ed8\u8ba4\u503c&#xff0c;disabled\u662f\u7ecf\u5178MySQL\u534f\u8bae\u8fde\u63a5\u7684\u9ed8\u8ba4\u503c\u3002\u6709\u5173X\u63d2\u4ef6\u8fde\u63a5\u538b\u7f29\u63a7\u5236\u7684\u4fe1\u606f&#xff0c;\u8bf7\u53c2\u9605\u201c\u4f7f\u7528X\u63d2\u4ef6\u8fdb\u884c\u8fde\u63a5\u538b\u7f29\u201d\u3002\u6ce8&#xff1a;\u4e0d\u540c\u7684MySQL\u5ba2\u6237\u7aef\u5b9e\u73b0\u5176\u5bf9\u8fde\u63a5\u538b\u7f29\u7684\u652f\u6301\u4e0d\u540c\u3002\u6709\u5173\u8be6\u7ec6\u4fe1\u606f&#xff0c;\u8bf7\u53c2\u9605\u5ba2\u6237\u7aef\u7684\u7559\u6863\u3002<\/p>\n<\/li>\n<li>compression-algorithms\u548ccompression-level&#xff1a;\u8fd9\u4e9b\u9009\u9879\u5728MySQLShell\u4e2d\u63d0\u4f9b&#xff0c;\u53ef\u4ee5\u66f4\u597d\u5730\u63a7\u5236\u8fde\u63a5\u538b\u7f29\u3002\u60a8\u53ef\u4ee5\u6307\u5b9a\u5b83\u4eec\u6765\u9009\u62e9\u7528\u4e8e\u8fde\u63a5\u7684\u538b\u7f29\u7b97\u6cd5\u4ee5\u53ca\u7528\u4e8e\u8be5\u7b97\u6cd5\u7684\u6570\u5b57\u538b\u7f29\u7ea7\u522b\u3002\u60a8\u8fd8\u53ef\u4ee5\u4f7f\u7528compression-algorithms\u4ee3\u66ffcompression\u6765\u8bf7\u6c42\u8fde\u63a5\u7684\u538b\u7f29\u3002<\/li>\n<li>\n<p>connection-attributes&#xff1a;\u63a7\u5236\u5e94\u7528\u7a0b\u5e8f\u5728\u8fde\u63a5\u65f6\u4f20\u9012\u7ed9\u670d\u52a1\u5668\u7684\u952e\u503c\u5bf9\u3002\u6709\u5173\u8fde\u63a5\u5c5e\u6027\u7684\u4e00\u822c\u4fe1\u606f&#xff0c;\u8bf7\u53c2\u89c1\u201c\u6027\u80fd\u67b6\u6784\u8fde\u63a5\u5c5e\u6027\u8868\u201d\u3002\u5ba2\u6237\u7aef\u901a\u5e38\u5b9a\u4e49\u4e00\u7ec4\u9ed8\u8ba4\u5c5e\u6027&#xff0c;\u53ef\u4ee5\u7981\u7528\u6216\u542f\u7528\u3002\u4f8b\u5982&#xff1a;<\/p>\n<p> mysqlx:\/\/user&#064;host?connection-attributes<br \/>\nmysqlx:\/\/user&#064;host?connection-attributes&#061;true<br \/>\nmysqlx:\/\/user&#064;host?connection-attributes&#061;false <\/p>\n<p>\u9ed8\u8ba4\u884c\u4e3a\u662f\u53d1\u9001\u9ed8\u8ba4\u5c5e\u6027\u96c6\u3002\u9664\u4e86\u9ed8\u8ba4\u5c5e\u6027\u4e4b\u5916&#xff0c;\u5e94\u7528\u7a0b\u5e8f\u8fd8\u53ef\u4ee5\u6307\u5b9a\u8981\u4f20\u9012\u7684\u5c5e\u6027\u3002\u60a8\u53ef\u4ee5\u5c06\u5176\u4ed6\u8fde\u63a5\u5c5e\u6027\u6307\u5b9a\u4e3a\u8fde\u63a5\u5b57\u7b26\u4e32\u4e2d\u7684connection-attributes\u53c2\u6570\u3002connection-attributes\u53c2\u6570\u503c\u5fc5\u987b\u4e3a\u7a7a&#xff08;\u4e0e\u6307\u5b9atrue\u76f8\u540c&#xff09;\u3001Boolean\u503c&#xff08;true\u6216false\u4ee5\u542f\u7528\u6216\u7981\u7528\u9ed8\u8ba4\u5c5e\u6027\u96c6&#xff09;\u6216\u5217\u8868\u6216\u96f6\u4e2a\u6216\u591a\u4e2akey&#061;value<\/p>\n<p> mysqlx:\/\/user&#064;host?connection-attributes&#061;[attr1&#061;val1,attr2,attr3&#061;]<br \/>\nmysqlx:\/\/user&#064;host?connection-attributes&#061;[] <\/p>\n<p>\u5e94\u7528\u7a0b\u5e8f\u5b9a\u4e49\u7684\u5c5e\u6027\u540d\u79f0\u4e0d\u80fd\u4ee5_\u5f00\u5934&#xff0c;\u56e0\u4e3a\u8fd9\u4e9b\u540d\u79f0\u662f\u4e3a\u5185\u90e8\u5c5e\u6027\u4fdd\u7559\u7684\u3002<\/p>\n<\/li>\n<\/ul>\n<h5>\u4f7f\u7528\u7c7b\u4f3cURI\u7684\u8fde\u63a5\u5b57\u7b26\u4e32\u8fdb\u884c\u8fde\u63a5<\/h5>\n<\/p>\n<p>\u60a8\u53ef\u4ee5\u4f7f\u7528\u7c7b\u4f3cURI\u7684\u5b57\u7b26\u4e32\u6307\u5b9a\u4e0eMySQL Server\u7684\u8fde\u63a5\u3002\u6b64\u7c7b\u5b57\u7b26\u4e32\u53ef\u4ee5\u4e0e\u5e26\u6709&#8211;uri\u547d\u4ee4\u9009\u9879\u7684MySQL Shell\u3001MySQL Shell\\\\connect\u547d\u4ee4\u548c\u5b9e\u73b0X DevAPI\u7684MySQL Connectors\u4e00\u8d77\u4f7f\u7528\u3002<\/p>\n<p>\u7c7b\u4f3cURI\u7684\u8fde\u63a5\u5b57\u7b26\u4e32\u5177\u6709\u4ee5\u4e0b\u8bed\u6cd5&#xff1a;<\/p>\n<p>[scheme:\/\/][user[:[password]]&#064;]host[:port][\/schema][?attribute1&#061;value1&amp;attribute2&#061;value2&#8230; <\/p>\n<p>\u91cd\u8981&#xff1a;\u767e\u5206\u6bd4\u7f16\u7801\u5fc5\u987b\u7528\u4e8e\u7c7bURI\u5b57\u7b26\u4e32\u5143\u7d20\u4e2d\u7684\u4fdd\u7559\u5b57\u7b26\u3002\u4f8b\u5982&#xff0c;\u5982\u679c\u6307\u5b9a\u5305\u542b&#064;\u5b57\u7b26\u7684\u5b57\u7b26\u4e32&#xff0c;\u5219\u8be5\u5b57\u7b26\u5fc5\u987b\u66ff\u6362\u4e3a%40\u3002\u5982\u679c\u5728IPv6\u5730\u5740\u4e2d\u5305\u542b\u533a\u57dfID&#xff0c;\u5219\u7528\u4f5c\u5206\u9694\u7b26\u7684%\u5b57\u7b26\u5fc5\u987b\u66ff\u6362\u4e3a%25\u3002<\/p>\n<p>MySQLShell\u7684shell.parseUri()\u548cshell.unparseUri()\u65b9\u6cd5\u53ef\u7528\u4e8e\u89e3\u6784\u548c\u7ec4\u88c5\u7c7b\u4f3cURI\u7684\u8fde\u63a5\u5b57\u7b26\u4e32\u3002\u7ed9\u5b9a\u4e00\u4e2a\u7c7b\u4f3cURI\u7684\u8fde\u63a5\u5b57\u7b26\u4e32&#xff0c;shell.parseUri()\u8fd4\u56de\u4e00\u4e2a\u5b57\u5178&#xff0c;\u5176\u4e2d\u5305\u542b\u5b57\u7b26\u4e32\u4e2d\u627e\u5230\u7684\u6bcf\u4e2a\u5143\u7d20\u3002shell.unparseUri()\u5c06URI\u7ec4\u4ef6\u548c\u8fde\u63a5\u9009\u9879\u7684\u5b57\u5178\u8f6c\u6362\u4e3a\u6709\u6548\u7684\u7c7b\u4f3cURI\u7684\u8fde\u63a5\u5b57\u7b26\u4e32&#xff0c;\u7528\u4e8e\u8fde\u63a5\u5230MySQL&#xff0c;\u53ef\u4ee5\u5728MySQLShell\u6216\u5b9e\u73b0X DevAPI\u7684MySQL\u8fde\u63a5\u5668\u4e2d\u4f7f\u7528\u3002<\/p>\n<p>\u5982\u679c\u5efa\u8bae\u5728\u7c7bURI\u5b57\u7b26\u4e32\u4e2d\u672a\u6307\u5b9a\u5bc6\u7801&#xff0c;\u5219\u4ea4\u4e92\u5f0f\u5ba2\u6237\u7aef\u4f1a\u63d0\u793a\u8f93\u5165\u5bc6\u7801\u3002\u4ee5\u4e0b\u793a\u4f8b\u663e\u793a\u5982\u4f55\u4f7f\u7528\u7528\u6237\u540duser_name\u6307\u5b9a\u7c7bURI\u5b57\u7b26\u4e32\u3002\u5728\u6bcf\u79cd\u60c5\u51b5\u4e0b&#xff0c;\u90fd\u4f1a\u63d0\u793a\u8f93\u5165\u5bc6\u7801\u3002<\/p>\n<ul>\n<li>\n<p>\u4e0e\u4fa6\u542c\u7aef\u53e333065\u7684\u672c\u5730\u670d\u52a1\u5668\u5b9e\u4f8b\u7684X\u534f\u8bae\u8fde\u63a5\u3002<\/p>\n<p> mysqlx:\/\/user_name&#064;localhost:33065 <\/p>\n<\/li>\n<li>\n<p>\u4e0e\u4fa6\u542c\u7aef\u53e33333\u7684\u672c\u5730\u670d\u52a1\u5668\u5b9e\u4f8b\u7684\u7ecf\u5178MySQL\u534f\u8bae\u8fde\u63a5\u3002<\/p>\n<p> mysql:\/\/user_name&#064;localhost:3333 <\/p>\n<\/li>\n<li>\n<p>\u4f7f\u7528\u4e3b\u673a\u540d\u3001IPv4\u5730\u5740\u548cIPv6\u5730\u5740\u4e0e\u8fdc\u7a0b\u670d\u52a1\u5668\u5b9e\u4f8b\u7684X\u534f\u8bae\u8fde\u63a5\u3002<\/p>\n<p> mysqlx:\/\/user_name&#064;server.example.com\/<br \/>\nmysqlx:\/\/user_name&#064;198.51.100.14:123<br \/>\nmysqlx:\/\/user_name&#064;[2001:db8:85a3:8d3:1319:8a2e:370:7348] <\/p>\n<\/li>\n<li>\n<p>\u4f7f\u7528\u5957\u63a5\u5b57\u7684X\u534f\u8bae\u8fde\u63a5&#xff0c;\u4f7f\u7528\u767e\u5206\u6bd4\u7f16\u7801\u6216\u62ec\u53f7\u63d0\u4f9b\u8def\u5f84\u3002<\/p>\n<p> mysqlx:\/\/user_name&#064;\/path%2Fto%2Fsocket.sock<br \/>\nmysqlx:\/\/user_name&#064;(\/path\/to\/socket.sock) <\/p>\n<\/li>\n<li>\n<p>\u53ef\u4ee5\u6307\u5b9a\u8868\u793a\u6570\u636e\u5e93\u7684\u53ef\u9009\u8def\u5f84\u3002<\/p>\n<p> # use &#039;world&#039; as the default database<br \/>\nmysqlx:\/\/user_name&#064;198.51.100.1\/world<\/p>\n<p># use &#039;world_x&#039; as the default database, encoding _ as %5F<br \/>\nmysqlx:\/\/user_name&#064;198.51.100.2:33060\/world%5Fx <\/p>\n<\/li>\n<li>\n<p>\u53ef\u4ee5\u6307\u5b9a\u4e00\u4e2a\u53ef\u9009\u67e5\u8be2&#xff0c;\u6bcf\u4e2a\u67e5\u8be2\u90fd\u5305\u542bkey&#061;value\u5bf9\u6216\u5355\u4e2akey\u3002\u8981\u6307\u5b9a\u591a\u4e2a\u503c&#xff0c;\u8bf7\u7528\u5b57\u7b26\u5206\u9694\u5b83\u4eec,\u5141\u8bb8\u6df7\u5408\u4f7f\u7528key&#061;value\u548ckey\u3002\u503c\u53ef\u4ee5\u662flist\u7c7b\u578b&#xff0c;\u5217\u8868\u503c\u6309\u5916\u89c2\u6392\u5e8f\u3002\u5b57\u7b26\u4e32\u5fc5\u987b\u4ee5\u767e\u5206\u6bd4\u7f16\u7801\u6216\u7528\u62ec\u53f7\u62ec\u8d77\u6765\u3002\u4ee5\u4e0b\u662f\u7b49\u6548\u7684\u3002<\/p>\n<p> ssluser&#064;127.0.0.1?ssl-ca&#061;%2Froot%2Fclientcert%2Fca-cert.pem\\\\<br \/>\n&amp;ssl-cert&#061;%2Froot%2Fclientcert%2Fclient-cert.pem\\\\<br \/>\n&amp;ssl-key&#061;%2Froot%2Fclientcert%2Fclient-key<\/p>\n<p>ssluser&#064;127.0.0.1?ssl-ca&#061;(\/root\/clientcert\/ca-cert.pem)\\\\<br \/>\n&amp;ssl-cert&#061;(\/root\/clientcert\/client-cert.pem)\\\\<br \/>\n&amp;ssl-key&#061;(\/root\/clientcert\/client-key) <\/p>\n<\/li>\n<li>\n<p>\u8981\u6307\u5b9a\u7528\u4e8e\u52a0\u5bc6\u8fde\u63a5\u7684TLS\u7248\u672c\u548c\u5bc6\u7801\u5957\u4ef6&#xff1a;<\/p>\n<p> mysql:\/\/user_name&#064;198.51.100.2:3306\/world%5Fx?\\\\<br \/>\ntls-versions&#061;[TLSv1.2,TLSv1.3]&amp;tls-ciphersuites&#061;[TLS_DHE_PSK_WITH_AES_128_\\\\<br \/>\nGCM_SHA256, TLS_CHACHA20_POLY1305_SHA256] <\/p>\n<p>\u524d\u9762\u7684\u793a\u4f8b\u5047\u5b9a\u8fde\u63a5\u9700\u8981\u5bc6\u7801\u3002\u5bf9\u4e8e\u4ea4\u4e92\u5f0f\u5ba2\u6237\u7aef&#xff0c;\u5728\u767b\u5f55\u63d0\u793a\u65f6\u8bf7\u6c42\u6307\u5b9a\u7528\u6237\u7684\u5bc6\u7801\u3002\u5982\u679c\u7528\u6237\u5e10\u6237\u6ca1\u6709\u5bc6\u7801&#xff08;\u8fd9\u662f\u4e0d\u5b89\u5168\u7684&#xff0c;\u4e0d\u63a8\u8350\u4f7f\u7528&#xff09;&#xff0c;\u6216\u8005\u4f7f\u7528\u5957\u63a5\u5b57\u5bf9\u7b49\u51ed\u636e\u9274\u6743&#xff08;\u4f8b\u5982&#xff0c;Unix\u5957\u63a5\u5b57\u8fde\u63a5&#xff09;&#xff0c;\u5219\u5fc5\u987b\u5728\u8fde\u63a5\u5b57\u7b26\u4e32\u4e2d\u660e\u786e\u6307\u5b9a\u4e0d\u63d0\u4f9b\u5bc6\u7801&#xff0c;\u4e5f\u4e0d\u9700\u8981\u5bc6\u7801\u63d0\u793a\u3002\u4e3a\u6b64&#xff0c;\u8bf7\u5728\u5b57\u7b26\u4e32\u4e2d\u7684user_name\u4e4b\u540e\u653e\u7f6e:&#xff0c;\u4f46\u4e0d\u8981\u5728\u5176\u540e\u9762\u6307\u5b9a\u5bc6\u7801\u3002\u4f8b\u5982&#xff1a;<\/p>\n<p> mysqlx:\/\/user_name:&#064;localhost <\/li>\n<\/ul>\n<h5>\u4f7f\u7528\u952e\u503c\u5bf9\u8fdb\u884c\u8fde\u63a5<\/h5>\n<p>\u5728MySQLShell\u548c\u4e00\u4e9b\u5b9e\u73b0X DevAPI\u7684MySQL\u8fde\u63a5\u5668\u4e2d&#xff0c;\u60a8\u53ef\u4ee5\u4f7f\u7528\u952e\u503c\u5bf9\u6765\u6307\u5b9a\u5230MySQLServer\u7684\u8fde\u63a5&#xff0c;\u8fd9\u4e9b\u952e\u503c\u5bf9\u662f\u4e3a\u5b9e\u73b0\u63d0\u4f9b\u7684\u8bed\u8a00\u81ea\u7136\u7ed3\u6784\u3002\u4f8b\u5982&#xff0c;\u60a8\u53ef\u4ee5\u4f7f\u7528\u952e\u503c\u5bf9\u4f5c\u4e3aJavaScript\u4e2d\u7684JSON\u5bf9\u8c61\u6216Python\u4e2d\u7684\u5b57\u5178\u6765\u63d0\u4f9b\u8fde\u63a5\u53c2\u6570\u3002\u65e0\u8bba\u952e\u503c\u5bf9\u7684\u63d0\u4f9b\u65b9\u5f0f\u5982\u4f55&#xff0c;\u6982\u5ff5\u90fd\u4fdd\u6301\u4e0d\u53d8&#xff1a;\u53ef\u4ee5\u4e3a\u672c\u8282\u4e2d\u63cf\u8ff0\u7684\u952e\u5206\u914d\u7528\u4e8e\u6307\u5b9a\u8fde\u63a5\u7684\u503c\u3002\u60a8\u53ef\u4ee5\u4f7f\u7528MySQLShell\u7684shell. connect&#xff08;&#xff09;\u65b9\u6cd5\u6216InnoDB\u7c07\u7684dba.createCluster&#xff08;&#xff09;\u65b9\u6cd5\u4e2d\u7684\u952e\u503c\u5bf9\u6765\u6307\u5b9a\u8fde\u63a5&#xff0c;\u4e5f\u53ef\u4ee5\u4f7f\u7528\u4e00\u4e9b\u5b9e\u73b0X DevAPI\u7684MySQL\u8fde\u63a5\u5668\u6765\u6307\u5b9a\u8fde\u63a5\u3002<\/p>\n<p>\u901a\u5e38&#xff0c;\u952e\u503c\u5bf9\u7531{\u548c}\u5b57\u7b26\u5305\u56f4&#xff0c;\u5b57\u7b26\u7528\u4f5c\u952e\u503c\u5bf9\u4e4b\u95f4\u7684\u5206\u9694\u7b26\u3002&#xff1a;\u5b57\u7b26\u7528\u4e8e\u952e\u548c\u503c\u4e4b\u95f4&#xff0c;\u5b57\u7b26\u4e32\u5fc5\u987b\u5206\u9694&#xff08;\u4f8b\u5982&#xff0c;\u4f7f\u7528&#039;\u5b57\u7b26&#xff09;\u3002\u4e0e\u7c7b\u4f3cURI\u7684\u8fde\u63a5\u5b57\u7b26\u4e32\u4e0d\u540c&#xff0c;\u4e0d\u9700\u8981\u767e\u5206\u6bd4\u7f16\u7801\u5b57\u7b26\u4e32\u3002<\/p>\n<p>\u6307\u5b9a\u4e3a\u952e\u503c\u5bf9\u7684\u8fde\u63a5\u5177\u6709\u4ee5\u4e0b\u683c\u5f0f&#xff1a;<\/p>\n<p>{ key: value, key: value, &#8230;} <\/p>\n<p>\u53ef\u4ee5\u7528\u4f5c\u8fde\u63a5\u952e\u7684\u53c2\u6570\u5728\u57fa\u672c\u8fde\u63a5\u53c2\u6570\u4e2d\u8fdb\u884c\u4e86\u63cf\u8ff0\u3002<\/p>\n<p>\u5982\u679c\u952e\u503c\u5bf9\u4e2d\u672a\u6307\u5b9a\u5bc6\u7801&#xff08;\u5efa\u8bae\u8fd9\u6837\u505a&#xff09;&#xff0c;\u5219\u4ea4\u4e92\u5f0f\u5ba2\u6237\u7aef\u4f1a\u63d0\u793a\u8f93\u5165\u5bc6\u7801\u3002\u4ee5\u4e0b\u793a\u4f8b\u663e\u793a\u5982\u4f55\u4f7f\u7528\u7528\u6237\u540d\u201cuser_name\u201d\u7684\u952e\u503c\u5bf9\u6307\u5b9a\u8fde\u63a5\u3002\u5728\u6bcf\u79cd\u60c5\u51b5\u4e0b&#xff0c;\u90fd\u4f1a\u63d0\u793a\u8f93\u5165\u5bc6\u7801\u3002<\/p>\n<ul>\n<li>\n<p>\u4e0e\u4fa6\u542c\u7aef\u53e333065\u7684\u672c\u5730\u670d\u52a1\u5668\u5b9e\u4f8b\u7684X\u534f\u8bae\u8fde\u63a5\u3002<\/p>\n<p> {user:&#039;user_name&#039;, host:&#039;localhost&#039;, port:33065} <\/p>\n<\/li>\n<li>\n<p>\u4e0e\u4fa6\u542c\u7aef\u53e33333\u7684\u672c\u5730\u670d\u52a1\u5668\u5b9e\u4f8b\u7684\u7ecf\u5178MySQL\u534f\u8bae\u8fde\u63a5\u3002<\/p>\n<p> {user:&#039;user_name&#039;, host:&#039;localhost&#039;, port:3333} <\/p>\n<\/li>\n<li>\n<p>\u4f7f\u7528\u4e3b\u673a\u540d\u3001IPv4\u5730\u5740\u548cIPv6\u5730\u5740\u4e0e\u8fdc\u7a0b\u670d\u52a1\u5668\u5b9e\u4f8b\u7684X\u534f\u8bae\u8fde\u63a5\u3002<\/p>\n<p> {user:&#039;user_name&#039;, host:&#039;server.example.com&#039;}<br \/>\n{user:&#039;user_name&#039;, host:198.51.100.14:123}<br \/>\n{user:&#039;user_name&#039;, host:[2001:db8:85a3:8d3:1319:8a2e:370:7348]} <\/p>\n<\/li>\n<li>\n<p>\u4f7f\u7528\u5957\u63a5\u5b57\u7684X\u534f\u8bae\u8fde\u63a5\u3002<\/p>\n<p> {user:&#039;user_name&#039;, socket:&#039;\/path\/to\/socket\/file&#039;} <\/p>\n<\/li>\n<li>\n<p>\u53ef\u4ee5\u6307\u5b9a\u4e00\u4e2a\u53ef\u9009\u7684schema&#xff0c;\u5b83\u4ee3\u8868\u4e00\u4e2a\u6570\u636e\u5e93\u3002<\/p>\n<p> {user:&#039;user_name&#039;, host:&#039;localhost&#039;, schema:&#039;world&#039;} <\/p>\n<\/li>\n<\/ul>\n<p>\u524d\u9762\u7684\u793a\u4f8b\u5047\u5b9a\u8fde\u63a5\u9700\u8981\u5bc6\u7801\u3002\u5bf9\u4e8e\u4ea4\u4e92\u5f0f\u5ba2\u6237\u7aef&#xff0c;\u5728\u767b\u5f55\u63d0\u793a\u65f6\u8bf7\u6c42\u6307\u5b9a\u7528\u6237\u7684\u5bc6\u7801\u3002\u5982\u679c\u7528\u6237\u5e10\u6237\u6ca1\u6709\u5bc6\u7801&#xff08;\u8fd9\u662f\u4e0d\u5b89\u5168\u7684&#xff0c;\u4e0d\u63a8\u8350\u4f7f\u7528&#xff09;&#xff0c;\u6216\u8005\u4f7f\u7528\u5957\u63a5\u5b57\u5bf9\u7b49\u51ed\u636e\u9274\u6743&#xff08;\u4f8b\u5982&#xff0c;Unix\u5957\u63a5\u5b57\u8fde\u63a5&#xff09;&#xff0c;\u5219\u5fc5\u987b\u660e\u786e\u6307\u5b9a\u4e0d\u63d0\u4f9b\u5bc6\u7801&#xff0c;\u4e5f\u4e0d\u9700\u8981\u5bc6\u7801\u63d0\u793a\u3002\u4e3a\u6b64&#xff0c;\u8bf7\u5728password\u952e\u540e\u4f7f\u7528&#039;&#039;\u63d0\u4f9b\u7a7a\u5b57\u7b26\u4e32\u3002\u4f8b\u5982&#xff1a;<\/p>\n<p>{user:&#039;user_name&#039;, password:&#039;&#039;, host:&#039;localhost&#039;} <\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb1.3k\u6b21\uff0c\u70b9\u8d5e12\u6b21\uff0c\u6536\u85cf23\u6b21\u3002\u672c\u8282\u4ecb\u7ecd\u4f7f\u7528\u7c7b\u4f3cURI\u7684\u8fde\u63a5\u5b57\u7b26\u4e32\u6216\u952e\u503c\u5bf9\u6765\u6307\u5b9a\u5982\u4f55\u4e3aMySQLShell\u7b49\u5ba2\u6237\u7aef\u5efa\u7acb\u5230MySQL\u670d\u52a1\u5668\u7684\u8fde\u63a5\u3002\u8fde\u63a5\u53c2\u6570\u4e0d\u533a\u5206\u5927\u5c0f\u5199\u3002\u5982\u679c\u6307\u5b9a\uff0c\u6bcf\u4e2a\u53c2\u6570\u53ea\u80fd\u7ed9\u51fa\u4e00\u6b21\u3002\u5982\u679c\u4e00\u4e2a\u53c2\u6570\u88ab\u6307\u5b9a\u591a\u6b21\uff0c\u5219\u4f1a\u53d1\u751f\u9519\u8bef\u3002_mysql uri<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[114],"topic":[],"class_list":["post-18191","post","type-post","status-publish","format-standard","hentry","category-server","tag-mysql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>MySQL\u7a0b\u5e8f\u4e4b\uff1a\u4f7f\u7528\u7c7b\u4f3cURI\u7684\u5b57\u7b26\u4e32\u6216\u952e\u503c\u5bf9\u8fde\u63a5\u5230\u670d\u52a1\u5668 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wsisp.com\/helps\/18191.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL\u7a0b\u5e8f\u4e4b\uff1a\u4f7f\u7528\u7c7b\u4f3cURI\u7684\u5b57\u7b26\u4e32\u6216\u952e\u503c\u5bf9\u8fde\u63a5\u5230\u670d\u52a1\u5668 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb1.3k\u6b21\uff0c\u70b9\u8d5e12\u6b21\uff0c\u6536\u85cf23\u6b21\u3002\u672c\u8282\u4ecb\u7ecd\u4f7f\u7528\u7c7b\u4f3cURI\u7684\u8fde\u63a5\u5b57\u7b26\u4e32\u6216\u952e\u503c\u5bf9\u6765\u6307\u5b9a\u5982\u4f55\u4e3aMySQLShell\u7b49\u5ba2\u6237\u7aef\u5efa\u7acb\u5230MySQL\u670d\u52a1\u5668\u7684\u8fde\u63a5\u3002\u8fde\u63a5\u53c2\u6570\u4e0d\u533a\u5206\u5927\u5c0f\u5199\u3002\u5982\u679c\u6307\u5b9a\uff0c\u6bcf\u4e2a\u53c2\u6570\u53ea\u80fd\u7ed9\u51fa\u4e00\u6b21\u3002\u5982\u679c\u4e00\u4e2a\u53c2\u6570\u88ab\u6307\u5b9a\u591a\u6b21\uff0c\u5219\u4f1a\u53d1\u751f\u9519\u8bef\u3002_mysql uri\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/18191.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2025-04-18T16:38:32+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/18191.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/18191.html\",\"name\":\"MySQL\u7a0b\u5e8f\u4e4b\uff1a\u4f7f\u7528\u7c7b\u4f3cURI\u7684\u5b57\u7b26\u4e32\u6216\u952e\u503c\u5bf9\u8fde\u63a5\u5230\u670d\u52a1\u5668 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2025-04-18T16:38:32+00:00\",\"dateModified\":\"2025-04-18T16:38:32+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/18191.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/18191.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/18191.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL\u7a0b\u5e8f\u4e4b\uff1a\u4f7f\u7528\u7c7b\u4f3cURI\u7684\u5b57\u7b26\u4e32\u6216\u952e\u503c\u5bf9\u8fde\u63a5\u5230\u670d\u52a1\u5668\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\",\"url\":\"https:\/\/www.wsisp.com\/helps\/\",\"name\":\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"description\":\"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"contentUrl\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"caption\":\"admin\"},\"sameAs\":[\"http:\/\/wp.wsisp.com\"],\"url\":\"https:\/\/www.wsisp.com\/helps\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MySQL\u7a0b\u5e8f\u4e4b\uff1a\u4f7f\u7528\u7c7b\u4f3cURI\u7684\u5b57\u7b26\u4e32\u6216\u952e\u503c\u5bf9\u8fde\u63a5\u5230\u670d\u52a1\u5668 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wsisp.com\/helps\/18191.html","og_locale":"zh_CN","og_type":"article","og_title":"MySQL\u7a0b\u5e8f\u4e4b\uff1a\u4f7f\u7528\u7c7b\u4f3cURI\u7684\u5b57\u7b26\u4e32\u6216\u952e\u503c\u5bf9\u8fde\u63a5\u5230\u670d\u52a1\u5668 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb1.3k\u6b21\uff0c\u70b9\u8d5e12\u6b21\uff0c\u6536\u85cf23\u6b21\u3002\u672c\u8282\u4ecb\u7ecd\u4f7f\u7528\u7c7b\u4f3cURI\u7684\u8fde\u63a5\u5b57\u7b26\u4e32\u6216\u952e\u503c\u5bf9\u6765\u6307\u5b9a\u5982\u4f55\u4e3aMySQLShell\u7b49\u5ba2\u6237\u7aef\u5efa\u7acb\u5230MySQL\u670d\u52a1\u5668\u7684\u8fde\u63a5\u3002\u8fde\u63a5\u53c2\u6570\u4e0d\u533a\u5206\u5927\u5c0f\u5199\u3002\u5982\u679c\u6307\u5b9a\uff0c\u6bcf\u4e2a\u53c2\u6570\u53ea\u80fd\u7ed9\u51fa\u4e00\u6b21\u3002\u5982\u679c\u4e00\u4e2a\u53c2\u6570\u88ab\u6307\u5b9a\u591a\u6b21\uff0c\u5219\u4f1a\u53d1\u751f\u9519\u8bef\u3002_mysql uri","og_url":"https:\/\/www.wsisp.com\/helps\/18191.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2025-04-18T16:38:32+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"5 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wsisp.com\/helps\/18191.html","url":"https:\/\/www.wsisp.com\/helps\/18191.html","name":"MySQL\u7a0b\u5e8f\u4e4b\uff1a\u4f7f\u7528\u7c7b\u4f3cURI\u7684\u5b57\u7b26\u4e32\u6216\u952e\u503c\u5bf9\u8fde\u63a5\u5230\u670d\u52a1\u5668 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2025-04-18T16:38:32+00:00","dateModified":"2025-04-18T16:38:32+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/18191.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/18191.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/18191.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"MySQL\u7a0b\u5e8f\u4e4b\uff1a\u4f7f\u7528\u7c7b\u4f3cURI\u7684\u5b57\u7b26\u4e32\u6216\u952e\u503c\u5bf9\u8fde\u63a5\u5230\u670d\u52a1\u5668"}]},{"@type":"WebSite","@id":"https:\/\/www.wsisp.com\/helps\/#website","url":"https:\/\/www.wsisp.com\/helps\/","name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","description":"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41","name":"admin","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/","url":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","contentUrl":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","caption":"admin"},"sameAs":["http:\/\/wp.wsisp.com"],"url":"https:\/\/www.wsisp.com\/helps\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/18191","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/comments?post=18191"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/18191\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=18191"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=18191"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=18191"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=18191"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}