12:44:27 0 Plugin 'FEEDBACK' is disabled. 12:44:27 0 InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool 12:44:26 0 InnoDB: Waiting for purge to start 12:44:26 0 InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB. Physically writing the file full Please wait. 12:44:26 0 InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. 12:44:26 0 InnoDB: Creating shared tablespace for temporary tables 12:44:26 0 InnoDB: 128 out of 128 rollback segments are active. 12:44:26 0 InnoDB: Completed initialization of buffer pool 12:44:26 0 InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M 12:44:26 0 InnoDB: Using SSE2 crc32 instructions 12:44:26 0 InnoDB: Compressed tables use zlib 1.2.11 12:44:26 0 InnoDB: Mutexes and rw_locks use Windows interlocked functions Please use the full name 'key_buffer_size' instead. When I tried above given solution, got following log in shell 12:44:26 0 Using unique option prefix 'key_buffer' is error-prone and can break in the future. Mysqld –-console –-skip-grant-tables –-skip-external-locking Solution 1:- Run MySQL with XAMPP shell with command : I tried many solutions but no one worked for me 12:01:07 0 Plugin 'FEEDBACK' is disabled. 12:01:07 0 InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool 12:01:07 0 InnoDB: Waiting for purge to start 12:01:07 0 InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB. 12:01:07 0 InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. 12:01:07 0 InnoDB: Creating shared tablespace for temporary tables 12:01:07 0 InnoDB: 128 out of 128 rollback segments are active. 12:01:07 0 InnoDB: Completed initialization of buffer pool 12:01:07 0 InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M 12:01:07 0 InnoDB: Using SSE2 crc32 instructions 12:01:07 0 InnoDB: Compressed tables use zlib 1.2.11 The MySQL in XAMPP has been working fine for weeks, today suddenly I got the error "Error: MySQL shutdown unexpectedly."Įrror on Xampp Panel:- 12:21:51 PM Error: MySQL shutdown unexpectedly.ġ2:21:51 PM This may be due to a blocked port, missing dependencies,ġ2:21:51 PM improper privileges, a crash, or a shutdown by another method.ġ2:21:51 PM Press the Logs button to view error logs and checkġ2:21:51 PM the Windows Event Viewer for more cluesġ2:21:51 PM If you need more help, copy and post thisġ2:21:51 PM entire log window on the forumsĮrror in Log file:- 12:01:07 0 InnoDB: Mutexes and rw_locks use Windows interlocked functions
0 Comments
Leave a Reply. |