莫名其妙无法启动了,在面板后台怎么启动都不行。
windows服务启动报错如下:
本地计算机上的mysql服务启动后停止,某些服务在未由其他服务或程序使用时将自动停止
myslq报错信息日志如下:
2021-01-07T12:27:32.162301Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2021-01-07T12:27:32.162489Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2021-01-07T12:27:32.162768Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2021-01-07T12:27:32.162959Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2021-01-07T12:27:32.163172Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2021-01-07T12:27:32.163355Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2021-01-07T12:27:32.163558Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2021-01-07T12:27:32.163807Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2021-01-07T12:27:32.164010Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2021-01-07T12:27:32.164203Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2021-01-07T12:27:32.164415Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2021-01-07T12:27:32.164655Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2021-01-07T12:27:32.164883Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2021-01-07T12:27:32.165065Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2021-01-07T12:27:32.165253Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2021-01-07T12:27:32.165427Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2021-01-07T12:27:32.165674Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2021-01-07T12:27:32.166076Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2021-01-07T12:27:32.166566Z 0 [Note] Shutting down plugin 'InnoDB'
2021-01-07T12:27:32.166842Z 0 [Note] InnoDB: FTS optimize thread exiting.
2021-01-07T12:27:32.167156Z 0 [Note] InnoDB: Starting shutdown...
2021-01-07T12:27:32.268374Z 0 [Note] InnoDB: Dumping buffer pool(s) to F:\BtSoft\mysql\MySQL5.7\data\ib_buffer_pool
2021-01-07T12:27:32.269940Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 210107 20:27:32
2021-01-07T12:27:33.456513Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2530803
2021-01-07T12:27:33.457285Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-01-07T12:27:33.457590Z 0 [Note] Shutting down plugin 'MEMORY'
2021-01-07T12:27:33.457763Z 0 [Note] Shutting down plugin 'CSV'
2021-01-07T12:27:33.457930Z 0 [Note] Shutting down plugin 'sha256_password'
2021-01-07T12:27:33.458124Z 0 [Note] Shutting down plugin 'mysql_native_password'
2021-01-07T12:27:33.458428Z 0 [Note] Shutting down plugin 'binlog'
2021-01-07T12:27:33.475139Z 0 [Note] F:\BtSoft\mysql\MySQL5.7\bin\mysqld.exe: Shutdown complete
2021-01-07T12:27:34.472624Z 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.
2021-01-07T12:27:34.473063Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2021-01-07T12:27:34.473891Z 0 [Note] F:\BtSoft\mysql\MySQL5.7\bin\mysqld.exe (mysqld 5.7.26) starting as process 10704 ...
2021-01-07T12:27:34.523747Z 0 [Warning] option 'innodb-log-buffer-size': signed value 0 adjusted to 262144
2021-01-07T12:27:34.524618Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-01-07T12:27:34.525025Z 0 [Note] InnoDB: Uses event mutexes
2021-01-07T12:27:34.525333Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2021-01-07T12:27:34.526455Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-01-07T12:27:34.527305Z 0 [Note] InnoDB: Number of pools: 1
2021-01-07T12:27:34.527706Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2021-01-07T12:27:34.530678Z 0 [Note] InnoDB: Initializing buffer pool, total size = 1G, instances = 8, chunk size = 128M
2021-01-07T12:27:34.581722Z 0 [Note] InnoDB: Completed initialization of buffer pool
2021-01-07T12:27:34.654671Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2021-01-07T12:27:34.859211Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-01-07T12:27:34.859936Z 0 [Note] InnoDB: Setting file 'F:\BtSoft\mysql\MySQL5.7\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-01-07T12:27:35.101255Z 0 [Note] InnoDB: File 'F:\BtSoft\mysql\MySQL5.7\data\ibtmp1' size is now 12 MB.
2021-01-07T12:27:35.103187Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2021-01-07T12:27:35.103992Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2021-01-07T12:27:35.105025Z 0 [Note] InnoDB: Waiting for purge to start
2021-01-07T12:27:35.161936Z 0 [Note] InnoDB: 5.7.26 started; log sequence number 2530803
2021-01-07T12:27:35.162583Z 0 [Note] InnoDB: Loading buffer pool(s) from F:\BtSoft\mysql\MySQL5.7\data\ib_buffer_pool
2021-01-07T12:27:35.162634Z 0 [Note] Plugin 'FEDERATED' is disabled.
2021-01-07T12:27:35.197033Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2021-01-07T12:27:35.197810Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2021-01-07T12:27:35.198656Z 0 [Note] IPv6 is available.
2021-01-07T12:27:35.198882Z 0 [Note] - '::' resolves to '::';
2021-01-07T12:27:35.199238Z 0 [Note] Server socket created on IP: '::'.
2021-01-07T12:27:35.217328Z 0 [Note] InnoDB: Buffer pool(s) load completed at 210107 20:27:35
2021-01-07T12:27:35.218856Z 0 [ERROR] F:\BtSoft\mysql\MySQL5.7\bin\mysqld.exe: Table '.\mysql\user' is marked as crashed and should be repaired
2021-01-07T12:27:35.219412Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table '.\mysql\user' is marked as crashed and should be repaired
2021-01-07T12:27:35.219883Z 0 [ERROR] Fatal error: Failed to initialize ACL/grant/time zones structures or failed to remove temporary table files.
2021-01-07T12:27:35.220806Z 0 [ERROR] Aborting
2021-01-07T12:27:35.220957Z 0 [Note] Binlog end
2021-01-07T12:27:35.224814Z 0 [Note] Shutting down plugin 'ngram'
2021-01-07T12:27:35.224982Z 0 [Note] Shutting down plugin 'partition'
2021-01-07T12:27:35.225155Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2021-01-07T12:27:35.225369Z 0 [Note] Shutting down plugin 'ARCHIVE'
2021-01-07T12:27:35.225536Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2021-01-07T12:27:35.225757Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2021-01-07T12:27:35.225935Z 0 [Note] Shutting down plugin 'MyISAM'
2021-01-07T12:27:35.226110Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2021-01-07T12:27:35.226411Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2021-01-07T12:27:35.226611Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2021-01-07T12:27:35.226815Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2021-01-07T12:27:35.227021Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2021-01-07T12:27:35.227262Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2021-01-07T12:27:35.227453Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2021-01-07T12:27:35.227647Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2021-01-07T12:27:35.227841Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2021-01-07T12:27:35.228043Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2021-01-07T12:27:35.228342Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2021-01-07T12:27:35.228565Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2021-01-07T12:27:35.228769Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2021-01-07T12:27:35.228959Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2021-01-07T12:27:35.229295Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2021-01-07T12:27:35.229553Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2021-01-07T12:27:35.230108Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2021-01-07T12:27:35.230508Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2021-01-07T12:27:35.231075Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2021-01-07T12:27:35.231568Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2021-01-07T12:27:35.232045Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2021-01-07T12:27:35.232361Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2021-01-07T12:27:35.232574Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2021-01-07T12:27:35.232772Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2021-01-07T12:27:35.232968Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2021-01-07T12:27:35.233149Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2021-01-07T12:27:35.233340Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2021-01-07T12:27:35.233514Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2021-01-07T12:27:35.233705Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2021-01-07T12:27:35.233883Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2021-01-07T12:27:35.234057Z 0 [Note] Shutting down plugin 'InnoDB'
2021-01-07T12:27:35.234351Z 0 [Note] InnoDB: FTS optimize thread exiting.
2021-01-07T12:27:35.234669Z 0 [Note] InnoDB: Starting shutdown...
2021-01-07T12:27:35.336064Z 0 [Note] InnoDB: Dumping buffer pool(s) to F:\BtSoft\mysql\MySQL5.7\data\ib_buffer_pool
2021-01-07T12:27:35.337883Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 210107 20:27:35
2021-01-07T12:27:36.841657Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2530838
2021-01-07T12:27:36.842515Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-01-07T12:27:36.842805Z 0 [Note] Shutting down plugin 'MEMORY'
2021-01-07T12:27:36.842978Z 0 [Note] Shutting down plugin 'CSV'
2021-01-07T12:27:36.843147Z 0 [Note] Shutting down plugin 'sha256_password'
2021-01-07T12:27:36.843343Z 0 [Note] Shutting down plugin 'mysql_native_password'
2021-01-07T12:27:36.843752Z 0 [Note] Shutting down plugin 'binlog'
2021-01-07T12:27:36.861037Z 0 [Note] F:\BtSoft\mysql\MySQL5.7\bin\mysqld.exe: Shutdown complete
2021-01-07T12:27:37.497139Z 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.
2021-01-07T12:27:37.497204Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2021-01-07T12:27:37.497654Z 0 [Note] F:\BtSoft\mysql\MySQL5.7\bin\mysqld.exe (mysqld 5.7.26) starting as process 7348 ...
2021-01-07T12:27:37.540265Z 0 [Warning] option 'innodb-log-buffer-size': signed value 0 adjusted to 262144
2021-01-07T12:27:37.541236Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-01-07T12:27:37.541745Z 0 [Note] InnoDB: Uses event mutexes
2021-01-07T12:27:37.541998Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2021-01-07T12:27:37.542331Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-01-07T12:27:37.543003Z 0 [Note] InnoDB: Number of pools: 1
2021-01-07T12:27:37.543341Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2021-01-07T12:27:37.546651Z 0 [Note] InnoDB: Initializing buffer pool, total size = 1G, instances = 8, chunk size = 128M
2021-01-07T12:27:37.597028Z 0 [Note] InnoDB: Completed initialization of buffer pool
2021-01-07T12:27:37.699376Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2021-01-07T12:27:37.856328Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-01-07T12:27:37.856990Z 0 [Note] InnoDB: Setting file 'F:\BtSoft\mysql\MySQL5.7\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-01-07T12:27:38.046143Z 0 [Note] InnoDB: File 'F:\BtSoft\mysql\MySQL5.7\data\ibtmp1' size is now 12 MB.
2021-01-07T12:27:38.048348Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2021-01-07T12:27:38.048805Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2021-01-07T12:27:38.049485Z 0 [Note] InnoDB: Waiting for purge to start
2021-01-07T12:27:38.100854Z 0 [Note] InnoDB: 5.7.26 started; log sequence number 2530838
2021-01-07T12:27:38.101558Z 0 [Note] Plugin 'FEDERATED' is disabled.
2021-01-07T12:27:38.101629Z 0 [Note] InnoDB: Loading buffer pool(s) from F:\BtSoft\mysql\MySQL5.7\data\ib_buffer_pool
2021-01-07T12:27:38.141225Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2021-01-07T12:27:38.142096Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2021-01-07T12:27:38.143110Z 0 [Note] IPv6 is available.
2021-01-07T12:27:38.143437Z 0 [Note] - '::' resolves to '::';
2021-01-07T12:27:38.143743Z 0 [Note] Server socket created on IP: '::'.
2021-01-07T12:27:38.162313Z 0 [Note] InnoDB: Buffer pool(s) load completed at 210107 20:27:38
2021-01-07T12:27:38.164879Z 0 [ERROR] F:\BtSoft\mysql\MySQL5.7\bin\mysqld.exe: Table '.\mysql\user' is marked as crashed and should be repaired
2021-01-07T12:27:38.165706Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table '.\mysql\user' is marked as crashed and should be repaired
2021-01-07T12:27:38.166749Z 0 [ERROR] Fatal error: Failed to initialize ACL/grant/time zones structures or failed to remove temporary table files.
2021-01-07T12:27:38.167629Z 0 [ERROR] Aborting
2021-01-07T12:27:38.167794Z 0 [Note] Binlog end
2021-01-07T12:27:38.171540Z 0 [Note] Shutting down plugin 'ngram'
2021-01-07T12:27:38.171724Z 0 [Note] Shutting down plugin 'partition'
2021-01-07T12:27:38.171904Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2021-01-07T12:27:38.172084Z 0 [Note] Shutting down plugin 'ARCHIVE'
2021-01-07T12:27:38.172313Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2021-01-07T12:27:38.172542Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2021-01-07T12:27:38.172727Z 0 [Note] Shutting down plugin 'MyISAM'
2021-01-07T12:27:38.172909Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2021-01-07T12:27:38.173112Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2021-01-07T12:27:38.173320Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2021-01-07T12:27:38.173649Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2021-01-07T12:27:38.173932Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2021-01-07T12:27:38.174160Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2021-01-07T12:27:38.174390Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2021-01-07T12:27:38.174595Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2021-01-07T12:27:38.174796Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2021-01-07T12:27:38.175006Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2021-01-07T12:27:38.175209Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2021-01-07T12:27:38.175480Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2021-01-07T12:27:38.175688Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2021-01-07T12:27:38.175883Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2021-01-07T12:27:38.176095Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2021-01-07T12:27:38.176360Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2021-01-07T12:27:38.176580Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2021-01-07T12:27:38.176769Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2021-01-07T12:27:38.176979Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2021-01-07T12:27:38.177222Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2021-01-07T12:27:38.177451Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2021-01-07T12:27:38.177652Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2021-01-07T12:27:38.177872Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2021-01-07T12:27:38.178077Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2021-01-07T12:27:38.178281Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2021-01-07T12:27:38.178468Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2021-01-07T12:27:38.178665Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2021-01-07T12:27:38.178847Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2021-01-07T12:27:38.179046Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2021-01-07T12:27:38.179334Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2021-01-07T12:27:38.179519Z 0 [Note] Shutting down plugin 'InnoDB'
2021-01-07T12:27:38.179751Z 0 [Note] InnoDB: FTS optimize thread exiting.
2021-01-07T12:27:38.180041Z 0 [Note] InnoDB: Starting shutdown...
2021-01-07T12:27:38.281189Z 0 [Note] InnoDB: Dumping buffer pool(s) to F:\BtSoft\mysql\MySQL5.7\data\ib_buffer_pool
2021-01-07T12:27:38.282570Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 210107 20:27:38
2021-01-07T12:27:39.681241Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2530857
2021-01-07T12:27:39.682025Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-01-07T12:27:39.682266Z 0 [Note] Shutting down plugin 'MEMORY'
2021-01-07T12:27:39.682434Z 0 [Note] Shutting down plugin 'CSV'
2021-01-07T12:27:39.682592Z 0 [Note] Shutting down plugin 'sha256_password'
2021-01-07T12:27:39.682824Z 0 [Note] Shutting down plugin 'mysql_native_password'
2021-01-07T12:27:39.683116Z 0 [Note] Shutting down plugin 'binlog'
2021-01-07T12:27:39.698258Z 0 [Note] F:\BtSoft\mysql\MySQ