MySQL не стартует на CentOS 7

[za1]

Добрый день. Много раз переустанавливал скуль в системе, однако результат один и тотже. Пробовал и МарияДБ ставить, не помогает.


[root@localhost ~]# yum install mysql-server
Loaded plugins: fastestmirror
base | 3.6 kB 00:00:00
extras | 3.4 kB 00:00:00
mysql-connectors-community | 2.5 kB 00:00:00
mysql-tools-community | 2.5 kB 00:00:00
mysql56-community | 2.5 kB 00:00:00
updates | 3.4 kB 00:00:00
Loading mirror speeds from cached hostfile
* base: mirror.yandex.ru
* extras: mirror.yandex.ru
* updates: mirror.yandex.ru
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-server.x86_64 0:5.6.27-2.el7 will be installed
--> Processing Dependency: mysql-community-client(x86-64) = 5.6.27-2.el7 for package: mysql-community-server-5.6.27-2.el7.x86_64
--> Running transaction check
---> Package mysql-community-client.x86_64 0:5.6.27-2.el7 will be installed
--> Processing Dependency: mysql-community-libs(x86-64) = 5.6.27-2.el7 for package: mysql-community-client-5.6.27-2.el7.x86_64
--> Running transaction check
---> Package mysql-community-libs.x86_64 0:5.6.27-2.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

==================================================================================================== =========================================================
Package Arch Version Repository Size
==================================================================================================== =========================================================
Installing:
mysql-community-server x86_64 5.6.27-2.el7 mysql56-community 58 M
Installing for dependencies:
mysql-community-client x86_64 5.6.27-2.el7 mysql56-community 19 M
mysql-community-libs x86_64 5.6.27-2.el7 mysql56-community 2.0 M

Transaction Summary
==================================================================================================== =========================================================
Install 1 Package (+2 Dependent packages)

Total download size: 79 M
Installed size: 342 M
Is this ok [y/d/N]: y
Downloading packages:
(1/3): mysql-community-libs-5.6.27-2.el7.x86_64.rpm | 2.0 MB 00:00:05
(2/3): mysql-community-client-5.6.27-2.el7.x86_64.rpm | 19 MB 00:00:29
(3/3): mysql-community-server-5.6.27-2.el7.x86_64.rpm | 58 MB 00:01:08
-------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 1.1 MB/s | 79 MB 00:01:13
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : mysql-community-libs-5.6.27-2.el7.x86_64 1/3
Installing : mysql-community-client-5.6.27-2.el7.x86_64 2/3
Installing : mysql-community-server-5.6.27-2.el7.x86_64 3/3
Verifying : mysql-community-server-5.6.27-2.el7.x86_64 1/3
Verifying : mysql-community-client-5.6.27-2.el7.x86_64 2/3
Verifying : mysql-community-libs-5.6.27-2.el7.x86_64 3/3

Installed:
mysql-community-server.x86_64 0:5.6.27-2.el7

Dependency Installed:
mysql-community-client.x86_64 0:5.6.27-2.el7 mysql-community-libs.x86_64 0:5.6.27-2.el7

Complete!
[root@localhost ~]# systemctl status mysqld
mysqld.service - MySQL Community Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled)
Active: inactive (dead)

Oct 30 04:51:39 localhost.localdomain systemd[1]: Failed to start MySQL Community Server.
Oct 30 04:51:39 localhost.localdomain systemd[1]: Unit mysqld.service entered failed state.
Oct 30 04:51:39 localhost.localdomain systemd[1]: mysqld.service holdoff time over, scheduling restart.
Oct 30 04:51:39 localhost.localdomain systemd[1]: Stopping MySQL Community Server...
Oct 30 04:51:39 localhost.localdomain systemd[1]: Starting MySQL Community Server...
Oct 30 04:51:39 localhost.localdomain mysqld_safe[18634]: 151030 04:51:39 mysqld_safe Logging to '/var/log/mysqld.log'.
Oct 30 04:51:40 localhost.localdomain mysqld_safe[18634]: 151030 04:51:40 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Oct 30 04:51:42 localhost.localdomain mysqld_safe[18634]: 151030 04:51:42 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
Oct 30 04:52:32 localhost.localdomain systemd[1]: Stopping MySQL Community Server...
Oct 30 04:52:32 localhost.localdomain systemd[1]: Stopped MySQL Community Server.
[root@localhost ~]# systemctl start mysqld
Job for mysqld.service failed. See 'systemctl status mysqld.service' and 'journalctl -xn' for details.

