Unexpected shutdown of mysql in Xampp in Windows 8.1
Posted: 07. November 2015 21:46Yesterday, I was able install the latest version of xampp (version 5.6.14) in Windows 8.1 and both Apache and Mysql were working well.
But this morning when i turned on apache and mysql in xampp control panel, I could not login in phpmyadmin and the following
error message showed in the control panel.
Error: MySQL shutdown unexpectedly.
11:31:38 AM [mysql] This may be due to a blocked port, missing dependencies,
11:31:38 AM [mysql] improper privileges, a crash, or a shutdown by another method.
11:31:38 AM [mysql] Press the Logs button to view error logs and check
11:31:38 AM [mysql] the Windows Event Viewer for more clues
11:31:38 AM [mysql] If you need more help, copy and post this
11:31:38 AM [mysql] entire log window on the forums
The mysql error logs showed:
2015-11-06 12:21:04 1ed0 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases,
together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
151106 12:21:04 [Note] InnoDB: Using mutexes to ref count buffer pool pages
151106 12:21:04 [Note] InnoDB: The InnoDB memory heap is disabled
151106 12:21:04 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
151106 12:21:04 [Note] InnoDB: Memory barrier is not used
151106 12:21:04 [Note] InnoDB: Compressed tables use zlib 1.2.3
151106 12:21:04 [Note] InnoDB: Not using CPU crc32 instructions
151106 12:21:04 [Note] InnoDB: Initializing buffer pool, size = 16.0M
151106 12:21:04 [Note] InnoDB: Completed initialization of buffer pool
151106 12:21:04 [Note] InnoDB: Highest supported file format is Barracuda.
151106 12:21:05 [Note] InnoDB: 128 rollback segment(s) are active.
151106 12:21:05 [Note] InnoDB: Waiting for purge to start
151106 12:21:05 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.22-72.0 started; log sequence number 1665234
151106 12:21:05 [Note] Plugin 'FEEDBACK' is disabled.
151106 12:21:05 [Note] Server socket created on IP: '::'.
Please help me to fix this and thank you in advance.
espi62
But this morning when i turned on apache and mysql in xampp control panel, I could not login in phpmyadmin and the following
error message showed in the control panel.
Error: MySQL shutdown unexpectedly.
11:31:38 AM [mysql] This may be due to a blocked port, missing dependencies,
11:31:38 AM [mysql] improper privileges, a crash, or a shutdown by another method.
11:31:38 AM [mysql] Press the Logs button to view error logs and check
11:31:38 AM [mysql] the Windows Event Viewer for more clues
11:31:38 AM [mysql] If you need more help, copy and post this
11:31:38 AM [mysql] entire log window on the forums
The mysql error logs showed:
2015-11-06 12:21:04 1ed0 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases,
together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
151106 12:21:04 [Note] InnoDB: Using mutexes to ref count buffer pool pages
151106 12:21:04 [Note] InnoDB: The InnoDB memory heap is disabled
151106 12:21:04 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
151106 12:21:04 [Note] InnoDB: Memory barrier is not used
151106 12:21:04 [Note] InnoDB: Compressed tables use zlib 1.2.3
151106 12:21:04 [Note] InnoDB: Not using CPU crc32 instructions
151106 12:21:04 [Note] InnoDB: Initializing buffer pool, size = 16.0M
151106 12:21:04 [Note] InnoDB: Completed initialization of buffer pool
151106 12:21:04 [Note] InnoDB: Highest supported file format is Barracuda.
151106 12:21:05 [Note] InnoDB: 128 rollback segment(s) are active.
151106 12:21:05 [Note] InnoDB: Waiting for purge to start
151106 12:21:05 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.22-72.0 started; log sequence number 1665234
151106 12:21:05 [Note] Plugin 'FEEDBACK' is disabled.
151106 12:21:05 [Note] Server socket created on IP: '::'.
Please help me to fix this and thank you in advance.
espi62