データーベースが起動しない

Question

データベースが起動できなくなりました。
ワークベンチから起動しようとすると以下のようなエラーメッセージが出てしまいます。

使用OS:linuxBean

2016-10-17 19:15:44 - Checked server status: Server is stopped.
2016-10-17 19:15:47 - Checked server status: Server is stopped.
2016-10-17 19:15:47 - Starting server...
2016-10-17 19:15:47 - Executting 'start mysql'
2016-10-17 19:15:54 - Start server: start: Job failed to start

2016-10-17 19:15:54 - Checked server status: Server is stopped.

FROM /var/log/mysql/error.log:
2016-10-17 19:15:47 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
2016-10-17 19:15:48 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
2016-10-17 19:15:48 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2016-10-17 19:15:48 InnoDB: The InnoDB memory heap is disabled
2016-10-17 19:15:48 InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-10-17 19:15:48 InnoDB: Compressed tables use zlib 1.2.8
2016-10-17 19:15:48 InnoDB: Using Linux native AIO
2016-10-17 19:15:48 InnoDB: Initializing buffer pool, size = 128.0M
2016-10-17 19:15:48 InnoDB: Completed initialization of buffer pool
2016-10-17 19:15:48 InnoDB: highest supported file format is Barracuda.
2016-10-17 19:15:49 InnoDB: Waiting for the background threads to start
2016-10-17 19:15:50 InnoDB: 5.5.52 started; log sequence number 8991321351
2016-10-17 19:15:50 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2016-10-17 19:15:50 [Note] - '127.0.0.1' resolves to '127.0.0.1';
2016-10-17 19:15:50 [Note] Server socket created on IP: '127.0.0.1'.
2016-10-17 19:15:50 [ERROR] Fatal error: mysql.user table is damaged or in unsupported 3.20 format.
2016-10-17 19:15:51 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
2016-10-17 19:15:51 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
2016-10-17 19:15:51 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2016-10-17 19:15:51 InnoDB: The InnoDB memory heap is disabled
2016-10-17 19:15:51 InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-10-17 19:15:51 InnoDB: Compressed tables use zlib 1.2.8
2016-10-17 19:15:51 InnoDB: Using Linux native AIO
2016-10-17 19:15:51 InnoDB: Initializing buffer pool, size = 128.0M
2016-10-17 19:15:51 InnoDB: Completed initialization of buffer pool
2016-10-17 19:15:51 InnoDB: highest supported file format is Barracuda.
2016-10-17 19:15:51 InnoDB: Waiting for the background threads to start
2016-10-17 19:15:52 InnoDB: 5.5.52 started; log sequence number 8991321351
2016-10-17 19:15:52 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2016-10-17 19:15:52 [Note] - '127.0.0.1' resolves to '127.0.0.1';
2016-10-17 19:15:52 [Note] Server socket created on IP: '127.0.0.1'.
2016-10-17 19:15:52 [ERROR] Fatal error: mysql.user table is damaged or in unsupported 3.20 format.
2016-10-17 19:15:53 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
2016-10-17 19:15:53 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
2016-10-17 19:15:53 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2016-10-17 19:15:53 InnoDB: The InnoDB memory heap is disabled
2016-10-17 19:15:53 InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-10-17 19:15:53 InnoDB: Compressed tables use zlib 1.2.8
2016-10-17 19:15:53 InnoDB: Using Linux native AIO
2016-10-17 19:15:53 InnoDB: Initializing buffer pool, size = 128.0M
2016-10-17 19:15:53 InnoDB: Completed initialization of buffer pool
2016-10-17 19:15:53 InnoDB: highest supported file format is Barracuda.
2016-10-17 19:15:53 InnoDB: Waiting for the background threads to start
2016-10-17 19:15:54 InnoDB: 5.5.52 started; log sequence number 8991321351
2016-10-17 19:15:54 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2016-10-17 19:15:54 [Note] - '127.0.0.1' resolves to '127.0.0.1';
2016-10-17 19:15:54 [Note] Server socket created on IP: '127.0.0.1'.
2016-10-17 19:15:54 [ERROR] Fatal error: mysql.user table is damaged or in unsupported 3.20 format.
2016-10-17 19:15:54 - Server start done.
2016-10-17 19:15:54 - Checked server status: Server is stopped.

Comments

[AKST]

何を行なって、起動しなくなったのかなど、記載した方が良いかと思います。(恐らくバージョンアップ等だと思いますが

[scrollman]

一度サーバーを意図的に停止させました、それから起動できなくなりました。

Answer 1

tavatarさんのコメントにかぶりますが、MySQL5.7が起動しないトラブル に

mysql_safe --skip-grant-tables --user=[ユーザ名] &

壊れたテーブルを読まずに起動できる、、
これでとりあえずセーフモードで起動できたのでmysql_update実行してテーブル修復。あとはいくつかWordPress周りのテーブルがエラーになったので、そこはmysqlクライアント上で普通にREPAIR TABLEで修復。

修復できないテーブルがあればバックアップから戻すのかも？
バックアップは取っていますよね？

Answer 2

決して英語得意ではありませんが、
下記サイトに、

mysql_fix_privilege_tables

を実行してみて、たぶん起動出来なくなるので、

mysqld_safe –skip-grant-tables –user=root &
mysql_fix_privilege_tables
pkill mysqld
/etc/init.d/mysqld restart

を走らせるといいよ、と書いているような気がします。

参考：
https://john-hunt.com/2006/05/12/mysql-upgrade-breaking-things/

Comments

[退会済みユーザー]

間違ってたらすみません。

Answer 3

質問時はたまうちゃあたる方式であれこれ適当にやりまくりました。
どの弾があたったのか分からないのですが、その時は復旧できました。

あたった弾について思いだすことは不可能です。
愚かな質問に答えてくださった回答者様ありがとうございました。