记录一个错误
在启动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!