Установка MySQL 5.6

[Rus]

Возникла проблема при установке, ошибки:

Подскажите плиз в чем проблемка?
OS: Freebsd 10

Код: Выделить всё

[ 19%] Building CXX object sql/CMakeFiles/mysql_tzinfo_to_sql.dir/tztime.cc.o
Linking CXX executable mysql_tzinfo_to_sql
/usr/bin/ld:../mysys_ssl/libmysys_ssl.a: file format not recognized; treating as linker script
/usr/bin/ld:../mysys_ssl/libmysys_ssl.a:1: syntax error
c++: error: linker command failed with exit code 1 (use -v to see invocation)
*** [sql/mysql_tzinfo_to_sql] Error code 1

make[3]: stopped in /usr/ports/databases/mysql56-server/work/mysql-5.6.22
1 error

make[3]: stopped in /usr/ports/databases/mysql56-server/work/mysql-5.6.22
*** [sql/CMakeFiles/mysql_tzinfo_to_sql.dir/all] Error code 2

make[2]: stopped in /usr/ports/databases/mysql56-server/work/mysql-5.6.22
1 error

make[2]: stopped in /usr/ports/databases/mysql56-server/work/mysql-5.6.22
*** [all] Error code 2

make[1]: stopped in /usr/ports/databases/mysql56-server/work/mysql-5.6.22
1 error

make[1]: stopped in /usr/ports/databases/mysql56-server/work/mysql-5.6.22
===> Compilation failed unexpectedly.
Try to set MAKE_JOBS_UNSAFE=yes and rebuild before reporting the failure to
the maintainer.
*** Error code 1

Stop.
make: stopped in /usr/ports/databases/mysql56-server

[Хостинг HostFood.ru]

Тарифы на хостинг в России, от 12 рублей: https://www.host-food.ru/tariffs/hosting/
Тарифы на виртуальные сервера (VPS/VDS/KVM) в РФ, от 189 руб.: https://www.host-food.ru/tariffs/virtualny-server-vps/
Выделенные сервера, Россия, Москва, от 2000 рублей (HP Proliant G5, Intel Xeon E5430 (2.66GHz, Quad-Core, 12Mb), 8Gb RAM, 2x300Gb SAS HDD, P400i, 512Mb, BBU):
https://www.host-food.ru/tariffs/vydelennyi-server-ds/
Недорогие домены в популярных зонах: https://www.host-food.ru/domains/

[Rus]

Вроде установил но теперь не запускается

Код: Выделить всё

150106 12:27:38 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
150106 12:27:38 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
150106 12:27:38 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072
150106 12:27:38 [Warning] '--log' is deprecated and will be removed in a future release. Please use ''--general_log'/'--general_log_file'' instead.
150106 12:27:38 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
150106 12:27:38 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072
150106 12:27:38 [Warning] '--log' is deprecated and will be removed in a future release. Please use ''--general_log'/'--general_log_file'' instead.
150106 12:27:38 [Note] Plugin 'FEDERATED' is disabled.
150106 12:27:38 [Note] Plugin 'InnoDB' is disabled.
/usr/local/libexec/mysqld: Table 'mysql.plugin' doesn't exist
150106 12:27:38 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/usr/local/libexec/mysqld: File '/var/log/mysql.log' not found (Errcode: 13)
150106 12:27:38 [ERROR] Could not use /var/log/mysql.log for logging (error 13). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it.
150106 12:27:38 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
150106 12:27:38 mysqld_safe mysqld from pid file /var/db/mysql/WebServer.pid ended

[FiL]

Видимо mysql_install_db не отработал при инсталляции. Запусти руками.

[Rus]

Сейчас такая ошибка

Код: Выделить всё

150107 20:27:50 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2015-01-07 20:27:51 0 [ERROR] /usr/local/libexec/mysqld: ambiguous option '--log=/var/log/mysql.log' (log-bin, log_slave_updates)
2015-01-07 20:27:51 0 [ERROR] Aborting

2015-01-07 20:27:51 0 [Note] Binlog end
150107 20:27:51 mysqld_safe mysqld from pid file /var/db/mysql/WebServer.pid ended

что тут не так?

[FiL]

Да вроде нормальным языком написано что не так.

