MySQL wont start

Problems with the Windows version of XAMPP, questions, comments, and anything related.

MySQL wont start

Postby vickula » 22. August 2019 13:33

Having trouble starting MySql

Recently had major windows update and first time starting XAMPP since

Any ideas on how I can resolve? Have already tried changing the port to no avail.

Code: Select all
2019-08-22 13:00:34 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-22 13:00:34 0 [Note] InnoDB: Uses event mutexes
2019-08-22 13:00:34 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-22 13:00:34 0 [Note] InnoDB: Number of pools: 1
2019-08-22 13:00:34 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-22 13:00:34 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-22 13:00:34 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-22 13:00:35 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=62425907
2019-08-22 13:00:35 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-22 13:00:35 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-08-22 13:00:35 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-22 13:00:35 0 [Note] InnoDB: Setting file 'D:\XAMPP\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-22 13:00:35 0 [Note] InnoDB: File 'D:\XAMPP\mysql\data\ibtmp1' size is now 12 MB.
2019-08-22 13:00:35 0 [Note] InnoDB: Waiting for purge to start
2019-08-22 13:00:35 0 [Note] InnoDB: 10.3.16 started; log sequence number 62425916; transaction id 39064
2019-08-22 13:00:35 0 [Note] InnoDB: Loading buffer pool(s) from D:\XAMPP\mysql\data\ib_buffer_pool
2019-08-22 13:00:35 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-22 13:00:35 0 [Note] Server socket created on IP: '::'.
vickula
 
Posts: 2
Joined: 22. August 2019 12:58
XAMPP version: 3.2.4
Operating System: windows 10

Re: MySQL wont start

Postby Altrea » 22. August 2019 14:13

Hi,

very common you are one of many having the MariaDB 10.3 bug. All XAMPP versions containing MariaDB 10.3 seems to be buggy.

You can start MariaDB with the goal of creatng a database dump this way:
viewtopic.php?f=16&t=78352&p=265352&hilit=skip+grant+tables#p265352

Recommendation: dump your catabases, uninstall this XAMPP version and install one of the current ones.

best wishes,
Altrea
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: MySQL wont start

Postby vickula » 22. August 2019 15:31

Thanks
I reinstalled xampp and got it working again but I will update to the latest version - didn't realise my version was so out of date!
vickula
 
Posts: 2
Joined: 22. August 2019 12:58
XAMPP version: 3.2.4
Operating System: windows 10


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 127 guests