MySQL错误文件 [英] MySQL Error Files
问题描述
如何解决这个问题？
Chown？
chown：更改 / var / lib / mysql / ibdata1'的所有权 / var / lib / mysql的所有权/ denora'：不允许操作
chown：更改
chown：更改 / var / lib / mysql / anope'的所有权 / var / lib / mysql / test'：不允许操作
chown：更改
chown：更改的所有权/var/lib/mysql/Animachat.svipchat.org.err'：不允许操作 /var/lib/mysql/vpsgabriel.svipchat.org.err'：不允许操作
chown：更改所有权
chown：更改 / var的所有权/ lib / mysql / ib_logfile1'：不允许操作 / var / lib / mysql / mysql'的所有权
chown：更改
chown： code> / var / lib / mysql / wp'：不允许操作
chown：更改 / var / lib / mysql / ib_logfile0'的所有权
MysqlD开始？
[root @ SSH mysql]＃sudo /etc/init.d/mysqld restart
停止mysqld：[OK]
MySQL守护进程启动失败。
启动mysqld：[FAILED]
记录MySQLd：
140129 09:39:37 mysqld_safe从/ var / lib / mysql中的数据库启动mysqld守护程序
140129 9:39:37 [警告]'--safe-show-database'已弃用，未来版本。请改用GRANT SHOW DATABASES。
140129 9:39:37 InnoDB：初始化缓冲池，大小= 8.0M
140129 9:39:37 InnoDB：完成缓冲池的初始化
140129 9:39:37 InnoDB：操作系统错误号13在文件操作中。
InnoDB：错误的意思是mysqld没有访问
InnoDB的目录。
InnoDB：文件名./ibdata1
InnoDB：文件操作调用：'open'。
InnoDB：无法继续操作。
140129 09:39:37 mysqld_safe mysqld from pid文件/var/run/mysqld/mysqld.pid ended
140129 09:40:05 mysqld_safe从/ var / lib / mysql启动带有数据库的mysqld守护进程
140129 9:40:05 [警告]--safe-show-database已弃用，将在以后的版本中删除。请改用GRANT SHOW DATABASES。
140129 9:40:05 InnoDB：初始化缓冲池，大小= 8.0M
140129 9:40:05 InnoDB：完成缓冲池的初始化
140129 9:40:05 InnoDB：操作系统错误号13在文件操作中。
InnoDB：错误的意思是mysqld没有访问
InnoDB的目录。
InnoDB：文件名./ibdata1
InnoDB：文件操作调用：'open'。
InnoDB：无法继续操作。
140129 09:40:05 mysqld_safe mysqld从pid文件/var/run/mysqld/mysqld.pid已结束
140129 09:42:02 mysqld_safe从/ var / lib / mysql $数据库启动mysqld守护程序b $ b 140129 9:42:02 [警告]'--safe-show-database'已弃用，将在以后的版本中删除。请改用GRANT SHOW DATABASES。
140129 9:42:02 InnoDB：初始化缓冲池，大小= 8.0M
140129 9:42:02 InnoDB：完成缓冲池初始化
140129 9:42:02 InnoDB：操作系统错误号13在文件操作中。
InnoDB：错误的意思是mysqld没有访问
InnoDB的目录。
InnoDB：文件名./ibdata1
InnoDB：文件操作调用：'open'。
InnoDB：无法继续操作。
140129 09:42:02 mysqld_safe mysqld from pid文件/var/run/mysqld/mysqld.pid ended
140129 09:44:55 mysqld_safe从/ var / lib / mysql启动带有数据库的mysqld守护进程
140129 9:44:55 [警告]'--safe-show-database'已弃用，将在以后的版本中删除。请改用GRANT SHOW DATABASES。
140129 9:44:55 InnoDB：初始化缓冲池，大小= 8.0M
140129 9:44:55 InnoDB：完成缓冲池的初始化
140129 9:44:55 InnoDB：操作系统错误号13在文件操作中。
InnoDB：错误的意思是mysqld没有访问
InnoDB的目录。
InnoDB：文件名./ibdata1
InnoDB：文件操作调用：'open'。
InnoDB：无法继续操作。
140129 09:44:55 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
如果您的数据库目录没有写入数据库目录的权限，那么运行MySQL守护程序的用户将无法写入您的数据库目录。你正在使用默认设置的标准安装，以下命令应修正（编辑添加sudo根据编辑的输出：如果你可以运行 root ，离开 sudo ）：
-R mysql：mysql / var / lib / mysql
你可以找到什么用户它不是在 /etc/my.cnf中查找或 user = 选项 /etc/mysql/my.cnf 。
How To resolve this?
Chown?
chown: changing ownership of /var/lib/mysql/ibdata1': Operation not permitted
chown: changing ownership of/var/lib/mysql/denora': Operation not permitted
chown: changing ownership of /var/lib/mysql/anope': Operation not permitted
chown: changing ownership of/var/lib/mysql/test': Operation not permitted
chown: changing ownership of /var/lib/mysql/Animachat.svipchat.org.err': Operation not permitted
chown: changing ownership of/var/lib/mysql/vpsgabriel.svipchat.org.err': Operation not permitted
chown: changing ownership of /var/lib/mysql/ib_logfile1': Operation not permitted
chown: changing ownership of/var/lib/mysql/mysql': Operation not permitted
chown: changing ownership of /var/lib/mysql/wp': Operation not permitted
chown: changing ownership of/var/lib/mysql/ib_logfile0': Operation not permitted
MysqlD Start?
[root@SSH mysql]# sudo /etc/init.d/mysqld restart Stopping mysqld: [ OK ] MySQL Daemon failed to start. Starting mysqld: [FAILED]
Log MySQLd:
140129 09:39:37 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140129 9:39:37 [Warning] '--safe-show-database' is deprecated and will be removed in a future release. Please use 'GRANT SHOW DATABASES' instead.
140129 9:39:37 InnoDB: Initializing buffer pool, size = 8.0M
140129 9:39:37 InnoDB: Completed initialization of buffer pool
140129 9:39:37 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.
140129 09:39:37 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
140129 09:40:05 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140129 9:40:05 [Warning] '--safe-show-database' is deprecated and will be removed in a future release. Please use 'GRANT SHOW DATABASES' instead.
140129 9:40:05 InnoDB: Initializing buffer pool, size = 8.0M
140129 9:40:05 InnoDB: Completed initialization of buffer pool
140129 9:40:05 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.
140129 09:40:05 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
140129 09:42:02 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140129 9:42:02 [Warning] '--safe-show-database' is deprecated and will be removed in a future release. Please use 'GRANT SHOW DATABASES' instead.
140129 9:42:02 InnoDB: Initializing buffer pool, size = 8.0M
140129 9:42:02 InnoDB: Completed initialization of buffer pool
140129 9:42:02 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.
140129 09:42:02 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
140129 09:44:55 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140129 9:44:55 [Warning] '--safe-show-database' is deprecated and will be removed in a future release. Please use 'GRANT SHOW DATABASES' instead.
140129 9:44:55 InnoDB: Initializing buffer pool, size = 8.0M
140129 9:44:55 InnoDB: Completed initialization of buffer pool
140129 9:44:55 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.
140129 09:44:55 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
The user that runs the MySQL daemon doesn't have permission to write to your database directory.
If you're using a standard installation with default settings, the following command should fix that (edited to add sudo based on your edited output: if you can run as root, leave off the sudo):
sudo chown -R mysql:mysql /var/lib/mysql
You can find exactly what user it is (if it's not mysql) by looking for the user= option in /etc/my.cnf, or /etc/mysql/my.cnf.
这篇关于MySQL错误文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
