Установка MySQL 5.5.7 на FreeBSD 8.1

Решил поставить MySQL в свой свеженький джайл. Обновил порты, затем

[erema15@erema15] /> ssh 192.168.1.101
Password:
%su
Password:
jail# portmaster /usr/ports/databases/mysql55-server

и процесс пошел.

После установки пробую запустить.

#/usr/local/share/mysql/mysql.server start

а оно мне

Starting MySQL.The server quit without updating PID file (/var/db/mysql/jail.erema15.by.pid).....

сразу пошел смотреть логи

jail#cd /var/db/mysql
jail# cat jail.erema15.by.err
101215 11:24:46 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
101215 11:24:46 [Note] Plugin 'FEDERATED' is disabled.
/usr/local/libexec/mysqld: Table 'mysql.plugin' doesn't exist
101215 11:24:46 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use GCC atomic builtins
InnoDB: Compressed tables use zlib 1.2.3
101215 11:24:46  InnoDB: Initializing buffer pool, size = 128.0M
101215 11:24:46  InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
101215 11:24:46  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
101215 11:24:46  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...
101215 11:24:46  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
101215 11:24:46  InnoDB: 1.1.3 started; log sequence number 0
101215 11:24:46 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
101215 11:24:46 mysqld_safe mysqld from pid file /var/db/mysql/jail.erema15.by.pid ended

по рекомендациям в самом логе (и еще где-то видел) временно пишем в rc.conf

jail# ee /etc/rc.conf
     mysql_enable="YES"
     mysql_args="--skip-grant-tables --skip-networking"

и сейчас должно все запуститься в безопасном режиме

jail# /usr/local/etc/rc.d/mysql-server start
Starting mysql.

Теперь делаем эти рекомендованное обновление таблиц, в консоли видим такую картину

jail# mysql_upgrade
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck with default connection arguments
Running 'mysqlcheck with default connection arguments
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.general_log                                  OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.host                                         OK
mysql.ndb_binlog_index                             OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.proxies_priv                                 OK
mysql.servers                                      OK
mysql.slow_log                                     OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
Running 'mysql_fix_privilege_tables'...
OK

теперь смело возвращаем rc.conf в прежднее состояние (я просто закоментил строку)

jail# ee /etc/rc.conf
     mysql_enable="YES"
     #mysql_args="--skip-grant-tables --skip-networking"

и передергиваем сервер

jail# /usr/local/etc/rc.d/mysql-server restart
Stopping mysql.
Waiting for PIDS: 95077.
Starting mysql.

все отлично, можно юзать.

P.S. Еще вот здесь есть инфа /usr/ports/UPDATING, но не знаю, про этот случай или нет...

...
20101110:
  AFFECTS: users of databases/mysql55-server
  AUTHOR: Alex Dupre 

  If you are upgrading from a previous MySQL release, the server will exit
  during startup after finding that the proxies_priv table is missing.
  To create the table, start the server with the --skip-grant-tables
  option to cause it to skip the normal grant table checks, then run
  mysql_upgrade. Then stop the server and restart it normally.
  You can do this by temporarly setting the following line in rc.conf:

  mysql_args="--skip-grant-tables --skip-networking"
...