MySQL Portion of my XAMPP Install Stopped Working

Alles, was MariaDB und MySQL betrifft, kann hier besprochen werden.

MySQL Portion of my XAMPP Install Stopped Working

Postby ThomasChapoSr » 10. January 2021 00:41

This has happened to both my old install of XAMPP and to the new XAMPP install that I just replaced the old install with. The old install has worked just fine for a long time and now it has failed. The new install worked for a day or two and then all of a sudden it failed with the same error notification that came up when the old install failed.
Here is the MySQL failure notice that comes up each time there is a failure:

5:29:45 PM [mysql] Error: MySQL shutdown unexpectedly.
5:29:45 PM [mysql] This may be due to a blocked port, missing dependencies,
5:29:45 PM [mysql] improper privileges, a crash, or a shutdown by another method.
5:29:45 PM [mysql] Press the Logs button to view error logs and check
5:29:45 PM [mysql] the Windows Event Viewer for more clues
5:29:45 PM [mysql] If you need more help, copy and post this
5:29:45 PM [mysql] entire log window on the forums

The failures seem to happen when I have XAMPP open and running. It appears that I may or may not be using the program to work on locally hosted websites when the failure occurs. It may be that I could actually be engaged with another program on my computer at the time that the MySQL failure happens.
I am wondering if a “new” program on my computer is providing some sort of interference that keeps MySQL from functioning properly. If that is the case, can I just change the port numbers for MySQL and potentially avoid any new port issues that could be caused by the install of any “new” programs on my computer? If so, is the 3306 port the one I should change, or are there others? Where would I look to make sure the proper changes are made where they should be made?
Any information that can help me solve this problem is appreciated. I am getting to the point where I am afraid to even run XAMPP and work on websites locally.

Thanks,
Thomas Chapo Sr.
tchaposr@gmail.com

See below for various log files and information that I have found after the failures.

