MySQL Forums
Forum List  »  Russian

Mysql 5.1 in FreeBSD 8/0
Posted by: Jam Jam
Date: December 01, 2009 03:59AM

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 &

Options: ReplyQuote


Subject
Views
Written By
Posted
Mysql 5.1 in FreeBSD 8/0
8085
December 01, 2009 03:59AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.