データベースが起動できなくなりました。
ワークベンチから起動しようとすると以下のようなエラーメッセージが出てしまいます。
使用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.
回答3件
あなたの回答
tips
プレビュー