Home > Database > Mysql Tutorial > /usr/libexec/mysqld: File './mysql

/usr/libexec/mysqld: File './mysql

WBOY
Release: 2016-06-07 15:27:04
Original
1372 people have browsed it

150214 00:19:30 mysqld_safe Starting mysqld daemon with databases from /data/mysql 150214 0:19:30 [Warning] Can't create test file /data/mysql/localhost.lower-test 150214 0:19:30 [Warning] Can't create test file /data/mysql/localhost.lower

150214 00:19:30 mysqld_safe Starting mysqld daemon with databases from /data/mysql
150214  0:19:30 [Warning] Can't create test file /data/mysql/localhost.lower-test
150214  0:19:30 [Warning] Can't create test file /data/mysql/localhost.lower-test
/usr/libexec/mysqld: File './mysql-bin.index' not found (Errcode: 13)
150214  0:19:30 [ERROR] Aborting


150214  0:19:30 [Note] /usr/libexec/mysqld: Shutdown complete


150214 00:19:30 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
150214 00:21:52 mysqld_safe Starting mysqld daemon with databases from /data/mysql
150214  0:21:52 [Warning] Can't create test file /data/mysql/localhost.lower-test
150214  0:21:52 [Warning] Can't create test file /data/mysql/localhost.lower-test
/usr/libexec/mysqld: File './mysql-bin.index' not found (Errcode: 13)
150214  0:21:52 [ERROR] Aborting


150214  0:21:52 [Note] /usr/libexec/mysqld: Shutdown complete


提示./mysql-bin.index无法找到(由于mysql开启了bin日志功能),到数据库根目录查看该文件是存在的,可能是文件权限的问题,查看了数据库根目录的权限是700,所有者和用户组都是root,可能是上次转移数据库的时候不小心修改了文件夹的权限。

解决方法:

chown -R mysql.mysql /data/mysql


重启还是报一样的错,各种折腾,最后定位问题selinux害死人……


Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template