с юзером mysql pid не хочет создавать никак...
Создал юзера mysql-user выполнил команды:[10:32][root@ххх:~]# chown -Rh mysql-user /var/lib/mysql
[10:33][root@ххх:~]# chown -Rh mysql-user /var/log/mysql.log
[10:34][root@ххх:~]# chown -Rh mysql-user /var/log/mysqld.log
[10:34][root@ххх:~]# chown -Rh mysql-user /var/run/mysqld/
[10:42][root@ххх:~]# cd /var/lib/mysql/
[10:43][root@ххх:/var/lib/mysql]# chown -Rh mysql-user *
в файле my.cnf:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql-user
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
log=/var/log/mysql.log
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
В логах вот это:
081120 10:48:53 mysqld started
081120 10:48:53 InnoDB: Started; log sequence number 0 43655
081120 10:48:53 [ERROR] Can't start server : Bind on unix socket: Permission denied
081120 10:48:53 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
081120 10:48:53 [ERROR] Aborting
081120 10:48:53 InnoDB: Starting shutdown...
081120 10:48:56 InnoDB: Shutdown completed; log sequence number 0 43655
081120 10:48:56 [Note] /usr/libexec/mysqld: Shutdown complete
081120 10:48:56 mysqld ended
может ещё на какую папку права поменять надо?