centos7 下mysql服务起不来的问题

2017-07-27 07:51:46 687 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

【BigWorld 游戏服务器引擎】Cell 架构设计介绍，及Java实现方案的探索横向扩展（Scalability）：通过动态增减CellApp和BaseApp的数量，可以轻松应对玩家人数的变化。世界可以做得非常大，只需增加更多的 Cell。负载分离（Load Separation）：将不同性质的负载分离，避免了单一进程瓶颈。CPU 密集型的实时计算（CellApp）和 I/O 密集型的数据操作（BaseApp）互不影响。高效的视野管理（AOI）：每个 Cell 只关心自己区域内和边界上的实体，大大降低了计算复杂度。容错性：某个CellApp。阅读详情

由于mysql的root密码忘记了，所以我执行了mysqld_safe --user=mysql --skip-grant-tables --skip-networking &这个命令，修改了mysql的root密码执行FLUSH PRIVILEGES; 退出之后发现mysql的服务起不来了
这是 Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details. 错误

status查看服务状态
[0m mysqld.service - MySQL Community Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: failed (Result: start-limit) since Thu 2017-07-27 20:45:55 CST; 2min 19s ago
Process: 11294 ExecStartPost=/usr/bin/mysql-systemd-start post (code=exited, status=0/SUCCESS)
Process: 11293 ExecStart=/usr/bin/mysqld_safe --basedir=/usr (code=exited, status=1/FAILURE)
Process: 11279 ExecStartPre=/usr/bin/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
Main PID: 11293 (code=exited, status=1/FAILURE)

Jul 27 20:45:55 db systemd[1]: Failed to start MySQL Community Server.
Jul 27 20:45:55 db systemd[1]: Unit mysqld.service entered failed state.
Jul 27 20:45:55 db systemd[1]: mysqld.service failed.
Jul 27 20:45:55 db systemd[1]: mysqld.service holdoff time over, scheduling restart.
Jul 27 20:45:55 db systemd[1]: start request repeated too quickly for mysqld.service
Jul 27 20:45:55 db systemd[1]: Failed to start MySQL Community Server.
Jul 27 20:45:55 db systemd[1]: Unit mysqld.service entered failed state.
Jul 27 20:45:55 db systemd[1]: mysqld.service failed.

查看log文件
170727 20:04:58 mysqld_safe Logging to '/var/log/mysqld.log'.
170727 20:04:58 mysqld_safe A mysqld process already exists
2017-07-27 20:08:50 6368 [ERROR] Incorrect definition of table mysql.proc: expected column 'definer' at position 11 to have type char(77), found type char(141).
2017-07-27 20:08:50 6368 [ERROR] Incorrect definition of table mysql.event: expected column 'definer' at position 3 to have type char(77), found type char(141).
2017-07-27 20:08:50 6368 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH'), found type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_A
170727 20:12:59 mysqld_safe Logging to '/var/log/mysqld.log'.
170727 20:12:59 mysqld_safe A mysqld process already exists
170727 20:13:00 mysqld_safe Logging to '/var/log/mysqld.log'.
170727 20:13:00 mysqld_safe A mysqld process already exists
170727 20:13:01 mysqld_safe Logging to '/var/log/mysqld.log'.
170727 20:13:01 mysqld_safe A mysqld process already exists
170727 20:13:03 mysqld_safe Logging to '/var/log/mysqld.log'.

请问是什么原因导致的

...全文