Windows非法關機之后，重啟mysql，一直顯示1053錯誤，修改了登錄權限也是一樣，一直顯示錯誤。
2017-03-27T05:35:43.948253Z 0 [Warning] option 'max_allowed_packet': unsigned value 4 adjusted to 1024
2017-03-27T05:35:43.948253Z 0 [Warning] option 'max_allowed_packet': unsigned value 2097152000 adjusted to 1073741824
2017-03-27T05:35:43.948253Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-03-27T05:35:43.948253Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2017-03-27T05:35:43.948253Z 0 [Note] mysqld.exe (mysqld 5.7.9-log) starting as process 692 ...
2017-03-27T05:35:43.963877Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-03-27T05:35:43.979694Z 0 [Note] InnoDB: Uses event mutexes
2017-03-27T05:35:43.979694Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-03-27T05:35:43.979694Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-03-27T05:35:43.979694Z 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB
2017-03-27T05:35:43.995146Z 0 [Note] InnoDB: Number of pools: 1
2017-03-27T05:35:43.995146Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2017-03-27T05:35:44.167004Z 0 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M
2017-03-27T05:35:44.167004Z 0 [Note] InnoDB: Completed initialization of buffer pool
2017-03-27T05:35:44.198253Z 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2017-03-27T05:35:44.198253Z 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2017-03-27T05:35:44.198253Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2017-03-27T05:35:44.323253Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2017-03-27T05:35:44.323253Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-03-27T05:35:44.338877Z 0 [ERROR] Failed to initialize plugins.
2017-03-27T05:35:44.338877Z 0 [ERROR] Aborting
2017-03-27T05:35:44.370131Z 0 [Note] Binlog end
2017-03-27T05:35:44.401380Z 0 [Note] Shutting down plugin 'CSV'
2017-03-27T05:35:44.463880Z 0 [Note] mysqld.exe: Shutdown complete
uj5u.com熱心網友回復：
以前正常，那一般不會是ibdata1本身權限的問題，可以試試看把 ib_logfile開頭的檔案（一般是2個）改個名，然后看看能否啟動起來，如果可以啟動。uj5u.com熱心網友回復：
請問改名行嗎轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/31675.html
標籤：MySQL
上一篇：MySQL安裝程序GROUP REPLICATON只顯示框框，無法next下一步，請問各位大神如何解決
下一篇：求助求助