<![CDATA[Linux Forum — Mysql незапускается просит .pid]]> 2011-08-25T10:05:37Z PunBB https://linuxforum.ru/viewtopic.php?id=16073 <![CDATA[Re: Mysql незапускается просит .pid]]> Elrik12 пишет:

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

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

]]> https://linuxforum.ru/profile.php?id=6831 2011-08-25T10:05:37Z https://linuxforum.ru/viewtopic.php?pid=205758#p205758 <![CDATA[Re: Mysql незапускается просит .pid]]> Спасибо буду пробовать!

]]> https://linuxforum.ru/profile.php?id=530 2011-08-25T09:59:30Z https://linuxforum.ru/viewtopic.php?pid=205753#p205753 <![CDATA[Re: Mysql незапускается просит .pid]]> проблемы у тебя будут с selinux , предвижу я ..
а почему не поставить из репов ?
 Консоль:

yum install mysqlserver

ну а если в ручном режиме то тогда как-то так :
1. помним мускуль хитрый - работает только от своего пользователя , рут ему не указка , пользователя звать mysql и группа его mysql, если его нет тогда создаём :
 Консоль:

# useradd -d /var/lib/mysql --user-group --shell=/bin/false mysql

2. создаем необходимые папки :
 Консоль:

# mkdir -p /var/lib/mysql
# mkdir -p /var/run/mysql

3. назначаем нужные права :
 Консоль:

# chown -R mysql:mysql /var/lib/mysql
# chown -R mysql:mysql /var/run/mysql

4. запускаем :
 Консоль:

# mysqld start

5. Устанавливаем базы :
 Консоль:

# mysql_install_db

6. повторяем шаг №3 .
7. перезапускаем сервер ..
P.S. Пути я указал свои (Слака) в сентосе , а тем более при ручной установке пути могут быть другими - внимательно курить лог из первого поста !!!

]]> https://linuxforum.ru/profile.php?id=6831 2011-08-25T09:57:44Z https://linuxforum.ru/viewtopic.php?pid=205752#p205752 <![CDATA[Re: Mysql незапускается просит .pid]]> Вот пожалуста


/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
]]> https://linuxforum.ru/profile.php?id=530 2011-08-25T09:19:19Z https://linuxforum.ru/viewtopic.php?pid=205735#p205735 <![CDATA[Re: Mysql незапускается просит .pid]]> для начала покажи выхлоп :
 Консоль:

locate mysql

]]> https://linuxforum.ru/profile.php?id=6831 2011-08-25T09:16:53Z https://linuxforum.ru/viewtopic.php?pid=205734#p205734 <![CDATA[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.

]]> https://linuxforum.ru/profile.php?id=530 2011-08-25T09:00:09Z https://linuxforum.ru/viewtopic.php?pid=205725#p205725