记录一个错误
在启动mysql的时候报如下错误
[root@db03 ~]# /etc/init.d/mysqld start
Starting MySQL. ERROR! The server quit without updating PID file (/application/mysql/data//db03.pid).
查看很久,错误日志也没有任何提示,后来发现日志目录logs权限为root,总算找到原因了,权限为root,mysql程序是mysql用户启动的,这样肯定是没有写入权限的。
[root@db03 application]# cd mysql
[root@db03 mysql]# ls
bin COPYING data docs include lib logs man my.cnf mysql-test README scripts share sql-bench support-files tmp
[root@db03 mysql]# ll
total 52
drwxr-xr-x 2 mysql mysql 4096 May 25 20:15 bin
-rw-r--r-- 1 mysql mysql 17987 May 25 18:36 COPYING
drwxr-xr-x 4 mysql mysql 138 May 25 20:34 data
drwxr-xr-x 2 mysql mysql 52 May 25 20:15 docs
drwxr-xr-x 3 mysql mysql 4096 May 25 20:15 include
drwxr-xr-x 3 mysql mysql 4096 May 25 20:15 lib
drwxr-xr-x 2 root root 22 May 25 20:18 logs
drwxr-xr-x 4 mysql mysql 28 May 25 20:14 man
-rw-r--r-- 1 mysql mysql 943 May 25 18:37 my.cnf
drwxr-xr-x 10 mysql mysql 4096 May 25 20:15 mysql-test
-rw-r--r-- 1 mysql mysql 2496 May 25 18:36 README
drwxr-xr-x 2 mysql mysql 29 May 25 20:15 scripts
drwxr-xr-x 28 mysql mysql 4096 May 25 20:15 share
drwxr-xr-x 4 mysql mysql 4096 May 25 20:15 sql-bench
drwxr-xr-x 2 mysql mysql 130 May 25 20:15 support-files
drwxr-xr-x 2 mysql mysql 32 May 25 20:24 tmp
解决方法:
[root@db03 mysql]# chown -R mysql.mysql logs
[root@db03 mysql]#
[root@db03 mysql]#
[root@db03 mysql]# /etc/init.d/mysqld start
Starting MySQL... SUCCESS!
浙公网安备 33010602011771号