mysql数据库报错:InnoDB: Operating system error number 13 in a file operation

时间:2021-08-14 12:40:18

环境:centos6.5 x86_64

启动mysql发现日志报错(日志路径可以查看/etc/my.cnf的配置)

160722 10:34:08 [Note] Found 42570716 of 42570696 rows when repairing './yunva@002dlog/room_msg'

160810  0:54:00 [ERROR] /usr/libexec/mysqld: Sort aborted

160810 10:41:55 [ERROR] /usr/libexec/mysqld: Sort aborted

160810 16:41:43 [ERROR] /usr/libexec/mysqld: Sort aborted

160823 11:34:45 mysqld_safe Starting mysqld daemon with databases from /home/data

160823 11:34:46 [Warning] Can't create test file /home/data/plugin.lower-test

160823 11:34:46 [Warning] Can't create test file /home/data/plugin.lower-test

160823 11:34:46 [Warning] option 'innodb-additional-mem-pool-size': signed value 200 adjusted to 524288

160823 11:34:46  InnoDB: Initializing buffer pool, size = 128.0M

160823 11:34:46  InnoDB: Completed initialization of buffer pool

160823 11:34:46  InnoDB: Operating system error number 13 in a file operation.

InnoDB: The error means mysqld does not have the access rights to

InnoDB: the directory.

InnoDB: File name ./ibdata1

InnoDB: File operation call: 'open'.

InnoDB: Cannot continue operation.

160823 11:34:46 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

160823 11:45:30 mysqld_safe Starting mysqld daemon with databases from /home/data

160823 11:45:30 [Warning] Can't create test file /home/data/plugin.lower-test

160823 11:45:30 [Warning] Can't create test file /home/data/plugin.lower-test

160823 11:45:30 [Warning] option 'innodb-additional-mem-pool-size': signed value 200 adjusted to 524288

160823 11:45:30  InnoDB: Initializing buffer pool, size = 128.0M

160823 11:45:30  InnoDB: Completed initialization of buffer pool

160823 11:45:30  InnoDB: Operating system error number 13 in a file operation.

InnoDB: The error means mysqld does not have the access rights to

InnoDB: the directory.

InnoDB: File name ./ibdata1

InnoDB: File operation call: 'open'.

InnoDB: Cannot continue operation.

发现系统启动只有几十分钟,说明服务器刚被人重启过,mysql服务无法启动

百度了下可能是selinux引起的,getenforce 发现问enforcing

setenforce 0

并且修改配置/etc/sysconfig/selinux

SELINUX=disabled

问题解决