XAMPP Control Panel v3.2.4 Log Screen
9:38:25 AM [main] Initializing Control Panel
9:38:25 AM [main] Windows Version: Enterprise 64-bit
9:38:25 AM [main] XAMPP Version: 8.0.0
9:38:25 AM [main] Control Panel Version: 3.2.4 [ Compiled: Jun 5th 2019 ]
9:38:25 AM [main] Running with Administrator rights - good!
9:38:25 AM [main] XAMPP Installation Directory: "c:\xampp\"
9:38:25 AM [main] Checking for prerequisites
9:38:26 AM [main] All prerequisites found
9:38:26 AM [main] Initializing Modules
9:38:26 AM [Tomcat] Problem detected: Tomcat Not Found!
9:38:26 AM [Tomcat] Disabling Tomcat buttons
9:38:26 AM [Tomcat] Run this program from your XAMPP root directory!
9:38:26 AM [main] Starting Check-Timer
9:38:26 AM [main] Control Panel Ready
9:38:31 AM [Apache] Attempting to start Apache app...
9:38:31 AM [Apache] Status change detected: running
9:38:32 AM [mysql] Attempting to start MySQL app...
9:38:32 AM [mysql] Status change detected: running
9:38:33 AM [filezilla] Attempting to start FileZilla app...
9:38:34 AM [filezilla] Status change detected: running
9:38:34 AM [mercury] Attempting to start Mercury app...
9:38:35 AM [mercury] Status change detected: running
5:29:19 PM [mercury] Attempting to stop Mercury (PID: 15576)
5:29:20 PM [mercury] Status change detected: stopped
5:29:21 PM [filezilla] Attempting to stop FileZilla app...
5:29:21 PM [filezilla] Status change detected: stopped
5:29:24 PM [Apache] Attempting to stop Apache (PID: 14652)
5:29:24 PM [Apache] Attempting to stop Apache (PID: 14500)
5:29:24 PM [Apache] Status change detected: stopped
5:29:26 PM [mysql] Attempting to stop MySQL app...
5:29:26 PM [mysql] Status change detected: stopped
5:29:33 PM [mysql] Attempting to start MySQL app...
5:29:33 PM [mysql] Status change detected: running
5:29:35 PM [mysql] Status change detected: stopped
5:29:35 PM [mysql] Error: MySQL shutdown unexpectedly.
5:29:35 PM [mysql] This may be due to a blocked port, missing dependencies,
5:29:35 PM [mysql] improper privileges, a crash, or a shutdown by another method.
5:29:35 PM [mysql] Press the Logs button to view error logs and check
5:29:35 PM [mysql] the Windows Event Viewer for more clues
5:29:35 PM [mysql] If you need more help, copy and post this
5:29:35 PM [mysql] entire log window on the forums
5:29:39 PM [Apache] Attempting to start Apache app...
5:29:39 PM [Apache] Status change detected: running
5:29:43 PM [mysql] Attempting to start MySQL app...
5:29:43 PM [mysql] Status change detected: running
5:29:45 PM [mysql] Status change detected: stopped
5:29:45 PM [mysql] Error: MySQL shutdown unexpectedly.
5:29:45 PM [mysql] This may be due to a blocked port, missing dependencies,
5:29:45 PM [mysql] improper privileges, a crash, or a shutdown by another method.
5:29:45 PM [mysql] Press the Logs button to view error logs and check
5:29:45 PM [mysql] the Windows Event Viewer for more clues
5:29:45 PM [mysql] If you need more help, copy and post this
5:29:45 PM [mysql] entire log window on the forums
5:29:47 PM [filezilla] Attempting to start FileZilla app...
5:29:47 PM [filezilla] Status change detected: running
5:29:50 PM [mercury] Attempting to start Mercury app...
5:29:51 PM [mercury] Status change detected: running
5:30:31 PM [Apache] Attempting to stop Apache (PID: 15544)
5:30:31 PM [Apache] Attempting to stop Apache (PID: 6452)
5:30:31 PM [Apache] Status change detected: stopped
5:30:35 PM [filezilla] Attempting to stop FileZilla app...
5:30:35 PM [filezilla] Status change detected: stopped
5:30:37 PM [mercury] Attempting to stop Mercury (PID: 14484)
5:30:37 PM [mercury] Status change detected: stopped
5:30:47 PM [Apache] Attempting to start Apache app...
5:30:48 PM [Apache] Status change detected: running
5:30:57 PM [mysql] Attempting to start MySQL app...
5:30:57 PM [mysql] Status change detected: running
5:30:59 PM [mysql] Status change detected: stopped
5:30:59 PM [mysql] Error: MySQL shutdown unexpectedly.
5:30:59 PM [mysql] This may be due to a blocked port, missing dependencies,
5:30:59 PM [mysql] improper privileges, a crash, or a shutdown by another method.
5:30:59 PM [mysql] Press the Logs button to view error logs and check
5:30:59 PM [mysql] the Windows Event Viewer for more clues
5:30:59 PM [mysql] If you need more help, copy and post this
5:30:59 PM [mysql] entire log window on the forums
5:31:03 PM [mysql] Attempting to start MySQL app...
5:31:04 PM [mysql] Status change detected: running
5:31:05 PM [mysql] Status change detected: stopped
5:31:05 PM [mysql] Error: MySQL shutdown unexpectedly.
5:31:05 PM [mysql] This may be due to a blocked port, missing dependencies,
5:31:05 PM [mysql] improper privileges, a crash, or a shutdown by another method.
5:31:05 PM [mysql] Press the Logs button to view error logs and check
5:31:05 PM [mysql] the Windows Event Viewer for more clues
5:31:05 PM [mysql] If you need more help, copy and post this
5:31:05 PM [mysql] entire log window on the forums
5:31:07 PM [filezilla] Attempting to start FileZilla app...
5:31:08 PM [filezilla] Status change detected: running
5:31:09 PM [mercury] Attempting to start Mercury app...
5:31:09 PM [mercury] Status change detected: running
5:34:12 PM [mysql] Status change detected: running
5:34:14 PM [mysql] Status change detected: stopped
5:34:14 PM [mysql] Error: MySQL shutdown unexpectedly.
5:34:14 PM [mysql] This may be due to a blocked port, missing dependencies,
5:34:14 PM [mysql] improper privileges, a crash, or a shutdown by another method.
5:34:14 PM [mysql] Press the Logs button to view error logs and check
5:34:14 PM [mysql] the Windows Event Viewer for more clues
5:34:14 PM [mysql] If you need more help, copy and post this
5:34:14 PM [mysql] entire log window on the forums


