mysql mcp使用与抓包测试

670 字

3 分钟

mysql mcp使用与抓包测试

2025-10-29

编程

MySQL

/

编程

/

MCP

环境配置#

使用docker开启mysql非常方便

首先开启一个mysql server

1
docker run -itd --name mysql_server -p3306:3306 --rm   -e MYSQL_ROOT_PASSWORD=123456 mysql

然后开启mysql client再通过 —link 连接到mysql server

1
docker run -it --rm  --name mysql_client  --link mysql_server:mysql_server mysql mysql -hmysql_server -uroot -p

--link mysql_server:mysql_server 这会把名为 mysql_server 的容器的 IP 地址映射到 mysql_server 这个主机名，第二个容器（mysql_client）可以通过该主机名访问第一个容器的 MySQL 服务。

mcp工具选择：https://github.com/wenb1n-dev/mysql_mcp_server_pro

启动：

1
# clone仓库
2
git clone https://github.com/wenb1n-dev/mysql_mcp_server_pro
3

4
#同步依赖
5
uv sync
6

7
# 指定.env启动，神奇的是这里必须绝对路径
8
uv run -m mysql_mcp_server_pro.server --envfile /Users/rayepeng/Documents/code/ida-mcp-reverse/WeChatMiniGame_WebInstaller/.env

.env 文件内容

1
# MySQL Database Configuration
2
MYSQL_HOST=127.0.0.1
3
MYSQL_PORT=3306
4
MYSQL_USER=root
5
MYSQL_PASSWORD=123456
6
MYSQL_DATABASE=information_schema
7
# Optional, default is 'readonly'. Available values: readonly, writer, admin
8
MYSQL_ROLE=admin

神奇的错误#

不然会遇到这个神奇的错误：

ps .env 文件放在源码目录下也是不行的？好神奇

1
❯ uv run -m mysql_mcp_server_pro.server --envfile /Users/rayepeng/Documents/code/mysql_mcp_server_pro/.env
2
Traceback (most recent call last):
3
  File "<frozen runpy>", line 198, in _run_module_as_main
4
  File "<frozen runpy>", line 88, in _run_code
5
  File "/Users/rayepeng/Documents/code/mysql_mcp_server_pro/src/mysql_mcp_server_pro/server.py", line 28, in <module>
6
    from .oauth import OAuthMiddleware, login, login_page
7
  File "/Users/rayepeng/Documents/code/mysql_mcp_server_pro/src/mysql_mcp_server_pro/oauth/__init__.py", line 1, in <module>
8
    from .config import oauth_config
9
  File "/Users/rayepeng/Documents/code/mysql_mcp_server_pro/src/mysql_mcp_server_pro/oauth/config.py", line 28, in <module>
10
    oauth_config = OAuthConfig()
11
                   ^^^^^^^^^^^^^
12
  File "/Users/rayepeng/Documents/code/mysql_mcp_server_pro/.venv/lib/python3.11/site-packages/pydantic_settings/main.py", line 193, in __init__
13
    super().__init__(
14
  File "/Users/rayepeng/Documents/code/mysql_mcp_server_pro/.venv/lib/python3.11/site-packages/pydantic/main.py", line 250, in __init__
15
    validated_self = self.__pydantic_validator__.validate_python(data, self_instance=self)
16
                     ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
17
pydantic_core._pydantic_core.ValidationError: 6 validation errors for OAuthConfig
18
MYSQL_HOST
19
  Extra inputs are not permitted [type=extra_forbidden, input_value='127.0.0.1', input_type=str]
20
    For further information visit https://errors.pydantic.dev/2.12/v/extra_forbidden
21
MYSQL_PORT
22
  Extra inputs are not permitted [type=extra_forbidden, input_value='3306', input_type=str]
23
    For further information visit https://errors.pydantic.dev/2.12/v/extra_forbidden
24
MYSQL_USER
25
  Extra inputs are not permitted [type=extra_forbidden, input_value='root', input_type=str]
26
    For further information visit https://errors.pydantic.dev/2.12/v/extra_forbidden
27
MYSQL_PASSWORD
28
  Extra inputs are not permitted [type=extra_forbidden, input_value='123456', input_type=str]
29
    For further information visit https://errors.pydantic.dev/2.12/v/extra_forbidden
30
MYSQL_DATABASE
31
  Extra inputs are not permitted [type=extra_forbidden, input_value='information_schema', input_type=str]
32
    For further information visit https://errors.pydantic.dev/2.12/v/extra_forbidden
33
MYSQL_ROLE
34
  Extra inputs are not permitted [type=extra_forbidden, input_value='admin', input_type=str]
35
    For further information visit https://errors.pydantic.dev/2.12/v/extra_forbidden

使用体验#

非常方便，这样对于开发后端的web应用来说会更加方便了

抓包测试#

好奇这里是怎么实现的数据通信，抓包测试下

最简单的抓包就是转发本地端口

1
socat -v -x TCP-LISTEN:8081,fork TCP:localhost:3000

这是把本地的8081端口转发到3000，记得修改下mcp.json里的配置(因为这个mcp用的是HTTP streamable通信)

1
"mysql_mcp_server_pro": {
2
  "name": "mysql_mcp_server_pro",
3
  "type": "streamableHttp",
4
  "description": "",
5
  "isActive": true,
6
  "url": "http://localhost:8081/mcp/"
7
},