[root@localhost ~]# journalctl -xn
-- Logs begin at Thu 2015-10-29 11:41:02 EDT, end at Fri 2015-10-30 10:51:36 EDT. --
Oct 30 10:41:35 localhost.localdomain mysqld_safe[21142]: 151030 10:41:35 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
Oct 30 10:51:34 localhost.localdomain systemd[1]: mysqld.service operation timed out. Stopping.
Oct 30 10:51:34 localhost.localdomain systemd[1]: Failed to start MySQL Community Server.
-- Subject: Unit mysqld.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysqld.service has failed.
--
-- The result is failed.
Oct 30 10:51:34 localhost.localdomain systemd[1]: Unit mysqld.service entered failed state.
Oct 30 10:51:34 localhost.localdomain systemd[1]: mysqld.service holdoff time over, scheduling restart.
Oct 30 10:51:34 localhost.localdomain systemd[1]: Stopping MySQL Community Server...
-- Subject: Unit mysqld.service has begun shutting down
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysqld.service has begun shutting down.
Oct 30 10:51:34 localhost.localdomain systemd[1]: Starting MySQL Community Server...
-- Subject: Unit mysqld.service has begun with start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysqld.service has begun starting up.
Oct 30 10:51:35 localhost.localdomain mysqld_safe[23094]: 151030 10:51:35 mysqld_safe Logging to '/var/log/mysqld.log'.
Oct 30 10:51:35 localhost.localdomain mysqld_safe[23094]: 151030 10:51:35 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Oct 30 10:51:36 localhost.localdomain mysqld_safe[23094]: 151030 10:51:36 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

[MakaBooka]

cat /var/log/mysqld.log?

[za1]

выводит огромное количество информации, вся не помещается, но примерно повторяется это:


/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
2015-11-03 12:13:48 10810 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2015-11-03 12:13:48 10810 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-11-03 12:13:48 10810 [Note] InnoDB: The InnoDB memory heap is disabled
2015-11-03 12:13:48 10810 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-11-03 12:13:48 10810 [Note] InnoDB: Memory barrier is not used
2015-11-03 12:13:48 10810 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-11-03 12:13:48 10810 [Note] InnoDB: Using Linux native AIO
2015-11-03 12:13:48 10810 [Note] InnoDB: Not using CPU crc32 instructions
2015-11-03 12:13:48 10810 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-11-03 12:13:48 10810 [Note] InnoDB: Completed initialization of buffer pool
2015-11-03 12:13:48 10810 [Note] InnoDB: Highest supported file format is Barracuda.
2015-11-03 12:13:48 10810 [Note] InnoDB: 128 rollback segment(s) are active.
2015-11-03 12:13:48 10810 [Note] InnoDB: Waiting for purge to start
2015-11-03 12:13:49 10810 [Note] InnoDB: 5.6.27 started; log sequence number 1601679
2015-11-03 12:13:49 10810 [Note] Server hostname (bind-address): '*'; port: 3306
2015-11-03 12:13:49 10810 [Note] IPv6 is available.
2015-11-03 12:13:49 10810 [Note] - '::' resolves to '::';
2015-11-03 12:13:49 10810 [Note] Server socket created on IP: '::'.
2015-11-03 12:13:49 10810 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
151103 12:13:49 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
151103 12:23:48 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2015-11-03 12:23:49 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-11-03 12:23:49 0 [Note] /usr/sbin/mysqld (mysqld 5.6.27) starting as process 12763 ...
2015-11-03 12:23:49 12763 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000)

2015-11-03 12:23:49 12763 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000)

2015-11-03 12:23:49 12763 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
2015-11-03 12:23:49 12763 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2015-11-03 12:23:49 12763 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-11-03 12:23:49 12763 [Note] InnoDB: The InnoDB memory heap is disabled
2015-11-03 12:23:49 12763 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-11-03 12:23:49 12763 [Note] InnoDB: Memory barrier is not used
2015-11-03 12:23:49 12763 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-11-03 12:23:49 12763 [Note] InnoDB: Using Linux native AIO
2015-11-03 12:23:49 12763 [Note] InnoDB: Not using CPU crc32 instructions
2015-11-03 12:23:49 12763 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-11-03 12:23:49 12763 [Note] InnoDB: Completed initialization of buffer pool
2015-11-03 12:23:49 12763 [Note] InnoDB: Highest supported file format is Barracuda.
2015-11-03 12:23:49 12763 [Note] InnoDB: 128 rollback segment(s) are active.
2015-11-03 12:23:49 12763 [Note] InnoDB: Waiting for purge to start
2015-11-03 12:23:49 12763 [Note] InnoDB: 5.6.27 started; log sequence number 1601679
2015-11-03 12:23:49 12763 [Note] Server hostname (bind-address): '*'; port: 3306
2015-11-03 12:23:49 12763 [Note] IPv6 is available.
2015-11-03 12:23:49 12763 [Note] - '::' resolves to '::';
2015-11-03 12:23:49 12763 [Note] Server socket created on IP: '::'.
2015-11-03 12:23:49 12763 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
151103 12:23:49 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

[MakaBooka]

из логов видно, что дефолтной базы нет, initdb не проходил, пароль руту мускуля не выставлялся

[za1]

Спасибо за ответ. Проблема была изначально в том, что мускуль не запускался, и соответственно я не мог создать ни бд, ни чего вообще сделать. Позже выяснилось, что проблема в версии MySQL. Я пытался поставить 5.6, а корректно запускается 5.5. Скорее всего из-за подключенных репозиториев установить предыдущую версию не удалось, поэтому проблему решили радикально- создали новую виртуалку, поставили рабочий мускуль и радуемся жизни, ну там где это возможно.

[MakaBooka]

Проблема была изначально в том, что мускуль не запускался, и соответственно я не мог создать ни бд, ни чего вообще сделать »
первичную инициализацию делает как раз initdb крипт. по идее он должен вызываться при первой установке. лично сталкивался с различным пониманием "первой установки" мною и пакетным менеджером. но запустить скрипт руками никто не запрещает.