I can't start the mysql server. It complains about the file permission. I am pretty sure that I set the user=mysql to have access rwx to folder /home/me/mysql. Here is the error and folder permission:
071118 06:37:14 mysqld started
071118 6:37:14 [ERROR] /usr/libexec/mysqld: Can't create/write to file '/home/me/mysql/data/dev.pid' (Errcode: 13)
071118 6:37:14 [ERROR] Can't start server: can't create PID file: Permission denied
071118 06:37:14 mysqld ended
/home/me/mysql
drwxrwxr-x 3 mysql mysql 4096 Nov 17 18:08 .
drwx------ 30 me me 4096 Nov 18 21:17 ..
drwxr-xr-x 4 mysql mysql 4096 Nov 18 06:38 data
/home/me/mysql/data
[me@dev data]$ ls -la
total 20
drwxr-xr-x 4 mysql mysql 4096 Nov 18 06:38 .
drwxrwxr-x 3 mysql mysql 4096 Nov 17 18:08 ..
-rw-rw---- 1 mysql mysql 1320 Nov 18 06:37 dev.err
drwx------ 2 mysql root 4096 Nov 18 06:36 mysql
drwx------ 2 mysql root 4096 Nov 18 06:36 test
Can someone tell me why mysql server can't create the dev.pid file in /home/me/mysql/data?