可可熊的窝

F7中启动Mysql出错

IN:Linux   Tags: ,    Comments:6

F7在默认安装Mysql后启动时会出错:

使用mysqld_safe启动:

[cocobear@cocobear mysql]$ sudo mysqld_safe
nohup: ignoring input and redirecting stderr to stdout
Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/lib/mysql/cocobear.pid
070725 09:27:34 mysqld ended

使用service启动:

[cocobear@cocobear mysql]$ sudo service mysqld start
Timeout error occurred trying to start MySQL Daemon.
启动 MySQL: [失败]

这种情况下mysql.log出错提示为:

070725 09:28:59 mysqld started
070725 9:28:59 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.
070725 09:28:59 mysqld ended

根据日志文件的出错信息大致可以认定为权限问题,修改/var/lib/mysql/下的这几个文件权限:
ibdata1 ib_logfile0 ib_logfile1

[cocobear@cocobear mysql]$ sudo chmod 766 ib*

然后重新启动:

[cocobear@cocobear mysql]$ sudo service mysqld start
启动 MySQL: [确定]

很奇怪为什么会产生这样的问题,纳闷~

07-25
2007

6 Comments for F7中启动Mysql出错

Leave a Comment

loading...