ambiguous option '--log=/var/log/mysql.log'

Ну и далее советую почитать тут - http://dev.mysql.com/doc/refman/5.6/en/query-log.html
А заодно и про более старые версии тут - http://dev.mysql.com/doc/refman/5.1/en/query-log.html
Возможно, что наступит просветление.

[Rus]

Да нормальным языком написано для вас, мне пока это сложно т.к. только начинаю... Я понял что там написано, но как решить не знаю поэтому и спросил...

[FiL]

ну, для простоты, например, убрать это логирование нафик.

[Rus]

убрал теперь пишет такую ошибку

Код: Выделить всё

150108 11:37:50 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2015-01-08 11:37:50 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-01-08 11:37:50 19777 [Note] Plugin 'FEDERATED' is disabled.
2015-01-08 11:37:50 19777 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-01-08 11:37:50 19777 [Note] InnoDB: The InnoDB memory heap is disabled
2015-01-08 11:37:50 19777 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-01-08 11:37:50 19777 [Note] InnoDB: Memory barrier is not used
2015-01-08 11:37:50 19777 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-01-08 11:37:50 19777 [Note] InnoDB: Not using CPU crc32 instructions
2015-01-08 11:37:50 19777 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-01-08 11:37:51 19777 [Note] InnoDB: Completed initialization of buffer pool
2015-01-08 11:37:51 19777 [Note] InnoDB: Highest supported file format is Barracuda.
2015-01-08 11:37:51 19777 [Note] InnoDB: 128 rollback segment(s) are active.
2015-01-08 11:37:51 19777 [Note] InnoDB: Waiting for purge to start
2015-01-08 11:37:51 19777 [Note] InnoDB: 5.6.22 started; log sequence number 1626007
2015-01-08 11:37:51 19777 [ERROR] /usr/local/libexec/mysqld: unknown option '--skip-locking'
2015-01-08 11:37:51 19777 [ERROR] Aborting

2015-01-08 11:37:51 19777 [Note] Binlog end
2015-01-08 11:37:51 19777 [Note] Shutting down plugin 'partition'
2015-01-08 11:37:51 19777 [Note] Shutting down plugin 'ARCHIVE'
2015-01-08 11:37:51 19777 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-01-08 11:37:51 19777 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-01-08 11:37:51 19777 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-01-08 11:37:51 19777 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-01-08 11:37:51 19777 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-01-08 11:37:51 19777 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-01-08 11:37:51 19777 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-01-08 11:37:51 19777 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-01-08 11:37:51 19777 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-01-08 11:37:51 19777 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-01-08 11:37:51 19777 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-01-08 11:37:51 19777 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-01-08 11:37:51 19777 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-01-08 11:37:51 19777 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-01-08 11:37:51 19777 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-01-08 11:37:51 19777 [Note] Shutting down plugin 'INNODB_METRICS'
2015-01-08 11:37:51 19777 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-01-08 11:37:51 19777 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-01-08 11:37:51 19777 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-01-08 11:37:51 19777 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-01-08 11:37:51 19777 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-01-08 11:37:51 19777 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-01-08 11:37:51 19777 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-01-08 11:37:51 19777 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-01-08 11:37:51 19777 [Note] Shutting down plugin 'INNODB_CMP'
2015-01-08 11:37:51 19777 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-01-08 11:37:51 19777 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-01-08 11:37:51 19777 [Note] Shutting down plugin 'INNODB_TRX'
2015-01-08 11:37:51 19777 [Note] Shutting down plugin 'InnoDB'
2015-01-08 11:37:51 19777 [Note] InnoDB: FTS optimize thread exiting.
2015-01-08 11:37:51 19777 [Note] InnoDB: Starting shutdown...
2015-01-08 11:37:52 19777 [Note] InnoDB: Shutdown completed; log sequence number 1626017
2015-01-08 11:37:52 19777 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-01-08 11:37:52 19777 [Note] Shutting down plugin 'BLACKHOLE'
2015-01-08 11:37:52 19777 [Note] Shutting down plugin 'MyISAM'
2015-01-08 11:37:52 19777 [Note] Shutting down plugin 'CSV'
2015-01-08 11:37:52 19777 [Note] Shutting down plugin 'MRG_MYISAM'
2015-01-08 11:37:52 19777 [Note] Shutting down plugin 'MEMORY'
2015-01-08 11:37:52 19777 [Note] Shutting down plugin 'sha256_password'
2015-01-08 11:37:52 19777 [Note] Shutting down plugin 'mysql_old_password'
2015-01-08 11:37:52 19777 [Note] Shutting down plugin 'mysql_native_password'
2015-01-08 11:37:52 19777 [Note] Shutting down plugin 'binlog'
2015-01-08 11:37:52 19777 [Note] /usr/local/libexec/mysqld: Shutdown complete

