mysql: [MY-010055] [Server] IP address ‘10.237.0.196‘ could not be resolved

时间:2025-04-10 08:38:07

问题: [Warning] [MY-010055] [Server] IP address ‘10.237.0.196’ could not be resolved: Temporary failure in name resolution

原因:mysql对连接的客户端进行DNS反向解析

解决方法:

1、在/etc/hosts中添加客户端对应的主机名

2、在mysql的配置文件中添加禁用dns解析的参数: skip-name-resolve
vim /etc/
在[mysqld]的段中加上一句:skip-name-resolve

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/
skip-name-resolve

重启mysql即可。

此处采用第二种方案。