\u914d\u7f6e nssm \u670d\u52a1\uff0c\u4ee5\u7ba1\u7406\u5458\u8fd0\u884c\u547d\u4ee4\u884c\uff0c\u8f93\u5165\uff1a<\/p>\n\n\n\n
nssm install MySQLReverseTunnel<\/code><\/pre><\/div>\n\n\n\n\u5728\u5f39\u51fa\u7684\u7a97\u53e3\u4e2d\u8bbe\u7f6e\uff1a<\/p>\n\n\n\n
\n
\n- Path\uff1aplink.exe \u8def\u5f84<\/li>\n\n\n\n
- Arguments\uff1a
-ssh ubuntu@1.2.3.4 -i C:\\path\\to\\your_key.ppk -N -batch -R 23456:127.0.0.1:3306<\/code><\/li>\n\n\n\n- \u5728”Log on” \u6807\u7b7e\u9875\u52fe\u9009 \u201cThis account\u201d\uff0c\u8bbe\u7f6e\u4e3a\u4f60\u5f53\u524d\u7684 Windows \u7528\u6237\uff08\u6bd4\u5982
.\\yourusername<\/code>\uff09\uff0c\u586b\u5165\u5f53\u524d\u7528\u6237\u5bc6\u7801\u3002<\/li>\n<\/ul>\n\n\n\n\u8bbe\u7f6e\u5b8c\u6210\u540e\uff0c\u5728\u547d\u4ee4\u884c\u4e2d\u8f93\u5165\u4ee5\u4e0b\u547d\u4ee4\uff0c\u9632\u6b62\u9891\u7e41\u5931\u8d25\u5bfc\u81f4 nssm \u505c\u6b62\uff1a<\/p>\n\n\n\n
nssm set MySQLReverseTunnel AppThrottle 5000<\/code><\/pre><\/div>\n<\/div><\/div>\n\n\n\n\u5b8c\u6210\u540e\uff0c\u53ef\u4ee5\u4f7f\u7528\u4ee5\u4e0b\u547d\u4ee4\u63a7\u5236 MySQL \u53cd\u5411\u4ee3\u7406\u670d\u52a1\u7684\u542f\u52a8\u548c\u505c\u6b62\uff1a<\/p>\n\n\n\n
nssm start MySQLReverseTunnel<\/code><\/pre><\/div>\n\n\n\nnssm stop MySQLReverseTunnel<\/code><\/pre><\/div>\n\n\n\n\u63a5\u4e0b\u6765\uff0c\u521b\u5efa\u4e00\u4e2a\u811a\u672c check_tunnel.ps1<\/code> \u5b9a\u65f6\u68c0\u6d4b SSH \u8fde\u63a5\u662f\u5426\u6389\u7ebf\uff0c\u5728\u6389\u7ebf\u65f6\u81ea\u52a8\u91cd\u542f\u670d\u52a1\uff1a<\/p>\n\n\n\n# \u5f3a\u5236\u4f7f\u7528ANSI\u7f16\u7801\u4fdd\u5b58\u6b64\u6587\u4ef6\uff08PowerShell 5.1\u5bf9UTF-8 BOM\u654f\u611f\uff09\n$remoteHost = "1.2.3.4"\n$remotePort = 23456\n$serviceName = "MySQLReverseTunnel"\n$logPath = "<Your-Log-Path>.log"\n\nfunction Log {\n param ([string]$msg)\n $timestamp = Get-Date -Format "yyyy-MM-dd HH:mm:ss"\n $logDir = Split-Path -Path $logPath -Parent\n if (-not (Test-Path -Path $logDir -PathType Container)) {\n New-Item -ItemType Directory -Path $logDir -Force | Out-Null\n }\n Add-Content -Path $logPath -Value "[$timestamp] $msg" -Encoding UTF8\n}\n\ntry {\n $tcp = New-Object System.Net.Sockets.TcpClient\n $connectResult = $tcp.BeginConnect($remoteHost, $remotePort, $null, $null)\n $waitResult = $connectResult.AsyncWaitHandle.WaitOne(5000, $false) # 5\u79d2\u8d85\u65f6\n if (-not $waitResult) {\n throw "\u8fde\u63a5\u8d85\u65f6"\n }\n $tcp.EndConnect($connectResult)\n $tcp.Close()\n Log "OK \u96a7\u9053\u6b63\u5e38\uff08${remoteHost}:${remotePort}\uff09"\n}\ncatch {\n Log "ERROR \u96a7\u9053\u4e0d\u53ef\u8fbe\uff0c\u91cd\u542f\u670d\u52a1\uff1a${serviceName}\u3002\u9519\u8bef\uff1a$($_.Exception.Message)"\n & nssm restart $serviceName\n}<\/code><\/pre><\/div>\n\n\n\n\u521b\u5efa\u5b9a\u65f6\u4efb\u52a1\u811a\u672c setup_task.bat<\/code> \uff1a<\/p>\n\n\n\n@echo off\nset SCRIPT_PATH=<Your-Path-Of-check_tunnel.ps1>\nset VBS_PROXY=<Your-Path-Of-run_hidden.vbs>\n\nREM \u521b\u5efaVBScript\u4ee3\u7406\u6587\u4ef6\uff08\u7528\u4e8e\u5f7b\u5e95\u9690\u85cf\u7a97\u53e3\uff09\necho Set objShell = WScript.CreateObject("WScript.Shell") > "\necho objShell.Run "powershell.exe -ExecutionPolicy Bypass -WindowStyle Hidden -File ""\n\nREM \u5b9a\u65f6\u4efb\u52a1\u8c03\u7528VBScript\u800c\u975e\u76f4\u63a5\u8c03\u7528PowerShell\nschtasks \/create \/tn "CheckMySQLTunnel" \/sc minute \/mo 5 \/tr "wscript.exe ""\n\necho \u5b9a\u65f6\u4efb\u52a1\u521b\u5efa\u5b8c\u6210\uff08VBS\u4ee3\u7406\u65e0\u7a97\u53e3\u6a21\u5f0f\uff09\u3002\npause<\/code><\/pre><\/div>\n\n\n\n\u5176\u4e2d\uff0cset VBS_PROXY=<\/code> \u53ef\u4ee5\u586b\u5199\u4efb\u610f\u8def\u5f84\uff0c\u8fd9\u4e2a\u811a\u672c\u8fd0\u884c\u65f6\u4f1a\u5728\u4f60\u586b\u5199\u7684\u4f4d\u7f6e\u751f\u6210\u4e00\u4e2a .vbs<\/code> \u6587\u4ef6\u3002<\/p>\n\n\n\n\u4fdd\u5b58\u540e\uff0c\u8fd0\u884c setup_task.bat<\/code> \uff0cWindows \u7cfb\u7edf\u4e2d\u4f1a\u521b\u5efa\u5b9a\u65f6\u68c0\u6d4b\u662f\u5426\u6389\u7ebf\u7684\u5b9a\u65f6\u4efb\u52a1\uff0c\u5982\u679c\u6389\u7ebf\u7684\u8bdd\u4f1a\u81ea\u52a8\u91cd\u542f MySQLReverseTunnel<\/code> \u670d\u52a1\u3002\u5e76\u4e14\u4f1a\u5728\u8bbe\u7f6e\u7684\u8def\u5f84\u751f\u6210 .log<\/code> \u6587\u4ef6\uff0c\u5b9a\u671f\u8bb0\u5f55\u68c0\u6d4b\u7ed3\u679c\u3002<\/p>\n\n\n\n\u4e4b\u540e\uff0c\u5982\u679c\u60f3\u8981\u542f\u52a8\u548c\u505c\u6b62 SSH \u53cd\u5411\u4ee3\u7406 + \u5b9a\u65f6\u68c0\u67e5\u53ef\u4ee5\u7528\u4e0b\u9762\u4e24\u4e2a\u811a\u672c\uff1a<\/p>\n\n\n\n
@echo off\necho === \u542f\u52a8 MySQL \u53cd\u5411 SSH \u4ee3\u7406 ===\n\necho [1] \u542f\u52a8\u670d\u52a1 MySQLReverseTunnel...\nnssm start MySQLReverseTunnel\n\necho [2] \u542f\u7528\u5b9a\u65f6\u4efb\u52a1 CheckMySQLTunnel...\nschtasks \/change \/tn "CheckMySQLTunnel" \/enable\n\necho \u542f\u52a8\u5b8c\u6210\u3002\npause<\/code><\/pre><\/div>\n\n\n\n@echo off\necho === \u505c\u6b62 MySQL \u53cd\u5411 SSH \u4ee3\u7406 ===\n\necho [1] \u505c\u6b62\u670d\u52a1 MySQLReverseTunnel...\nnssm stop MySQLReverseTunnel\n\necho [2] \u6682\u505c\u5b9a\u65f6\u4efb\u52a1 CheckMySQLTunnel...\nschtasks \/change \/tn "CheckMySQLTunnel" \/disable\n\necho \u505c\u6b62\u5b8c\u6210\u3002\npause<\/code><\/pre><\/div>\n\n\n\n\u4e94\u3001\u56fe\u5f62\u754c\u9762\u5de5\u5177<\/h2>\n\n\n\n
\u4ee5\u4e0a\u5185\u5bb9\u5df2\u7ecf\u53ef\u4ee5\u5b9e\u73b0MySQL\u7684\u53cd\u5411SSH\u4ee3\u7406\u3001\u5b9a\u65f6\u68c0\u6d4b\u548c\u81ea\u52a8\u91cd\u542f\u529f\u80fd\u3002\u5982\u679c\u60f3\u8981\u66f4\u52a0\u76f4\u89c2\u7684\u8bdd\uff0c\u53ef\u4ee5\u4f7f\u7528 Python \u7684 PySide6 \u7b49\u5e93\u521b\u5efa\u56fe\u5f62\u754c\u9762\u5de5\u5177\uff0c\u7ba1\u7406 MySQL \u7684\u4e91\u8f6c\u53d1\u3001\u67e5\u770b\u65e5\u5fd7\u7b49\u3002<\/p>\n\n\n\n \n","protected":false},"excerpt":{"rendered":"
\u672c\u65b9\u6848\u901a\u8fc7\u53cd\u5411 SSH \u96a7\u9053\uff08Reverse SSH Tunnel\uff09\u5c06 Windows \u5e73\u53f0\u672c\u5730 MySQL … \u7ee7\u7eed\u9605\u8bfb\u201cWindows\u5e73\u53f0MySQL\u57fa\u4e8e\u53cd\u5411SSH\u7684\u4e91\u7aef\u8f6c\u53d1\u201d<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[38,7],"tags":[39,40],"class_list":["post-350","post","type-post","status-publish","format-standard","hentry","category-ssh","category-7","tag-mysql","tag-ssh"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.vincedeck.top\/index.php?rest_route=\/wp\/v2\/posts\/350","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vincedeck.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.vincedeck.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.vincedeck.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vincedeck.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=350"}],"version-history":[{"count":10,"href":"https:\/\/www.vincedeck.top\/index.php?rest_route=\/wp\/v2\/posts\/350\/revisions"}],"predecessor-version":[{"id":360,"href":"https:\/\/www.vincedeck.top\/index.php?rest_route=\/wp\/v2\/posts\/350\/revisions\/360"}],"wp:attachment":[{"href":"https:\/\/www.vincedeck.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=350"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vincedeck.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=350"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vincedeck.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=350"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}