时间:2021-07-01 10:21:17 帮助过:31人阅读
MySQL Server无法启动错误诊断一则
mysql> select version()/G;
*************************** 1. row ***************************
version(): 5.5.16-log
1 row in set (0.00 sec)
[mysql@cdio ~]$ mysqld_safe &
[1] 3036
[mysql@cdio ~]$ 130506 19:16:34 mysqld_safe Logging to '/home/mysql/mysql/log/alert.log'.
130506 19:16:34 mysqld_safe Starting mysqld daemon with databases from /home/mysql/mysql/data
130506 19:16:36 mysqld_safe mysqld from pid file /home/mysql/mysql/data/cdio.pid ended
查看日志、发现:
130506 17:40:19 [ERROR] /home/mysql/mysql/bin/mysqld: unknown variable 'inactive_timeout=172800'
130506 17:40:19 [ERROR] Aborting
原来是inactive_timeout拼错了、该参数为interactive_timeout