这两天新买的服务器mysql总是自动停止，查了日志   9:13:57 [Note] MySQL: Normal shutdown   9:13:57 [Note] Event Scheduler: Purging the queue. 0 events   9:13:57  InnoDB: Starting shutdown...   9:13:58  InnoDB: Shutdown completed; log sequence number 0 44273   9:13:58 [Note] MySQL: Shutdown complete 重启发现   9:13:59 [Note] Plugin 'FEDERATED' is disabled.   9:13:59  InnoDB: Initializing buffer pool, size = 8.0M   9:13:59  InnoDB: Completed initialization of buffer pool   9:13:59  InnoDB: Started; log sequence number 0 44273   9:13:59 [Note] Event Scheduler: Loaded 0 events   9:13:59 [Note] MySQL: ready for connections. Version: '5.1.61-community'  socket: ''  port: 3306  MySQL Community Server (GPL)   9:14:24 [Note] MySQL: Normal shutdown [b]网上找到的方法[/b] 在MY.INI文件中的 [mysqld] 中增加一行tmpdir="D:/MySQL/data/tmp" 删除MySQL目录下的ib_logfile0和ib_logfile1 测试后没有用 后来在服务中设置了mysql自动重启 最后 [mysqld] federated 解决 启动正常  10:28:01  InnoDB: Initializing buffer pool, size = 8.0M  10:28:01  InnoDB: Completed initialization of buffer pool  10:28:01  InnoDB: Started; log sequence number 0 44556  10:28:01 [Note] Event Scheduler: Loaded 0 events  10:28:01 [Note] MySQL: ready for connections. Version: '5.1.61-community'  socket: ''  port: 3306  MySQL Community Server (GPL) 顺手添加 skip-external-locking skip-name-resolve 解决