MySql can not start since this morning...

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

MySql can not start since this morning...

Postby fatabien » 23. March 2023 11:40

Hello,
XAMPP worked well. Then it does'nt work... ? Why ?

I Can run Apache.
I try and run MySql as an administrator, but it does'nt run.

XAMPP 3.3.0.
Windows 11 (french)

Here's the log. Could you help me please ?

LOG ----------

2023-03-23 11:34:54 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-03-23 11:34:54 0 [Note] InnoDB: Uses event mutexes
2023-03-23 11:34:54 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-03-23 11:34:54 0 [Note] InnoDB: Number of pools: 1
2023-03-23 11:34:54 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-03-23 11:34:54 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-03-23 11:34:54 0 [Note] InnoDB: Completed initialization of buffer pool
2023-03-23 11:34:54 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=486451
2023-03-23 11:34:54 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-03-23 11:34:54 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-03-23 11:34:54 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-03-23 11:34:54 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-03-23 11:34:54 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-03-23 11:34:54 0 [Note] InnoDB: Waiting for purge to start
2023-03-23 11:34:55 0 [Note] InnoDB: 10.4.27 started; log sequence number 486469; transaction id 780
2023-03-23 11:34:55 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-03-23 11:34:55 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-03-23 11:34:55 0 [Note] Server socket created on IP: '::'.
fatabien
 
Posts: 3
Joined: 23. March 2023 11:36
XAMPP version: 3.3.0
Operating System: Windows 11

Re: MySql can not start since this morning...

Postby Altrea » 23. March 2023 11:43

Hi,

your logs don't contain any helpful information about your issue.

Please try to start MariaDB as console application and tell us what log messages you get there:
  • start the XAMPP shell by clicking the [Shell] button in your XAMPP control panel
  • execute the following command
    Code: Select all
    mysqld --defaults-file=mysql\bin\my.ini --standalone --console
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 can not start since this morning...

Postby fatabien » 23. March 2023 13:54

Thank you, here's the result.

---------------------------
# mysqld --defaults-file=mysql\bin\my.ini --standalone --console
2023-03-23 13:55:56 0 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2023-03-23 13:55:56 0 [Note] mysqld (mysqld 10.4.27-MariaDB) starting as process 13180 ...
2023-03-23 13:55:56 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-03-23 13:55:56 0 [Note] InnoDB: Uses event mutexes
2023-03-23 13:55:56 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-03-23 13:55:56 0 [Note] InnoDB: Number of pools: 1
2023-03-23 13:55:56 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-03-23 13:55:56 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-03-23 13:55:56 0 [Note] InnoDB: Completed initialization of buffer pool
2023-03-23 13:55:57 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-03-23 13:55:57 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-03-23 13:55:57 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-03-23 13:55:57 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-03-23 13:55:57 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-03-23 13:55:57 0 [Note] InnoDB: Waiting for purge to start
2023-03-23 13:55:57 0 [Note] InnoDB: 10.4.27 started; log sequence number 486496; transaction id 780
2023-03-23 13:55:57 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-03-23 13:55:57 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-03-23 13:55:57 0 [Note] Server socket created on IP: '::'.
2023-03-23 13:55:57 0 [ERROR] mysqld: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2023-03-23 13:55:57 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2023-03-23 13:55:57 0 [ERROR] Aborting
fatabien
 
Posts: 3
Joined: 23. March 2023 11:36
XAMPP version: 3.3.0
Operating System: Windows 11

Re: MySql can not start since this morning...

Postby Altrea » 23. March 2023 14:39

your mysql database needs to be repaired.

  • open the XAMPP Shell by clicking the Shell button in your XAMPP Control Panel
  • execute the following command:
    Code: Select all
    mysqld --console --skip-grant-tables --skip-external-locking
  • Leave this black command line window open and click on the Shell button in the Control Panel again to open a second command line window and execute this command:
    Code: Select all
    mysqlcheck -r --databases mysql --use-frm
  • you Can close both command line Windows and try to start mysql again normally from your XAMPP control panel
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 can not start since this morning...

Postby fatabien » 23. March 2023 16:25

This runs !!! :-)
Thank you so much !

I would like to know how you knew what I had to do and which commands I had to run.
Where could I learn this please ?

Have a nice day.
fatabien
 
Posts: 3
Joined: 23. March 2023 11:36
XAMPP version: 3.3.0
Operating System: Windows 11

Re: MySql can not start since this morning...

Postby Altrea » 23. March 2023 17:13

Mainly by googling the error message.

This is one of three commonly occuring errors in XAMPPs MariaDB installations.
All of them occure because the control panel don't shutdown MariaDB properly by default.
To prevent this you should consider to register the Windows service for this component. If the windows service for MariaDB is registered, the xampp control panel will use the service too to start and stop MariaDB properly.
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


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 104 guests