XAMPP Control Panel v3.2.4 Log Screen
5:34:04 PM [main] Initializing Control Panel
5:34:04 PM [main] Windows Version: Enterprise 64-bit
5:34:04 PM [main] XAMPP Version: 8.0.0
5:34:04 PM [main] Control Panel Version: 3.2.4 [ Compiled: Jun 5th 2019 ]
5:34:04 PM [main] Running with Administrator rights - good!
5:34:04 PM [main] XAMPP Installation Directory: "c:\xampp\"
5:34:04 PM [main] Checking for prerequisites
5:34:05 PM [main] All prerequisites found
5:34:05 PM [main] Initializing Modules
5:34:05 PM [Apache] XAMPP Apache is already running on port 80
5:34:05 PM [Apache] XAMPP Apache is already running on port 4443
5:34:05 PM [filezilla] XAMPP FileZilla is already running on port 21
5:34:05 PM [filezilla] XAMPP FileZilla is already running on port 14147
5:34:05 PM [mercury] XAMPP Mercury is already running on port 25
5:34:05 PM [mercury] XAMPP Mercury is already running on port 79
5:34:05 PM [mercury] XAMPP Mercury is already running on port 105
5:34:05 PM [mercury] XAMPP Mercury is already running on port 106
5:34:05 PM [mercury] XAMPP Mercury is already running on port 110
5:34:05 PM [mercury] XAMPP Mercury is already running on port 143
5:34:05 PM [mercury] XAMPP Mercury is already running on port 2224
5:34:05 PM [Tomcat] Problem detected: Tomcat Not Found!
5:34:05 PM [Tomcat] Disabling Tomcat buttons
5:34:05 PM [Tomcat] Run this program from your XAMPP root directory!
5:34:05 PM [main] Starting Check-Timer
5:34:05 PM [main] Control Panel Ready
5:34:12 PM [mysql] Attempting to start MySQL app...
5:34:12 PM [mysql] Status change detected: running
5:34:14 PM [mysql] Status change detected: stopped
5:34:14 PM [mysql] Error: MySQL shutdown unexpectedly.
5:34:14 PM [mysql] This may be due to a blocked port, missing dependencies,
5:34:14 PM [mysql] improper privileges, a crash, or a shutdown by another method.
5:34:14 PM [mysql] Press the Logs button to view error logs and check
5:34:14 PM [mysql] the Windows Event Viewer for more clues
5:34:14 PM [mysql] If you need more help, copy and post this
5:34:14 PM [mysql] entire log window on the forums


