Mysql незапускается просит .pid

Добрый день товарищи гуру и не только в какой раз я обращаюсь к вам с просьбой помочь. суть проблемы собирал mysql-server из сырцов:

tar -xf mysql-5.5.12.tar.gz
cd mysql-5.5.12
groupadd mysql
useradd -r -g mysql mysql
cmake .
make
make install
cd /usr/local/mysql
chown -R mysql .
chgrp -R mysql .
scripts/mysql_install_db --user=mysql
chown -R root .
chown -R mysql data
cp support-files/my-medium.cnf /etc/my.cnf
cp support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld
chkconfig --levels 235 mysqld on

Запускаю сервер:
[root@lib data]# service mysqld start
Starting MySQL.. ERROR! The server quit without updating PID file (/usr/local/mysql/data/lib.xxxx.xx.pid).

В логах /usr/local/mysql/data/lib.xxxx.uz.err

110825 4:35:18 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
110825 4:35:19 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
110825 4:35:19 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
110825 4:35:20 InnoDB: Waiting for the background threads to start
110825 4:35:21 InnoDB: 1.1.6 started; log sequence number 0
110825 4:35:21 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
110825 04:35:21 mysqld_safe mysqld from pid file /usr/local/mysql/data/lib.tashiit.uz.pid ended
110825 05:22:48 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
/usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
110825 5:22:48 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110825 5:22:48 InnoDB: The InnoDB memory heap is disabled
110825 5:22:48 InnoDB: Mutexes and rw_locks use GCC atomic builtins
110825 5:22:48 InnoDB: Compressed tables use zlib 1.2.5
110825 5:22:48 InnoDB: Initializing buffer pool, size = 128.0M
110825 5:22:48 InnoDB: Completed initialization of buffer pool
110825 5:22:48 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110825 5:22:48 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
110825 5:22:48 InnoDB: Waiting for the background threads to start
110825 5:22:49 InnoDB: 1.1.6 started; log sequence number 1595675
110825 5:22:49 [Note] Recovering after a crash using mysql-bin
110825 5:22:49 [Note] Starting crash recovery...
110825 5:22:49 [Note] Crash recovery finished.
110825 5:22:50 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
110825 05:22:50 mysqld_safe mysqld from pid file /usr/local/mysql/data/lib.tashiit.uz.pid ended
110825 05:41:13 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
/usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
110825 5:41:13 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110825 5:41:13 InnoDB: The InnoDB memory heap is disabled
110825 5:41:13 InnoDB: Mutexes and rw_locks use GCC atomic built-ins

Ребят кто с такивался с такой проблемой отпишитесь пожалуйста как ее лечить

Операционная система CentOS 6.

для начала покажи выхлоп :
[console]
locate mysql
[/console]

Вот пожалуста

