helenemt wrote on Saturday, March 07, 2015:
Hi,
I am in the XAMPP control panel, and clicked the red x next to the MySQL, and got a green checkmark. But I then get an error, and the log looks as follows (sorry, don’t know enough to determine what it means). Help is appreciated!
“130817 13:47:48 [Note] Plugin ‘FEDERATED’ is disabled.
130817 13:47:48 InnoDB: The InnoDB memory heap is disabled
130817 13:47:48 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130817 13:47:48 InnoDB: Compressed tables use zlib 1.2.3
130817 13:47:49 InnoDB: Initializing buffer pool, size = 16.0M
130817 13:47:49 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file \xampp\mysql\data\ibdata1 did not exist:
InnoDB: a new database to be created!
130817 13:47:49 InnoDB: Setting file \xampp\mysql\data\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait…
130817 13:47:49 InnoDB: Log file \xampp\mysql\data\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file \xampp\mysql\data\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait…
130817 13:47:49 InnoDB: Log file \xampp\mysql\data\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file \xampp\mysql\data\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait…
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
130817 13:47:49 InnoDB: Waiting for the background threads to start
130817 13:47:50 InnoDB: 5.5.32 started; log sequence number 0
130817 13:47:50 [Note] Server hostname (bind-address): ‘0.0.0.0’; port: 3306
130817 13:47:50 [Note] - ‘0.0.0.0’ resolves to ‘0.0.0.0’;
130817 13:47:50 [Note] Server socket created on IP: ‘0.0.0.0’.
130817 13:47:53 [Note] Event Scheduler: Loaded 0 events
130817 13:47:53 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: ‘5.5.32’ socket: ‘’ port: 3306 MySQL Community Server (GPL)
130817 13:58:04 [Note] Plugin ‘FEDERATED’ is disabled.
130817 13:58:04 InnoDB: The InnoDB memory heap is disabled
130817 13:58:04 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130817 13:58:04 InnoDB: Compressed tables use zlib 1.2.3
130817 13:58:04 InnoDB: Initializing buffer pool, size = 16.0M
130817 13:58:04 InnoDB: Completed initialization of buffer pool
130817 13:58:04 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
130817 13:58:04 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files…
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer…
130817 13:58:05 InnoDB: Waiting for the background threads to start
130817 13:58:06 InnoDB: 5.5.32 started; log sequence number 1926824
130817 13:58:06 [Note] Server hostname (bind-address): ‘0.0.0.0’; port: 3306
130817 13:58:06 [Note] - ‘0.0.0.0’ resolves to ‘0.0.0.0’;
130817 13:58:06 [Note] Server socket created on IP: ‘0.0.0.0’.
130817 13:58:06 [Note] Event Scheduler: Loaded 0 events
130817 13:58:06 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: ‘5.5.32’ socket: ‘’ port: 3306 MySQL Community Server (GPL)
141226 22:55:51 [Note] Plugin ‘FEDERATED’ is disabled.
141226 22:55:51 InnoDB: The InnoDB memory heap is disabled
141226 22:55:51 InnoDB: Mutexes and rw_locks use Windows interlocked functions
141226 22:55:51 InnoDB: Compressed tables use zlib 1.2.3
141226 22:55:51 InnoDB: Initializing buffer pool, size = 16.0M
141226 22:55:51 InnoDB: Completed initialization of buffer pool
141226 22:55:51 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
141226 22:55:51 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files…
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer…
141226 22:55:52 InnoDB: Waiting for the background threads to start
141226 22:55:53 InnoDB: 5.5.32 started; log sequence number 1926834
141226 22:55:53 [Note] Server hostname (bind-address): ‘0.0.0.0’; port: 3306
141226 22:55:53 [Note] - ‘0.0.0.0’ resolves to ‘0.0.0.0’;
141226 22:55:53 [Note] Server socket created on IP: ‘0.0.0.0’.
141226 23:33:47 [Note] Plugin ‘FEDERATED’ is disabled.
141226 23:33:47 InnoDB: The InnoDB memory heap is disabled
141226 23:33:47 InnoDB: Mutexes and rw_locks use Windows interlocked functions
141226 23:33:47 InnoDB: Compressed tables use zlib 1.2.3
141226 23:33:47 InnoDB: Initializing buffer pool, size = 16.0M
141226 23:33:47 InnoDB: Completed initialization of buffer pool
141226 23:33:47 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
141226 23:33:47 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files…
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer…
141226 23:33:47 InnoDB: Waiting for the background threads to start
141226 23:33:48 InnoDB: 5.5.32 started; log sequence number 1977079
141226 23:33:48 [Note] Server hostname (bind-address): ‘0.0.0.0’; port: 3306
141226 23:33:48 [Note] - ‘0.0.0.0’ resolves to ‘0.0.0.0’;
141226 23:33:48 [Note] Server socket created on IP: ‘0.0.0.0’.”
Edited…the other window read as follows:
“2:27:00 PM [main] Initializing Control Panel
2:27:00 PM [main] Windows Version: Windows 7 Home Premium SP1 64-bit
2:27:00 PM [main] XAMPP Version: 1.8.2
2:27:00 PM [main] Control Panel Version: 3.2.1 [ Compiled: May 7th 2013 ]
2:27:00 PM [main] Running with Administrator rights - good!
2:27:00 PM [main] XAMPP Installation Directory: “c:\users\helene\downloads\xampp-openemr-4.2.0\xampp”
2:27:00 PM [main] Checking for prerequisites
2:27:00 PM [main] All prerequisites found
2:27:00 PM [main] Initializing Modules
2:27:00 PM [main] Starting Check-Timer
2:27:00 PM [main] Control Panel Ready
2:27:18 PM [Apache] Attempting to start Apache service…
2:27:53 PM [mysql] Attempting to start MySQL service…
2:27:54 PM [mysql] Status change detected: running
2:27:59 PM [mysql] Status change detected: stopped
2:27:59 PM [mysql] Error: MySQL shutdown unexpectedly.
2:27:59 PM [mysql] This may be due to a blocked port, missing dependencies,
2:27:59 PM [mysql] improper privileges, a crash, or a shutdown by another method.
2:27:59 PM [mysql] Press the Logs button to view error logs and check
2:27:59 PM [mysql] the Windows Event Viewer for more clues
2:27:59 PM [mysql] If you need more help, copy and post this
2:27:59 PM [mysql] entire log window on the forums”