mark 一次mysql 无法启动，errno:13

环境：CentOS release 6.10 (Final)  mysql：Server version: 5.7.24

启动命令：/etc/rc.d/init.d/mysqld start

错误提示：

>tail -20 /mysqllog/mysqld_err.log 

[ERROR] InnoDB: Failed to create check sector file, errno:13 Please confirm O_DIRECT is supported and remove the file /check_sector_size if it exists.
 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode.
 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
[Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
[Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
[Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
[Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
[Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
[root@MysqlDB0015 mysqldata]# 

查看操作历史  (测试kill)

 1011  killall mysqld
 1012  ps -ef |grep mysql |grep -v grep
 1013  /etc/rc.d/init.d/mysql_0 start
 1014  ps -ef |grep mysql |grep -v grep
 1015  pkill mysqld
 1016  ps -ef |grep mysql |grep -v grep
 1017  /etc/rc.d/init.d/mysql_0 start
 1018  ps -ef |grep mysql |grep -v grep
 1019  killall -9 mysqld_safe
 1020  ps -ef |grep mysql |grep -v grep
 1021  mysql -uroot -p
 1022  /etc/rc.d/init.d/mysql_0 stop
 1023  /etc/rc.d/init.d/mysql_0 start
 1024  tail -40 /mysqllog/mysqld_err.log 

....

1064  vim /etc/my.cnf

想起vim  my.cnf  注释掉l了character-set-server=utf8，并添加default-character-set=utf8  (当时为重现mysqlbinlog: unknown variable 'default-character-set=utf8')。

然后重新修改回来。

然后/etc/rc.d/init.d/mysqld start

 

OK 了。

 

第一次写mark mark