Scene description:
Ubantu 16.04 + mysql 5.7.27
Abnormal description:
Successful installation the mysql, but execute the following service mysql start to appear abnormal
Root @ asa - root:/var/log/mysql# sudo service mysql start
Start: Job failed to start
Root @ asa - root:/var/log/mysql# cat error log
The T09:2019-10-09 10:56. 460877 z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Do use - explicit_defaults_for_timestamp server option (see documentation for more details).
The T09:2019-10-09 10:56. 463156 z 0 [Note]/usr/sbin/mysqld (mysqld 5.7.27-0 ubuntu0. 16.04.1 - log) starting as the process of 4751...
The T09:2019-10-09 10:56. 468777 z 0 [Note] InnoDB: PUNCH HOLE support available
The T09:2019-10-09 10:56. 468802 z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
The T09:2019-10-09 10:56. 468808 z 0 [Note] InnoDB: Uses the event mutexes
The T09:2019-10-09 10:56. 468813 z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence () is 2 for the memory barrier
The T09:2019-10-09 10:56. 468817 z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
The T09:2019-10-09 10:56. 468822 z 0 [Note] InnoDB: Using Linux native AIO
The T09:2019-10-09 10:56. 469359 z 0 [Note] InnoDB: Number of pools: 1
The T09:2019-10-09 10:56. 469486 z 0 [Note] InnoDB: Using CPU crc32 instructions
The T09:2019-10-09 10:56. 471560 z 0 [Note] InnoDB: Initializing buffer pool, the total size=16 m, instances=1, the chunk size=16 m
The T09:2019-10-09 10:56. 473269 z 0 [Note] InnoDB: Completed initialization of buffer pool
The T09:2019-10-09 10:56. 473895 z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority ().
The 2019-10-09 T09:10:56. 483896 z 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' is not a regular The InnoDB data file.
The 2019-10-09 T09:10:56. 483912 z 0 [ERROR] InnoDB: Plugin initialization aborted with ERROR Generic ERROR
The 2019-10-09 T09:10:57. 084354 z 0 [ERROR] Plugin 'InnoDB init function returned ERROR.
The 2019-10-09 T09:10:57. 084392 z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
The 2019-10-09 T09:10:57. 084399 z 0 [ERROR] Failed to initialize builtin plugins.
The 2019-10-09 T09:10:57. 084402 z 0 [ERROR] Aborting
The 2019-10-09 T09:10:57. 084421 z 0 [Note] Binlog end
The 2019-10-09 T09:10:57. 084482 z 0 [Note] Shutting down the plugin 'CSV'
The 2019-10-09 T09:10:57. 084488 z 0 [Note] Shutting down the plugin 'MyISAM'
The 2019-10-09 T09:10:57. 084910 z 0 [Note]/usr/sbin/mysqld: Shutdown complete