Forcing close of thread

最近linux上安装的mysql遭遇自动关闭

[Warning] /usr/local/mysql/bin/mysqld: Forcing close of thread 29  user: 'root'
[Warning] /usr/local/mysql/bin/mysqld: Forcing close of thread 31  user: 'root'
[Warning] /usr/local/mysql/bin/mysqld: Forcing close of thread 24  user: 'root'

解决办法：
在mysql配置文件my.cnf添加skip-name-resolve

[mysqld]
skip-name-resolve

然后重启mysql即可。

顺便插一句，重启过后可能出现连锁反应，导致应用服务连接错误。

message from server: "Host '127.0.0.1' is not allowed to connect to this MySQL server"

修改mysql中mysql.user表

mysql> select user,host from user;
+---------------+-----------+
| user          | host      |
+---------------+-----------+
| root          | localhost |
| mysql.session | localhost |
| mysql.sys     | localhost |
+---------------+-----------+

将host从localhost修改为’127.0.0.1’或者’%’，

mysql> select user,host from user;
+---------------+-----------+
| user          | host      |
+---------------+-----------+
| root          | % 		|
| mysql.session | localhost |
| mysql.sys     | localhost |
+---------------+-----------+

数据库连接恢复正常。

---

补充：
mysql自动关闭的原因有很多，比如客户端关闭、系统脚本执行、人为kill等等，要从各个角度追溯关闭的源头。