# 入侵防范

<span style="color: rgb(224, 62, 45);">**<span style="font-family: 宋体;">测评项：</span><span style="mso-list: Ignore;">a) </span><span style="font-family: 宋体;">应遵循最小安装的原则，仅安装需要的组件和应用程序</span><span style="font-family: 宋体;">。</span>**</span>

**<span style="font-family: 宋体;">测评点：多余插件</span>**

<span style="font-family: 宋体;">**核查命令：**</span>

```pl/sql
show plugins;
```

**<span style="font-family: 宋体;">预期结果:</span>**

 [![image.png](https://document.nat.ac.cn/uploads/images/gallery/2025-07/scaled-1680-/OFfimage.png)](https://document.nat.ac.cn/uploads/images/gallery/2025-07/OFfimage.png)

<span style="color: rgb(224, 62, 45);">**<span style="font-family: 宋体;">测评项：</span><span style="mso-list: Ignore;">b) </span><span style="font-family: 宋体;">应通过设定终端接入方式或网络地址范围对通过网络进行管理的管理终端进行限制。</span>**</span>

**<span style="font-family: 宋体;">测评方法</span>**

<span style="mso-list: Ignore;">（1）</span><span style="font-family: 宋体;">执行</span><span style="font-family: 宋体;">“</span><span style="font-family: Times New Roman;">show grants for root@localhost</span><span style="font-family: 宋体;">”命令，查看用户登录的</span><span style="font-family: Times New Roman;">IP</span><span style="font-family: 宋体;">地址，核查是否给所有用户加上了</span><span style="font-family: Times New Roman;">IP</span><span style="font-family: 宋体;">地址限制以拒绝所有未知主机的连接。</span>

<span style="color: rgb(35, 111, 161);"><span style="font-family: 宋体;">注意：当</span><span style="font-family: Times New Roman;">user</span><span style="font-family: 宋体;">表中的</span><span style="font-family: Times New Roman;">Host</span><span style="font-family: 宋体;">值不在本地主机</span><span style="font-family: Times New Roman;">IP</span><span style="font-family: 宋体;">地址范围内时，应为其指定</span><span style="font-family: Times New Roman;">IP</span><span style="font-family: 宋体;">地址，使其不为“</span><span style="font-family: Times New Roman;">%</span><span style="font-family: 宋体;">”，或者将</span><span style="font-family: Times New Roman;">user</span><span style="font-family: 宋体;">表中的</span><span style="font-family: Times New Roman;">Host</span><span style="font-family: 宋体;">值置为空。在</span><span style="font-family: Times New Roman;">host</span><span style="font-family: 宋体;">表中指定允许用户账户登录访问的若干主机。在非信任的客户端以数据库账户登录的行为应被拒绝。用户从其他子网登录的行为也应被拒绝。</span></span>

**<span style="font-family: 宋体;">操作步骤</span>&amp;<span style="font-family: 宋体;">预期结果</span>**

<span style="mso-list: Ignore;">（1）</span><span style="font-family: 宋体;">已在防火墙上限制特定的终端（</span><span style="font-family: Times New Roman;">IP</span><span style="font-family: 宋体;">地址）连接（访问）数据库。</span>

[![image.png](https://document.nat.ac.cn/uploads/images/gallery/2025-07/scaled-1680-/uBZimage.png)](https://document.nat.ac.cn/uploads/images/gallery/2025-07/uBZimage.png)

 <span style="color: rgb(224, 62, 45);">**<span style="font-family: 宋体;">测评项：</span><span style="mso-list: Ignore;">c) </span><span style="font-family: 宋体;">应</span><span style="font-family: 宋体;">能发现可能存在的已知漏洞，并在经过充分测试评估后，及时修补漏洞。</span>**</span>

**<span style="font-family: 宋体;">测评方法</span>**

<span style="mso-list: Ignore;">（1）</span><span style="font-family: 宋体;">了解</span><span style="font-family: Times New Roman;">MySQL</span><span style="font-family: 宋体;">数据库的补丁升级机制，查看补丁安装情况。执行“</span><span style="font-family: Times New Roman;">show variables where variable\_name like </span><span style="font-family: Times New Roman;">“</span><span style="font-family: Times New Roman;">version</span><span style="font-family: Times New Roman;">”</span><span style="font-family: 宋体;">”命令查看当前补丁版本。</span>

<span style="mso-list: Ignore;">（2）</span><span style="font-family: 宋体;">核查数据库的版本是否为企业版，是否定期进行漏洞扫描，是否针对高风险漏洞安装了经过评估和测试的补丁。</span>

**<span style="font-family: 宋体;">操作步骤</span>&amp;<span style="font-family: 宋体;">预期结果</span>**

<span style="mso-list: Ignore;">（1）</span><span style="font-family: Times New Roman;">MySQL</span><span style="font-family: 宋体;">数据库目前并不存在高风险漏洞，补丁更新及时。</span>

[![image.png](https://document.nat.ac.cn/uploads/images/gallery/2025-07/scaled-1680-/eaeimage.png)](https://document.nat.ac.cn/uploads/images/gallery/2025-07/eaeimage.png)

<span style="mso-list: Ignore;">（2）</span><span style="font-family: Times New Roman;">MySQL</span><span style="font-family: 宋体;">数据库为企业版，定期进行漏洞扫描。对发现的数据库漏洞，已在测试和评估后进行修补。</span>