jingguo_vip 2017-08-10 04:08 采纳率: 0%
浏览 2607
已采纳

centos虚拟机重启后,MySQL服务启动不了了,求解?

#MySQL版本5.1.73
贴出日志如下:

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 5:21:42 [Note] /usr/libexec/mysqld: Normal shutdown

170809 5:21:42 [Note] Event Scheduler: Purging the queue. 0 events
170809 5:21:42 InnoDB: Starting shutdown...
170809 5:21:45 InnoDB: Shutdown completed; log sequence number 0 89508
170809 5:21:45 [Note] /usr/libexec/mysqld: Shutdown complete

170809 05:21:45 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170810 18:53:14 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170810 18:53:14 [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
170810 18:53:14 [ERROR] Aborting

170810 18:53:14 [Note] /usr/libexec/mysqld: Shutdown complete

170810 18:53:14 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170810 18:54:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170810 18:54:30 [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
170810 18:54:30 [ERROR] Aborting

170810 18:54:30 [Note] /usr/libexec/mysqld: Shutdown complete

170810 18:54:30 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended


  • 写回答

1条回答 默认 最新

  • dmltzy 2017-08-10 04:22
    关注

    'utf-8' --> 'utf8'

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 如何让企业微信机器人实现消息汇总整合
  • ¥50 关于#ui#的问题:做yolov8的ui界面出现的问题
  • ¥15 如何用Python爬取各高校教师公开的教育和工作经历
  • ¥15 TLE9879QXA40 电机驱动
  • ¥20 对于工程问题的非线性数学模型进行线性化
  • ¥15 Mirare PLUS 进行密钥认证?(详解)
  • ¥15 物体双站RCS和其组成阵列后的双站RCS关系验证
  • ¥20 想用ollama做一个自己的AI数据库
  • ¥15 关于qualoth编辑及缝合服装领子的问题解决方案探寻
  • ¥15 请问怎么才能复现这样的图呀