mysql⾃动停⽌服务_MySQL数据库之mysql⾃动停⽌的完美解
决⽅法mysql下载starting the server
本⽂主要向⼤家介绍了MySQL数据库之mysql⾃动停⽌的完美解决⽅法 ，通过具体的内容向⼤家展现，希望对⼤家学习MySQL数据库有所帮助。
这两天新买的服务器mysql总是⾃动停⽌，查了⽇志
9:13:57 [Note] MySQL: Normal shutdown
9:13:57 [Note] Event : Purging the queue. 0 events
9:13:57  InnoDB:
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
⽹上到的⽅法
在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
解决
本⽂由职坐标整理并发布，希望对同学们学习MySQL有所帮助，更多内容请关注职坐标数据库MySQL数据库频道！

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。