Добрый день товарищи гуру и не только в какой раз я обращаюсь к вам с просьбой помочь. суть проблемы собирал 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.
ОлоЛО =========> GOOGLE там. Я знаю что он там ! я там был ! Наверно не нашел что искал ! А чеб я приперся на форум!