150108 11:37:52 mysqld_safe mysqld from pid file /var/db/mysql/WebServer.pid ended

[Rus]

установил 5,1 запустился вроде норм пока

[Rus]

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

Код: Выделить всё

150108 17:43:03 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2015-01-08 17:43:03 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-01-08 17:43:03 94079 [Note] Plugin 'FEDERATED' is disabled.
2015-01-08 17:43:04 94079 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-01-08 17:43:04 94079 [Note] InnoDB: The InnoDB memory heap is disabled
2015-01-08 17:43:04 94079 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-01-08 17:43:04 94079 [Note] InnoDB: Memory barrier is not used
2015-01-08 17:43:04 94079 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-01-08 17:43:04 94079 [Note] InnoDB: Not using CPU crc32 instructions
2015-01-08 17:43:04 94079 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-01-08 17:43:04 94079 [Note] InnoDB: Completed initialization of buffer pool
2015-01-08 17:43:04 94079 [Note] InnoDB: Highest supported file format is Barracuda.
2015-01-08 17:43:04 94079 [Note] InnoDB: 128 rollback segment(s) are active.
2015-01-08 17:43:04 94079 [Note] InnoDB: Waiting for purge to start
2015-01-08 17:43:04 94079 [Note] InnoDB: 5.6.22 started; log sequence number 1626646
2015-01-08 17:43:04 94079 [ERROR] /usr/local/libexec/mysqld: unknown option '--skip-locking'
2015-01-08 17:43:04 94079 [ERROR] Aborting

2015-01-08 17:43:04 94079 [Note] Binlog end
2015-01-08 17:43:04 94079 [Note] Shutting down plugin 'partition'
2015-01-08 17:43:04 94079 [Note] Shutting down plugin 'ARCHIVE'
2015-01-08 17:43:04 94079 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-01-08 17:43:04 94079 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-01-08 17:43:04 94079 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-01-08 17:43:04 94079 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-01-08 17:43:04 94079 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-01-08 17:43:04 94079 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-01-08 17:43:04 94079 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-01-08 17:43:04 94079 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-01-08 17:43:04 94079 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-01-08 17:43:04 94079 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-01-08 17:43:04 94079 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-01-08 17:43:04 94079 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-01-08 17:43:04 94079 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-01-08 17:43:04 94079 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-01-08 17:43:04 94079 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-01-08 17:43:04 94079 [Note] Shutting down plugin 'INNODB_METRICS'
2015-01-08 17:43:04 94079 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-01-08 17:43:04 94079 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-01-08 17:43:04 94079 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-01-08 17:43:04 94079 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-01-08 17:43:04 94079 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-01-08 17:43:04 94079 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-01-08 17:43:04 94079 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-01-08 17:43:04 94079 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-01-08 17:43:04 94079 [Note] Shutting down plugin 'INNODB_CMP'
2015-01-08 17:43:04 94079 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-01-08 17:43:04 94079 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-01-08 17:43:04 94079 [Note] Shutting down plugin 'INNODB_TRX'
2015-01-08 17:43:04 94079 [Note] Shutting down plugin 'InnoDB'
2015-01-08 17:43:04 94079 [Note] InnoDB: FTS optimize thread exiting.
2015-01-08 17:43:04 94079 [Note] InnoDB: Starting shutdown...
2015-01-08 17:43:05 94079 [Note] InnoDB: Shutdown completed; log sequence number 1626656
2015-01-08 17:43:05 94079 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-01-08 17:43:05 94079 [Note] Shutting down plugin 'BLACKHOLE'
2015-01-08 17:43:05 94079 [Note] Shutting down plugin 'MyISAM'
2015-01-08 17:43:05 94079 [Note] Shutting down plugin 'CSV'
2015-01-08 17:43:05 94079 [Note] Shutting down plugin 'MRG_MYISAM'
2015-01-08 17:43:05 94079 [Note] Shutting down plugin 'MEMORY'
2015-01-08 17:43:05 94079 [Note] Shutting down plugin 'sha256_password'
2015-01-08 17:43:05 94079 [Note] Shutting down plugin 'mysql_old_password'
2015-01-08 17:43:05 94079 [Note] Shutting down plugin 'mysql_native_password'
2015-01-08 17:43:05 94079 [Note] Shutting down plugin 'binlog'
2015-01-08 17:43:05 94079 [Note] /usr/local/libexec/mysqld: Shutdown complete

