/usr/libexec/mysqld: File './mysql
程序员文章站
2022-05-19 07:51:29
...
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/mysql150214 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害死人……
上一篇: mysql原生SQL查询错误出现异常“ Every derived table must have
下一篇: 元素未显示设置width/height时IE中使用currentStyle获取为auto_javascript技巧
推荐阅读
-
mysqld_safe error: log-error set to '/data/log/mysqld.log', however file don't exists. Create writable for user 'mysql'.The server
-
关于mysql启动问题---mysqld_safe mysqld from pid file * ended
-
mysql初始化/usr/local/mysql/bin/mysqld: error while loading shared libraries: libnuma.so.1: cannot open shared object file: No such file or directory
-
mysql 错误解决:Plugin 'FEDERATED' is disabled. /usr/sbin/mysqld: Table '
-
/usr/libexec/mysqld: File './mysql
-
linux安装mysql提示mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
-
/usr/libexec/mysqld: Can’t create/write to file ‘/
-
usr/bin/mysqladmin: refresh failed; error: 'Unkn_MySQL
-
解决 mysql ERROR 1017 :Can't find file: '/xx_MySQL
-
/usr/libexec/mysqld: File './mysql