centos7 下mysql服务起不来的问题

[匿名张]

由于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'.


请问是什么原因导致的

[二月十六]

修改摇之后重启的服务还是什么也没做就进不去了？执行完flush 后不用重启服务，直接登录就可以

[匿名张]

引用 1 楼 sinat_28984567 的回复:

修改摇之后重启的服务还是什么也没做就进不去了？执行完flush 后不用重启服务，直接登录就可以

你说的这样是能进去的，但是我要远程连接的嘛！ 不启服务就不行了