[Rus]

если удалить my.cnf то запускается все в логе пишется

Код: Выделить всё

150108 17:49:47 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2015-01-08 17:49:49 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-01-08 17:49:49 94281 [Note] Plugin 'FEDERATED' is disabled.
2015-01-08 17:49:49 94281 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-01-08 17:49:49 94281 [Note] InnoDB: The InnoDB memory heap is disabled
2015-01-08 17:49:49 94281 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-01-08 17:49:49 94281 [Note] InnoDB: Memory barrier is not used
2015-01-08 17:49:49 94281 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-01-08 17:49:49 94281 [Note] InnoDB: Not using CPU crc32 instructions
2015-01-08 17:49:49 94281 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-01-08 17:49:49 94281 [Note] InnoDB: Completed initialization of buffer pool
2015-01-08 17:49:49 94281 [Note] InnoDB: Highest supported file format is Barracuda.
2015-01-08 17:49:49 94281 [Note] InnoDB: 128 rollback segment(s) are active.
2015-01-08 17:49:49 94281 [Note] InnoDB: Waiting for purge to start
2015-01-08 17:49:49 94281 [Note] InnoDB: 5.6.22 started; log sequence number 1626656
2015-01-08 17:49:49 94281 [Note] Server hostname (bind-address): '*'; port: 3306
2015-01-08 17:49:49 94281 [Note] IPv6 is available.
2015-01-08 17:49:49 94281 [Note]   - '::' resolves to '::';
2015-01-08 17:49:49 94281 [Note] Server socket created on IP: '::'.
2015-01-08 17:49:49 94281 [Note] Event Scheduler: Loaded 0 events
2015-01-08 17:49:49 94281 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.6.22'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

[FiL]

в логе единственная строчка с ERROR -

2015-01-08 17:43:04 94079 [ERROR] /usr/local/libexec/mysqld: unknown option '--skip-locking'

Неужели знания английского (хотя б и со словарем) не хватает, чтоб понять что в ней написано?

[Rus]

спасибо исправил
а что означает эта строка как исправить ее

Код: Выделить всё

[Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details)

[FiL]

Значит, что в новой версии мускула значение по умолчанию для TIMESTAMP не указанное явно не будет установлено, как было в предыдущих версиях.
Пока можно включить режим совместимости с помощью указанной опции. Что будет дальше не ясно.

[Rus]

Спасибо большое с этим разобрался теперь новый вопрос устанавливаю заббикс все встало норм пытаюсь создать бд , все норм создалось но когда делаю это выходит ошибка типа таблиц нет как создать подскажите плиз

Код: Выделить всё

root@WebServer:/usr/local/share/zabbix24/server/database/mysql # cat data.sql images.sql schema.sql | mysql -u root -p zabbix ;
Enter password:
ERROR 1146 (42S02) at line 2: Table 'zabbix.hosts' doesn't exist

[snorlov]

А вы правильно последовательность sql файлов указали? попробуйте поодиночке файлики подсовывать, таблицы наверное в скрипте shema.sql создаются...

[Rus]

Спасибо большое все получилось про последовательность даже и не подумал.

[FiL]

a не надо думать, надо делать так, как в инструкции написано.
https://www.zabbix.com/documentation/2. ... db_scripts

[Роман Мартин]

У mysql56 щоб почав наповнюватись файл mysql.log потрібно додати такі дві стрічки у
my.cnf
general_log = 1
general_log_file = /var/log/mysql.log

[Alex Keda]

чобля?