Can't start MySQL in Windows 8

[mikemcg]

I've installed XAMPP 1.8.3 on my Windows 8 system using the .msi package. I can start Apache, Tomcat and FileZilla without any problems but MySQL starts and immediately exits. I've checked the firewall settings and there is the appropriate exception for mysqld. I've killed Skype to see if there was a port conflict there but that didn't work. I've run netstat -o and there isn't a port conflict on port 3306. Various pertinent logs are below. I'm suspicious about the lines in the mysql_error.log at the end:

2013-11-03 08:21:59 7808 [Note] - '::' resolves to '::';
2013-11-03 08:21:59 7808 [Note] Server socket created on IP: '::'.

but I don't know what that means.

Control panel monitor:

Code: Select all

8:21:59 AM  [mysql]    Attempting to start MySQL app...
8:21:59 AM  [mysql]    Status change detected: running
8:22:01 AM  [mysql]    Status change detected: stopped
8:22:01 AM  [mysql]    Error: MySQL shutdown unexpectedly.
8:22:01 AM  [mysql]    This may be due to a blocked port, missing dependencies,
8:22:01 AM  [mysql]    improper privileges, a crash, or a shutdown by another method.
8:22:01 AM  [mysql]    Press the Logs button to view error logs and check
8:22:01 AM  [mysql]    the Windows Event Viewer for more clues
8:22:01 AM  [mysql]    If you need more help, copy and post this
8:22:01 AM  [mysql]    entire log window on the forums


mysql_error.log

Code: Select all

2013-11-03 08:21:37 3816 [Note] Plugin 'FEDERATED' is disabled.
2013-11-03 08:21:37 418 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.
2013-11-03 08:21:37 3816 [Note] InnoDB: The InnoDB memory heap is disabled
2013-11-03 08:21:37 3816 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-11-03 08:21:37 3816 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-11-03 08:21:37 3816 [Note] InnoDB: Not using CPU crc32 instructions
2013-11-03 08:21:37 3816 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2013-11-03 08:21:37 3816 [Note] InnoDB: Completed initialization of buffer pool
2013-11-03 08:21:38 3816 [Note] InnoDB: Highest supported file format is Barracuda.
2013-11-03 08:21:38 3816 [Note] InnoDB: 128 rollback segment(s) are active.
2013-11-03 08:21:38 3816 [Note] InnoDB: Waiting for purge to start
2013-11-03 08:21:38 3816 [Note] InnoDB: 5.6.11 started; log sequence number 1601558
2013-11-03 08:21:38 3816 [Note] Server hostname (bind-address): '*'; port: 3306
2013-11-03 08:21:38 3816 [Note] IPv6 is available.
2013-11-03 08:21:38 3816 [Note]   - '::' resolves to '::';
2013-11-03 08:21:38 3816 [Note] Server socket created on IP: '::'.
2013-11-03 08:21:59 7808 [Note] Plugin 'FEDERATED' is disabled.
2013-11-03 08:21:59 197c 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.
2013-11-03 08:21:59 7808 [Note] InnoDB: The InnoDB memory heap is disabled
2013-11-03 08:21:59 7808 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-11-03 08:21:59 7808 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-11-03 08:21:59 7808 [Note] InnoDB: Not using CPU crc32 instructions
2013-11-03 08:21:59 7808 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2013-11-03 08:21:59 7808 [Note] InnoDB: Completed initialization of buffer pool
2013-11-03 08:21:59 7808 [Note] InnoDB: Highest supported file format is Barracuda.
2013-11-03 08:21:59 7808 [Note] InnoDB: 128 rollback segment(s) are active.
2013-11-03 08:21:59 7808 [Note] InnoDB: Waiting for purge to start
2013-11-03 08:21:59 7808 [Note] InnoDB: 5.6.11 started; log sequence number 1601568
2013-11-03 08:21:59 7808 [Note] Server hostname (bind-address): '*'; port: 3306
2013-11-03 08:21:59 7808 [Note] IPv6 is available.
2013-11-03 08:21:59 7808 [Note]   - '::' resolves to '::';
2013-11-03 08:21:59 7808 [Note] Server socket created on IP: '::'.


windows event log:

Code: Select all

The description for Event ID 100 from source MySQL cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

Aborting


Thanks, Mike