• From: USA
  • Registered: 02/05/2018
  • Posts: 37

Topic: MySQL will not start

I'm not sure if this is the correct forum for this issue but it's the best fit I could see in the index.

From the XAMPP Control Panel, when I click the MySQL button I get the message "Error: MySQL shutdown unexpectedly".

I am not aware of any power outages or systems issues.  The only change to the system was that I installed an Adobe suite; CS5.  When I discovered that MySQL would not start I uninstalled that suite, thinking that there might be some kind of conflict.  It did not help.  Any suggestions on courses of action to correct the issue would be appreciated.

Here are the log entries for MySQL for the numerous attempts I've tried today:

InnoDB: using atomic writes.
2021-05-10  9:47:14 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-05-10  9:47:14 0 [Note] InnoDB: Uses event mutexes
2021-05-10  9:47:14 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-05-10  9:47:14 0 [Note] InnoDB: Number of pools: 1
2021-05-10  9:47:14 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-05-10  9:47:14 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-05-10  9:47:14 0 [Note] InnoDB: Completed initialization of buffer pool
2021-05-10  9:47:14 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=71807730
2021-05-10  9:47:14 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-05-10  9:47:14 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-05-10  9:47:14 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-05-10  9:47:14 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-05-10  9:47:14 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-05-10  9:47:14 0 [Note] InnoDB: Waiting for purge to start
2021-05-10  9:47:15 0 [Note] InnoDB: 10.4.14 started; log sequence number 71807739; transaction id 500923
2021-05-10  9:47:15 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-05-10  9:47:15 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-05-10  9:47:15 0 [Note] InnoDB: Cannot open 'C:\xampp\mysql\data\ib_buffer_pool' for reading: No such file or directory
2021-05-10  9:47:15 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-05-10  9:47:57 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-05-10  9:47:57 0 [Note] InnoDB: Uses event mutexes
2021-05-10  9:47:57 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-05-10  9:47:57 0 [Note] InnoDB: Number of pools: 1
2021-05-10  9:47:57 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-05-10  9:47:57 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-05-10  9:47:57 0 [Note] InnoDB: Completed initialization of buffer pool
2021-05-10  9:47:57 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-05-10  9:47:57 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-05-10  9:47:57 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-05-10  9:47:57 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-05-10  9:47:57 0 [Note] InnoDB: 10.4.14 started; log sequence number 71807748; transaction id 500923
2021-05-10  9:47:57 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-05-10  9:47:57 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-05-10  9:47:57 0 [Note] InnoDB: Buffer pool(s) load completed at 210510  9:47:57
2021-05-10  9:47:57 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-05-10  9:49:07 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-05-10  9:49:07 0 [Note] InnoDB: Uses event mutexes
2021-05-10  9:49:07 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-05-10  9:49:07 0 [Note] InnoDB: Number of pools: 1
2021-05-10  9:49:07 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-05-10  9:49:07 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-05-10  9:49:07 0 [Note] InnoDB: Completed initialization of buffer pool
2021-05-10  9:49:07 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-05-10  9:49:07 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-05-10  9:49:07 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-05-10  9:49:07 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-05-10  9:49:07 0 [Note] InnoDB: 10.4.14 started; log sequence number 71807757; transaction id 500923
2021-05-10  9:49:07 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-05-10  9:49:07 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-05-10  9:49:07 0 [Note] InnoDB: Buffer pool(s) load completed at 210510  9:49:07
2021-05-10  9:49:07 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-05-10  9:50:07 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-05-10  9:50:07 0 [Note] InnoDB: Uses event mutexes
2021-05-10  9:50:07 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-05-10  9:50:07 0 [Note] InnoDB: Number of pools: 1
2021-05-10  9:50:07 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-05-10  9:50:07 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-05-10  9:50:07 0 [Note] InnoDB: Completed initialization of buffer pool
2021-05-10  9:50:07 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-05-10  9:50:07 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-05-10  9:50:07 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-05-10  9:50:07 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-05-10  9:50:07 0 [Note] InnoDB: Waiting for purge to start
2021-05-10  9:50:07 0 [Note] InnoDB: 10.4.14 started; log sequence number 71807766; transaction id 500923
2021-05-10  9:50:07 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-05-10  9:50:07 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-05-10  9:50:07 0 [Note] InnoDB: Buffer pool(s) load completed at 210510  9:50:07
2021-05-10  9:50:07 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-05-10  9:50:37 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-05-10  9:50:37 0 [Note] InnoDB: Uses event mutexes
2021-05-10  9:50:37 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-05-10  9:50:37 0 [Note] InnoDB: Number of pools: 1
2021-05-10  9:50:37 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-05-10  9:50:37 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-05-10  9:50:37 0 [Note] InnoDB: Completed initialization of buffer pool
2021-05-10  9:50:37 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-05-10  9:50:37 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-05-10  9:50:37 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-05-10  9:50:37 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-05-10  9:50:37 0 [Note] InnoDB: 10.4.14 started; log sequence number 71807775; transaction id 500923
2021-05-10  9:50:37 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-05-10  9:50:37 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-05-10  9:50:37 0 [Note] InnoDB: Buffer pool(s) load completed at 210510  9:50:37
2021-05-10  9:50:37 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-05-10  9:52:26 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-05-10  9:52:26 0 [Note] InnoDB: Uses event mutexes
2021-05-10  9:52:26 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-05-10  9:52:26 0 [Note] InnoDB: Number of pools: 1
2021-05-10  9:52:26 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-05-10  9:52:26 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-05-10  9:52:26 0 [Note] InnoDB: Completed initialization of buffer pool
2021-05-10  9:52:26 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-05-10  9:52:26 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-05-10  9:52:26 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-05-10  9:52:26 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-05-10  9:52:26 0 [Note] InnoDB: 10.4.14 started; log sequence number 71807784; transaction id 500923
2021-05-10  9:52:26 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-05-10  9:52:26 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-05-10  9:52:26 0 [Note] InnoDB: Buffer pool(s) load completed at 210510  9:52:26
2021-05-10  9:52:26 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-05-10 10:05:00 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-05-10 10:05:00 0 [Note] InnoDB: Uses event mutexes
2021-05-10 10:05:00 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-05-10 10:05:00 0 [Note] InnoDB: Number of pools: 1
2021-05-10 10:05:00 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-05-10 10:05:00 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-05-10 10:05:00 0 [Note] InnoDB: Completed initialization of buffer pool
2021-05-10 10:05:01 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-05-10 10:05:01 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-05-10 10:05:01 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-05-10 10:05:01 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-05-10 10:05:01 0 [Note] InnoDB: Waiting for purge to start
2021-05-10 10:05:01 0 [Note] InnoDB: 10.4.14 started; log sequence number 71807793; transaction id 500923
2021-05-10 10:05:01 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-05-10 10:05:01 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-05-10 10:05:01 0 [Note] InnoDB: Buffer pool(s) load completed at 210510 10:05:01
2021-05-10 10:05:01 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-05-10 10:22:33 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-05-10 10:22:33 0 [Note] InnoDB: Uses event mutexes
2021-05-10 10:22:33 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-05-10 10:22:33 0 [Note] InnoDB: Number of pools: 1
2021-05-10 10:22:33 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-05-10 10:22:33 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-05-10 10:22:33 0 [Note] InnoDB: Completed initialization of buffer pool
2021-05-10 10:22:34 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-05-10 10:22:34 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-05-10 10:22:34 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-05-10 10:22:34 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-05-10 10:22:34 0 [Note] InnoDB: Waiting for purge to start
2021-05-10 10:22:34 0 [Note] InnoDB: 10.4.14 started; log sequence number 71807802; transaction id 500923
2021-05-10 10:22:34 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-05-10 10:22:34 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-05-10 10:22:34 0 [Note] InnoDB: Buffer pool(s) load completed at 210510 10:22:34
2021-05-10 10:22:34 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-05-10 10:29:15 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-05-10 10:29:15 0 [Note] InnoDB: Uses event mutexes
2021-05-10 10:29:15 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-05-10 10:29:15 0 [Note] InnoDB: Number of pools: 1
2021-05-10 10:29:15 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-05-10 10:29:15 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-05-10 10:29:15 0 [Note] InnoDB: Completed initialization of buffer pool
2021-05-10 10:29:16 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-05-10 10:29:16 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-05-10 10:29:16 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-05-10 10:29:16 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-05-10 10:29:16 0 [Note] InnoDB: Waiting for purge to start
2021-05-10 10:29:16 0 [Note] InnoDB: 10.4.14 started; log sequence number 71807811; transaction id 500923
2021-05-10 10:29:16 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-05-10 10:29:16 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-05-10 10:29:16 0 [Note] InnoDB: Buffer pool(s) load completed at 210510 10:29:16
2021-05-10 10:29:16 0 [Note] Server socket created on IP: '::'.

  • From: USA
  • Registered: 02/05/2018
  • Posts: 37

Re: MySQL will not start

I found a solution (create a new data file and populate it with files from backup and the original data file), so now XAMPP will start.  However, now when I attempt to log in to Front Accounting I get the message "Incorrect Password, The user and password combination is not valid for the system".

  • From: USA
  • Registered: 02/05/2018
  • Posts: 37

Re: MySQL will not start

2nd solution found:  I'm still not sure what happened to cause the issues I was having but I found that I just needed to do 3 things:
1- repair the 0_users table in the frontaccounting database, 2- repair the db table in the SQL database and 3- re-enter the ID and password associated with the frontaccounting database.