forum.lissyara.su

Mysql 5.1 установленный из портов

При запуске запуске mysql
>/usr/local/etc/rc.d/mysql-server start

Starting mysql
>

но в процессах его нет
>ps -aux | grep mysql
>

Ниже приводится файл ошибок mysql


vi /var/db/mysql/runa.adamant.ua.err


091130 16:39:51 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
091130 16:39:51 [Note] Plugin 'FEDERATED' is disabled.
/usr/local/libexec/mysqld: Table 'mysql.plugin' doesn't exist
091130 16:39:51 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: Log scan progressed past the checkpoint lsn 0 37356
091130 16:39:51 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...
InnoDB: Doing recovery: scanned up to log sequence number 0 44233
091130 16:39:51 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
091130 16:39:51 InnoDB: Started; log sequence number 0 44233
091130 16:39:51 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
091130 16:39:51 mysqld_safe mysqld from pid file /var/db/mysql/runa.adamant.ua.pid ended

Права
>ls -l -d /var/db/mysql
dwrxrwxrwx 4 root wheel 512 Dec 1 09:18 /var/db/mysql
>

>ls -l /var/db/mysql/mysql
dwrxrwxrwx 4 root wheel 512 Dec 1 09:18 /var/db/mysql/mysql
>

Юзер mysql
>cat /etc/passwd | grep mysql
mysql:*88:88:Mysql Daemon:/nonexistent:/sbin/nologin
>

При попытке запустить скрипт /usr/local/bin/mysql_install_db вручную:

Installing MySQL system tables...

Installation of system tables failed! Examine the logs in
/var/db/mysql for more information.

You can try to start the mysqld daemon with:

shell> /usr/local/libexec/mysqld --skip-grant &

and use the command line tool /usr/local/bin/mysql
to connect to the mysql database and look at the grant tables:

shell> /usr/local/bin/mysql -u root mysql
mysql> show tables

Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /var/db/mysql that may be helpful.

The latest information about MySQL is available on the web at
http://www.mysql.com/. Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS. Another information source are the
MySQL email archives available at http://lists.mysql.com/.

Please check all of the above before mailing us! And remember, if
you do mail us, you MUST use the /usr/local/bin/mysqlbug script!

> /usr/local/libexec/mysqld --skip-grant &

Гость писал(а):091130 16:39:51 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

чтобы это могло значить?

zg писал(а):чтобы это могло значить?

только то, что люди не читают вывод программ и логи..

Нужно запустить mysql_upgrade, чтобы он бази подправил с таблицами