/etc/ld.so.conf.d/mysql-x86_64.conf
/etc/selinux/targeted/modules/active/modules/mysql.pp
/root/mysql-5.5.12.tar.gz
/usr/lib/python2.6/site-packages/sos/plugins/mysql.py
/usr/lib/python2.6/site-packages/sos/plugins/mysql.pyc
/usr/lib/python2.6/site-packages/sos/plugins/mysql.pyo
/usr/lib64/mysql
/usr/lib64/mysql/libmysqlclient.so.16
/usr/lib64/mysql/libmysqlclient.so.16.0.0
/usr/lib64/mysql/libmysqlclient_r.so.16
/usr/lib64/mysql/libmysqlclient_r.so.16.0.0
/usr/share/mysql
/usr/share/doc/mysql-libs-5.1.52
/usr/share/doc/mysql-libs-5.1.52/COPYING
/usr/share/doc/mysql-libs-5.1.52/EXCEPTIONS-CLIENT
/usr/share/doc/rsyslog-4.6.2/ommysql.html
/usr/share/doc/rsyslog-4.6.2/rsyslog_mysql.html
/usr/share/man/man5/mysql_table.5.gz
/usr/share/mysql/charsets
/usr/share/mysql/czech
/usr/share/mysql/danish
/usr/share/mysql/dutch
/usr/share/mysql/english
/usr/share/mysql/estonian
/usr/share/mysql/french
/usr/share/mysql/german
/usr/share/mysql/greek
/usr/share/mysql/hungarian
/usr/share/mysql/italian
/usr/share/mysql/japanese
/usr/share/mysql/korean
/usr/share/mysql/norwegian
/usr/share/mysql/norwegian-ny
/usr/share/mysql/polish
/usr/share/mysql/portuguese
/usr/share/mysql/romanian
/usr/share/mysql/russian
/usr/share/mysql/serbian
/usr/share/mysql/slovak
/usr/share/mysql/spanish
/usr/share/mysql/swedish
/usr/share/mysql/ukrainian
/usr/share/mysql/charsets/Index.xml
/usr/share/mysql/charsets/README
/usr/share/mysql/charsets/armscii8.xml
/usr/share/mysql/charsets/ascii.xml
/usr/share/mysql/charsets/cp1250.xml
/usr/share/mysql/charsets/cp1251.xml
/usr/share/mysql/charsets/cp1256.xml
/usr/share/mysql/charsets/cp1257.xml
/usr/share/mysql/charsets/cp850.xml
/usr/share/mysql/charsets/cp852.xml
/usr/share/mysql/charsets/cp866.xml
/usr/share/mysql/charsets/dec8.xml
/usr/share/mysql/charsets/geostd8.xml
/usr/share/mysql/charsets/greek.xml
/usr/share/mysql/charsets/hebrew.xml
/usr/share/mysql/charsets/hp8.xml
/usr/share/mysql/charsets/keybcs2.xml
/usr/share/mysql/charsets/koi8r.xml
/usr/share/mysql/charsets/koi8u.xml
/usr/share/mysql/charsets/latin1.xml
/usr/share/mysql/charsets/latin2.xml
/usr/share/mysql/charsets/latin5.xml
/usr/share/mysql/charsets/latin7.xml
/usr/share/mysql/charsets/macce.xml
/usr/share/mysql/charsets/macroman.xml
/usr/share/mysql/charsets/swe7.xml
/usr/share/mysql/czech/errmsg.sys
/usr/share/mysql/danish/errmsg.sys
/usr/share/mysql/dutch/errmsg.sys
/usr/share/mysql/english/errmsg.sys
/usr/share/mysql/estonian/errmsg.sys
/usr/share/mysql/french/errmsg.sys
/usr/share/mysql/german/errmsg.sys
/usr/share/mysql/greek/errmsg.sys
/usr/share/mysql/hungarian/errmsg.sys
/usr/share/mysql/italian/errmsg.sys
/usr/share/mysql/japanese/errmsg.sys
/usr/share/mysql/korean/errmsg.sys
/usr/share/mysql/norwegian/errmsg.sys
/usr/share/mysql/norwegian-ny/errmsg.sys
/usr/share/mysql/polish/errmsg.sys
/usr/share/mysql/portuguese/errmsg.sys
/usr/share/mysql/romanian/errmsg.sys
/usr/share/mysql/russian/errmsg.sys
/usr/share/mysql/serbian/errmsg.sys
/usr/share/mysql/slovak/errmsg.sys
/usr/share/mysql/spanish/errmsg.sys
/usr/share/mysql/swedish/errmsg.sys
/usr/share/mysql/ukrainian/errmsg.sys
/usr/share/selinux/devel/include/services/mysql.if
/usr/share/selinux/targeted/mysql.pp.bz2
/usr/share/vim/vim72/syntax/mysql.vim
/var/lib/yum/yumdb/m/1347118c3ef65814217803fcb021d8b9283e8e49-mysql-libs-5.1.52-1.el6_0.1-x86_64
/var/lib/yum/yumdb/m/1347118c3ef65814217803fcb021d8b9283e8e49-mysql-libs-5.1.52-1.el6_0.1-x86_64/checksum_data
/var/lib/yum/yumdb/m/1347118c3ef65814217803fcb021d8b9283e8e49-mysql-libs-5.1.52-1.el6_0.1-x86_64/checksum_type
/var/lib/yum/yumdb/m/1347118c3ef65814217803fcb021d8b9283e8e49-mysql-libs-5.1.52-1.el6_0.1-x86_64/command_line
/var/lib/yum/yumdb/m/1347118c3ef65814217803fcb021d8b9283e8e49-mysql-libs-5.1.52-1.el6_0.1-x86_64/from_repo
/var/lib/yum/yumdb/m/1347118c3ef65814217803fcb021d8b9283e8e49-mysql-libs-5.1.52-1.el6_0.1-x86_64/from_repo_revision
/var/lib/yum/yumdb/m/1347118c3ef65814217803fcb021d8b9283e8e49-mysql-libs-5.1.52-1.el6_0.1-x86_64/from_repo_timestamp
/var/lib/yum/yumdb/m/1347118c3ef65814217803fcb021d8b9283e8e49-mysql-libs-5.1.52-1.el6_0.1-x86_64/reason
/var/lib/yum/yumdb/m/1347118c3ef65814217803fcb021d8b9283e8e49-mysql-libs-5.1.52-1.el6_0.1-x86_64/releasever

проблемы у тебя будут с selinux , предвижу я ..
а почему не поставить из репов ?
[console]
yum install mysqlserver
[/console]
ну а если в ручном режиме то тогда как-то так :
1. помним мускуль хитрый - работает только от своего пользователя , рут ему не указка , пользователя звать mysql и группа его mysql, если его нет тогда создаём :
[console]
# useradd -d /var/lib/mysql --user-group --shell=/bin/false mysql
[/console]
2. создаем необходимые папки :
[console]
# mkdir -p /var/lib/mysql
# mkdir -p /var/run/mysql
[/console]
3. назначаем нужные права :
[console]
# chown -R mysql:mysql /var/lib/mysql
# chown -R mysql:mysql /var/run/mysql
[/console]
4. запускаем :
[console]
# mysqld start
[/console]
5. Устанавливаем базы :
[console]
# mysql_install_db
[/console]
6. повторяем шаг №3 .
7. перезапускаем сервер ..
P.S. Пути я указал свои (Слака) в сентосе , а тем более при ручной установке пути могут быть другими - внимательно курить лог из первого поста !!!

Спасибо буду пробовать!

Elrik12 написал:

110825 5:41:13 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

вот на это ещё обрати внимание , возможно всё и работает , нужно только базы переустановить .. удачи wink