MYSQL Error Log
InnoDB: using atomic writes.
2020-12-29 18:33:48 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-12-29 18:33:48 0 [Note] InnoDB: Uses event mutexes
2020-12-29 18:33:48 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-12-29 18:33:48 0 [Note] InnoDB: Number of pools: 1
2020-12-29 18:33:48 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-12-29 18:33:48 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-12-29 18:33:49 0 [Note] InnoDB: Completed initialization of buffer pool
2020-12-29 18:33:49 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300288
2020-12-29 18:33:49 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-12-29 18:33:49 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-12-29 18:33:49 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-12-29 18:33:49 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-12-29 18:33:49 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-12-29 18:33:49 0 [Note] InnoDB: Waiting for purge to start
2020-12-29 18:33:49 0 [Note] InnoDB: 10.4.17 started; log sequence number 300297; transaction id 170
2020-12-29 18:33:49 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-12-29 18:33:49 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-12-29 18:33:49 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-12-29 21:01:09 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-12-29 21:01:09 0 [Note] InnoDB: Uses event mutexes
2020-12-29 21:01:09 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-12-29 21:01:09 0 [Note] InnoDB: Number of pools: 1
2020-12-29 21:01:09 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-12-29 21:01:09 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-12-29 21:01:09 0 [Note] InnoDB: Completed initialization of buffer pool
2020-12-29 21:01:09 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300638
2020-12-29 21:01:09 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-12-29 21:01:09 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-12-29 21:01:09 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-12-29 21:01:09 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-12-29 21:01:09 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-12-29 21:01:09 0 [Note] InnoDB: Waiting for purge to start
2020-12-29 21:01:09 0 [Note] InnoDB: 10.4.17 started; log sequence number 300647; transaction id 193
2020-12-29 21:01:09 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-12-29 21:01:09 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-12-29 21:01:09 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-12-29 21:21:40 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-12-29 21:21:40 0 [Note] InnoDB: Uses event mutexes
2020-12-29 21:21:40 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-12-29 21:21:40 0 [Note] InnoDB: Number of pools: 1
2020-12-29 21:21:40 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-12-29 21:21:40 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-12-29 21:21:40 0 [Note] InnoDB: Completed initialization of buffer pool
2020-12-29 21:21:40 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300656
2020-12-29 21:21:41 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-12-29 21:21:41 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-12-29 21:21:41 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-12-29 21:21:41 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-12-29 21:21:41 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-12-29 21:21:41 0 [Note] InnoDB: 10.4.17 started; log sequence number 300665; transaction id 193
2020-12-29 21:21:41 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-12-29 21:21:41 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-12-29 21:21:41 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-12-29 21:27:55 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-12-29 21:27:55 0 [Note] InnoDB: Uses event mutexes
2020-12-29 21:27:55 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-12-29 21:27:55 0 [Note] InnoDB: Number of pools: 1
2020-12-29 21:27:55 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-12-29 21:27:55 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-12-29 21:27:55 0 [Note] InnoDB: Completed initialization of buffer pool
2020-12-29 21:27:55 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300674
2020-12-29 21:27:55 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-12-29 21:27:55 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-12-29 21:27:55 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-12-29 21:27:55 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-12-29 21:27:55 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-12-29 21:27:55 0 [Note] InnoDB: Waiting for purge to start
2020-12-29 21:27:56 0 [Note] InnoDB: 10.4.17 started; log sequence number 300683; transaction id 193
2020-12-29 21:27:56 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-12-29 21:27:56 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-12-29 21:27:56 0 [Note] InnoDB: Buffer pool(s) load completed at 201229 21:27:56
2020-12-29 21:27:56 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-12-30 18:39:02 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-12-30 18:39:02 0 [Note] InnoDB: Uses event mutexes
2020-12-30 18:39:02 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-12-30 18:39:02 0 [Note] InnoDB: Number of pools: 1
2020-12-30 18:39:02 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-12-30 18:39:02 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-12-30 18:39:02 0 [Note] InnoDB: Completed initialization of buffer pool
2020-12-30 18:39:02 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=43397605
2020-12-30 18:39:03 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-12-30 18:39:03 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-12-30 18:39:03 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-12-30 18:39:03 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-12-30 18:39:03 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-12-30 18:39:03 0 [Note] InnoDB: Waiting for purge to start
2020-12-30 18:39:03 0 [Note] InnoDB: 10.4.17 started; log sequence number 43397614; transaction id 102009
2020-12-30 18:39:03 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-12-30 18:39:03 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-12-30 18:39:03 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-12-31 23:40:38 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-12-31 23:40:38 0 [Note] InnoDB: Uses event mutexes
2020-12-31 23:40:38 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-12-31 23:40:38 0 [Note] InnoDB: Number of pools: 1
2020-12-31 23:40:38 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-12-31 23:40:38 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-12-31 23:40:38 0 [Note] InnoDB: Completed initialization of buffer pool
2020-12-31 23:40:38 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=51520921
2020-12-31 23:40:39 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-12-31 23:40:39 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-12-31 23:40:39 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-12-31 23:40:39 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-12-31 23:40:39 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-12-31 23:40:39 0 [Note] InnoDB: Waiting for purge to start
2020-12-31 23:40:39 0 [Note] InnoDB: 10.4.17 started; log sequence number 51520930; transaction id 106209
2020-12-31 23:40:39 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-12-31 23:40:39 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-12-31 23:40:39 0 [Note] InnoDB: Buffer pool(s) load completed at 201231 23:40:39
2020-12-31 23:40:39 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-01-02 16:33:50 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-01-02 16:33:50 0 [Note] InnoDB: Uses event mutexes
2021-01-02 16:33:50 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-01-02 16:33:50 0 [Note] InnoDB: Number of pools: 1
2021-01-02 16:33:50 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-01-02 16:33:50 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-01-02 16:33:50 0 [Note] InnoDB: Completed initialization of buffer pool
2021-01-02 16:33:50 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=58712885
2021-01-02 16:33:51 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-01-02 16:33:51 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-01-02 16:33:51 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-01-02 16:33:51 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-01-02 16:33:51 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-01-02 16:33:51 0 [Note] InnoDB: Waiting for purge to start
2021-01-02 16:33:51 0 [Note] InnoDB: 10.4.17 started; log sequence number 58712894; transaction id 109321
2021-01-02 16:33:51 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-01-02 16:33:51 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-01-02 16:33:51 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-01-02 16:34:37 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-01-02 16:34:37 0 [Note] InnoDB: Uses event mutexes
2021-01-02 16:34:37 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-01-02 16:34:37 0 [Note] InnoDB: Number of pools: 1
2021-01-02 16:34:37 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-01-02 16:34:37 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-01-02 16:34:37 0 [Note] InnoDB: Completed initialization of buffer pool
2021-01-02 16:34:37 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=58712903
2021-01-02 16:34:37 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-01-02 16:34:37 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-01-02 16:34:37 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-01-02 16:34:37 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-01-02 16:34:37 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-01-02 16:34:37 0 [Note] InnoDB: Waiting for purge to start
2021-01-02 16:34:38 0 [Note] InnoDB: 10.4.17 started; log sequence number 58712912; transaction id 109321
2021-01-02 16:34:38 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-01-02 16:34:38 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-01-02 16:34:38 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-01-02 16:36:21 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-01-02 16:36:21 0 [Note] InnoDB: Uses event mutexes
2021-01-02 16:36:21 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-01-02 16:36:21 0 [Note] InnoDB: Number of pools: 1
2021-01-02 16:36:21 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-01-02 16:36:21 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-01-02 16:36:21 0 [Note] InnoDB: Completed initialization of buffer pool
2021-01-02 16:36:21 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=58712921
2021-01-02 16:36:21 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-01-02 16:36:21 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-01-02 16:36:21 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-01-02 16:36:21 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-01-02 16:36:21 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-01-02 16:36:21 0 [Note] InnoDB: 10.4.17 started; log sequence number 58712930; transaction id 109321
2021-01-02 16:36:21 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-01-02 16:36:21 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-01-02 16:36:21 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-01-03 18:58:54 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-01-03 18:58:54 0 [Note] InnoDB: Uses event mutexes
2021-01-03 18:58:54 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-01-03 18:58:54 0 [Note] InnoDB: Number of pools: 1
2021-01-03 18:58:54 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-01-03 18:58:54 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-01-03 18:58:54 0 [Note] InnoDB: Completed initialization of buffer pool
2021-01-03 18:58:54 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=111311107
2021-01-03 18:58:55 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-01-03 18:58:55 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-01-03 18:58:55 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-01-03 18:58:55 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-01-03 18:58:55 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-01-03 18:58:55 0 [Note] InnoDB: Waiting for purge to start
2021-01-03 18:58:55 0 [Note] InnoDB: 10.4.17 started; log sequence number 111311116; transaction id 213973
2021-01-03 18:58:55 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-01-03 18:58:55 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-01-03 18:58:55 0 [Note] InnoDB: Buffer pool(s) load completed at 210103 18:58:55
2021-01-03 18:58:55 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-01-04 18:14:27 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-01-04 18:14:27 0 [Note] InnoDB: Uses event mutexes
2021-01-04 18:14:27 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-01-04 18:14:27 0 [Note] InnoDB: Number of pools: 1
2021-01-04 18:14:27 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-01-04 18:14:27 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-01-04 18:14:27 0 [Note] InnoDB: Completed initialization of buffer pool
2021-01-04 18:14:27 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=111369196
2021-01-04 18:14:28 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-01-04 18:14:28 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-01-04 18:14:28 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-01-04 18:14:28 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-01-04 18:14:28 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-01-04 18:14:28 0 [Note] InnoDB: Waiting for purge to start
2021-01-04 18:14:28 0 [Note] InnoDB: 10.4.17 started; log sequence number 111369205; transaction id 214058
2021-01-04 18:14:28 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-01-04 18:14:28 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-01-04 18:14:28 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-01-05 9:41:33 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-01-05 9:41:33 0 [Note] InnoDB: Uses event mutexes
2021-01-05 9:41:33 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-01-05 9:41:34 0 [Note] InnoDB: Number of pools: 1
2021-01-05 9:41:34 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-01-05 9:41:34 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-01-05 9:41:34 0 [Note] InnoDB: Completed initialization of buffer pool
2021-01-05 9:41:34 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=146666444
2021-01-05 9:41:34 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-01-05 9:41:34 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-01-05 9:41:34 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-01-05 9:41:34 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-01-05 9:41:34 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-01-05 9:41:34 0 [Note] InnoDB: Waiting for purge to start
2021-01-05 9:41:34 0 [Note] InnoDB: 10.4.17 started; log sequence number 146666453; transaction id 310233
2021-01-05 9:41:34 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-01-05 9:41:34 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-01-05 9:41:34 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-01-06 13:59:35 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-01-06 13:59:35 0 [Note] InnoDB: Uses event mutexes
2021-01-06 13:59:35 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-01-06 13:59:35 0 [Note] InnoDB: Number of pools: 1
2021-01-06 13:59:35 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-01-06 13:59:35 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-01-06 13:59:35 0 [Note] InnoDB: Completed initialization of buffer pool
2021-01-06 13:59:35 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=147914547
2021-01-06 13:59:36 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-01-06 13:59:36 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-01-06 13:59:36 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-01-06 13:59:36 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-01-06 13:59:36 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-01-06 13:59:36 0 [Note] InnoDB: Waiting for purge to start
2021-01-06 13:59:36 0 [Note] InnoDB: 10.4.17 started; log sequence number 147914556; transaction id 311218
2021-01-06 13:59:36 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-01-06 13:59:36 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-01-06 13:59:36 0 [Note] InnoDB: Buffer pool(s) load completed at 210106 13:59:36
2021-01-06 13:59:36 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-01-07 9:38:32 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-01-07 9:38:32 0 [Note] InnoDB: Uses event mutexes
2021-01-07 9:38:32 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-01-07 9:38:32 0 [Note] InnoDB: Number of pools: 1
2021-01-07 9:38:32 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-01-07 9:38:32 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-01-07 9:38:32 0 [Note] InnoDB: Completed initialization of buffer pool
2021-01-07 9:38:32 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=148502152
2021-01-07 9:38:33 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-01-07 9:38:33 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-01-07 9:38:33 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-01-07 9:38:33 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-01-07 9:38:33 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-01-07 9:38:33 0 [Note] InnoDB: Waiting for purge to start
2021-01-07 9:38:33 0 [Note] InnoDB: 10.4.17 started; log sequence number 148502161; transaction id 311785
2021-01-07 9:38:33 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-01-07 9:38:33 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-01-07 9:38:33 0 [Note] InnoDB: Buffer pool(s) load completed at 210107 9:38:33
2021-01-07 9:38:33 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-01-07 17:29:33 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-01-07 17:29:33 0 [Note] InnoDB: Uses event mutexes
2021-01-07 17:29:33 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-01-07 17:29:33 0 [Note] InnoDB: Number of pools: 1
2021-01-07 17:29:33 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-01-07 17:29:33 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-01-07 17:29:33 0 [Note] InnoDB: Completed initialization of buffer pool
2021-01-07 17:29:33 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=150957375
2021-01-07 17:29:33 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-01-07 17:29:33 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-01-07 17:29:33 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-01-07 17:29:33 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-01-07 17:29:33 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-01-07 17:29:33 0 [Note] InnoDB: Waiting for purge to start
2021-01-07 17:29:33 0 [Note] InnoDB: 10.4.17 started; log sequence number 150957384; transaction id 313109
2021-01-07 17:29:33 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-01-07 17:29:33 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-01-07 17:29:33 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-01-07 17:29:43 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-01-07 17:29:43 0 [Note] InnoDB: Uses event mutexes
2021-01-07 17:29:43 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-01-07 17:29:43 0 [Note] InnoDB: Number of pools: 1
2021-01-07 17:29:43 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-01-07 17:29:43 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-01-07 17:29:43 0 [Note] InnoDB: Completed initialization of buffer pool
2021-01-07 17:29:43 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-01-07 17:29:43 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-01-07 17:29:43 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-01-07 17:29:43 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-01-07 17:29:43 0 [Note] InnoDB: 10.4.17 started; log sequence number 150957393; transaction id 313109
2021-01-07 17:29:43 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-01-07 17:29:43 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-01-07 17:29:43 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-01-07 17:30:57 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-01-07 17:30:57 0 [Note] InnoDB: Uses event mutexes
2021-01-07 17:30:57 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-01-07 17:30:57 0 [Note] InnoDB: Number of pools: 1
2021-01-07 17:30:57 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-01-07 17:30:57 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-01-07 17:30:57 0 [Note] InnoDB: Completed initialization of buffer pool
2021-01-07 17:30:57 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-01-07 17:30:57 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-01-07 17:30:57 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-01-07 17:30:57 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-01-07 17:30:57 0 [Note] InnoDB: Waiting for purge to start
2021-01-07 17:30:57 0 [Note] InnoDB: 10.4.17 started; log sequence number 150957402; transaction id 313109
2021-01-07 17:30:57 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-01-07 17:30:57 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-01-07 17:30:57 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-01-07 17:31:03 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-01-07 17:31:03 0 [Note] InnoDB: Uses event mutexes
2021-01-07 17:31:03 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-01-07 17:31:03 0 [Note] InnoDB: Number of pools: 1
2021-01-07 17:31:03 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-01-07 17:31:03 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-01-07 17:31:03 0 [Note] InnoDB: Completed initialization of buffer pool
2021-01-07 17:31:04 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-01-07 17:31:04 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-01-07 17:31:04 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-01-07 17:31:04 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-01-07 17:31:04 0 [Note] InnoDB: Waiting for purge to start
2021-01-07 17:31:04 0 [Note] InnoDB: 10.4.17 started; log sequence number 150957411; transaction id 313109
2021-01-07 17:31:04 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-01-07 17:31:04 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-01-07 17:31:04 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-01-07 17:34:12 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-01-07 17:34:12 0 [Note] InnoDB: Uses event mutexes
2021-01-07 17:34:12 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-01-07 17:34:12 0 [Note] InnoDB: Number of pools: 1
2021-01-07 17:34:12 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-01-07 17:34:12 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-01-07 17:34:12 0 [Note] InnoDB: Completed initialization of buffer pool
2021-01-07 17:34:12 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-01-07 17:34:12 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-01-07 17:34:12 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-01-07 17:34:12 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-01-07 17:34:12 0 [Note] InnoDB: 10.4.17 started; log sequence number 150957420; transaction id 313109
2021-01-07 17:34:12 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-01-07 17:34:12 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-01-07 17:34:12 0 [Note] Server socket created on IP: '::'.





Welcome to phpMyAdmin

Error
MySQL said:
Cannot connect: invalid settings.
mysqli::real_connect(): (HY000/2002): No connection could be made because the target machine actively refused it
Connection for controluser as defined in your configuration failed.
mysqli::real_connect(): (HY000/2002): No connection could be made because the target machine actively refused it
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
Retry to connect
ThomasChapoSr
 
Posts: 1
Joined: 10. January 2021 00:23
XAMPP version: 8.0.0
Operating System: Windows 10 64bit

Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 4 guests