centos虚拟机直接关闭,导致第二天MySQL启动不起来,贴出日志,求大神解惑!!!

jingguo_vip 2017-08-09 04:59:28
170808 23:02:18 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170808 23:02:19 InnoDB: Initializing buffer pool, size = 8.0M
170808 23:02:19 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
170808 23:02:19 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
170808 23:02:19 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
170808 23:02:19 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
170808 23:02:19 InnoDB: Started; log sequence number 0 0
170808 23:02:19 [Note] Event Scheduler: Loaded 0 events
170808 23:02:19 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
170809 20:27:35 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170809 20:27:35 [Warning] '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' instead.
/usr/libexec/mysqld: Character set 'utf-8' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file
170809 20:27:35 [ERROR] Aborting

170809 20:27:35 [Note] /usr/libexec/mysqld: Shutdown complete

170809 20:27:35 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170809 23:33:34 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170809 23:33:34 [Warning] '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' instead.
/usr/libexec/mysqld: Character set 'utf-8' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file
170809 23:33:34 [ERROR] Aborting

170809 23:33:34 [Note] /usr/libexec/mysqld: Shutdown complete

170809 23:33:34 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170809 23:35:50 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170809 23:35:50 [Warning] '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' instead.
/usr/libexec/mysqld: Character set 'utf-8' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file
170809 23:35:50 [ERROR] Aborting

170809 23:35:50 [Note] /usr/libexec/mysqld: Shutdown complete

170809 23:35:50 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170809 23:54:02 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170809 23:54:02 [Warning] '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' instead.
/usr/libexec/mysqld: Character set 'utf-8' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file
170809 23:54:02 [ERROR] Aborting

170809 23:54:02 [Note] /usr/libexec/mysqld: Shutdown complete

170809 23:54:02 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170810 00:19:15 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/usr/libexec/mysqld: Character set 'utf-8' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file
170810 0:19:15 [ERROR] Aborting

170810 0:19:15 [Note] /usr/libexec/mysqld: Shutdown complete

170810 00:19:15 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170810 00:25:27 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/usr/libexec/mysqld: Character set 'utf-8' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file
170810 0:25:27 [ERROR] Aborting

170810 0:25:27 [Note] /usr/libexec/mysqld: Shutdown complete

170810 00:25:27 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170810 00:48:16 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/usr/libexec/mysqld: Character set 'utf-8' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file
170810 0:48:16 [ERROR] Aborting

170810 0:48:16 [Note] /usr/libexec/mysqld: Shutdown complete

170810 00:48:16 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
...全文
319 3 打赏 收藏 转发到动态 举报
写回复
用AI写文章
3 条回复
切换为时间正序
请发表友善的回复…
发表回复
南音楼宇阁 2018-09-19
  • 打赏
  • 举报
回复
jingguo_vip 2017-08-10
  • 打赏
  • 举报
回复
问题已经解决了,还是谢谢回答!
rucypli 2017-08-10
  • 打赏
  • 举报
回复
配置文件有错误 指向的数据目录不对

57,062

社区成员

发帖
与我相关
我的任务
社区描述
MySQL相关内容讨论专区
社区管理员
  • MySQL
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