可以使用CURL命令结合MySQL的连接字符串来检查MySQL端口是否开放。具体操作如下：，，1. 打开终端或命令提示符。，2. 输入以下命令：，，“
bash，curl -v --http1.1 "http://目标IP地址：端口号/"，`，，将"目标IP地址"替换为实际的MySQL服务器IP地址，将"端口号"替换为实际的MySQL端口号（默认为3306）。，，3. 如果端口开放，你将看到类似于以下的输出：，，`bash，* Rebuilt URL to: http://目标IP地址：端口号/，* Connection state changed (IHLAST, keepalive (fd=3))!，`，，如果端口未开放，你将看到类似于以下的输出：，，`bash，* Rebuilt URL to: http://目标IP地址：端口号/，* Connection state changed (IHLAST, keepalive (fd=3))!，* TCP_NODELAY set，* Connected to 目标IP地址 (目标IP地址) port 端口号 (#0)，* GET / HTTP/1.1，* Host: 目标IP地址：端口号，* User-Agent: curl/7.64.1，* Accept: */*，* Empty reply from server，* Connection #0 to host 目标IP地址 left intact，curl: (56) Empty reply from server，“，，在这种情况下，端口可能未开放或MySQL服务未运行。请检查MySQL服务器的配置和状态。要使用CURL检查MySQL端口是否开放，可以按照以下步骤操作：
1、打开命令行终端（Windows下为cmd，Linux和Mac下为Terminal）。
2、输入以下命令，将your_mysql_host替换为你的MySQL服务器地址，将your_username替换为你的MySQL用户名，将your_password替换为你的MySQL密码，将3306替换为你的MySQL端口号（如果不同的话）：
curl v http1.1 "http://your_mysql_host:3306/" user your_username:your_password
3、观察输出结果，如果端口开放，你将看到类似以下的输出：
Rebuilt URL to: http://your_mysql_host:3306/ Trying your_mysql_host... TCP_NODELAY set Connected to your_mysql_host (your_mysql_host) port 3306 (#0) > GET / HTTP/1.1 > Host: your_mysql_host:3306 > UserAgent: curl/7.64.1 > Accept: */* > Authorization: Basic your_base64_encoded_username_and_password > < HTTP/1.1 401 Unauthorized < Server: nginx/1.14.0 (Ubuntu) < Date: Wed, 09 Jun 2021 08:23:41 GMT < ContentType: text/html; charset=UTF8 < ContentLength: 202 < Connection: keepalive < WWWAuthenticate: Basic realm="Restricted" < XContentTypeOptions: nosniff < XXSSProtection: 1; mode=block < XFrameOptions: SAMEORIGIN < ETag: W/"1424B5AOg" < CacheControl: maxage=0, mustrevalidate, nocache, nostore < XRequestId: f9a7e8f8f9a7e8f8f9a7e8f8f9a7e8f8f9a7e8f8f9a7e8f8f9a7e8f8f9a7e8f8f9a7e8f8f9a7e8f8f9a7e8f8f9a7e8f8f9a7e8f8f9a7e8f8f9a7e8f8f9a7e8f8f9a7e8f8f9a7e8f8 < XRuntime: 0.000000 < XPoweredBy: PHP 7.2.240ubuntu0.16.04.1 < Ignoring the responsebody Connection #0 to host your_mysql_host left intact
4、如果端口未开放，你将看到类似以下的输出：
Rebuilt URL to: http://your_mysql_host:3306/ Trying your_mysql_host... TCP_NODELAY set connect to your_mysql_host port 3306 failed: Connection refused Failed to connect to your_mysql_host port 3306: Connection refused Closing connection 0
通过观察输出结果，你可以判断MySQL端口是否开放。
原创文章，作者：未希，如若转载，请注明出处：https://www.kdun.com/ask/520995.html
微信扫一扫