用CURL检查MySQL端口是否开放

可以使用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端口是否开放。