mysql 启动失败问题处理备忘

 

mysql 启动的时候报错

Starting MySQL.The server quit without updating PID file (/[失败]b/mysql/uhza00****.hichina.com.pid).

mysql安装过,启动报错,还是第一次碰到.有点慌....

 

 

查看日志  

/var/log/mysqld.log

 

150627 22:18:17 InnoDB: Completed initialization of buffer pool

150627 22:18:17  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 /data/mysql/ibdata2

InnoDB: File operation call: 'open'.

InnoDB: Cannot continue operation.

150627 22:18:17 mysqld_safe mysqld from pid file /var/lib/mysql/uhza00*****.hichina.com.pid ended

150627 22:19:44 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

 

发现是没有访问权限.

记起来/data目录的权限有修改过,修改为nobody

在 /data/mysql 目录中数据文件权限修改为root 但是仍然报错.

后来想想 是使用mysql的用户安装的. 将/data/mysql 目录中数据文件 修改为mysql然后启动. 成功了

[root@uhza00**** home]# ps -ef | grep mysql

root      7464     1  0 22:19 pts/1    00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/uhza00****.hichina.com.pid

 

mysql     7748  7464  0 22:19 pts/1    00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/lib/mysql/uhza00****.hichina.com.pid --socket=/var/lib/mysql/mysql.sock