Error: MySQL shutdown unexpectedly.

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

Error: MySQL shutdown unexpectedly.

Postby yua » 29. November 2021 21:06

2:59:13 PM [mysql] Error: MySQL shutdown unexpectedly.
12:59:13 PM [mysql] This may be due to a blocked port, missing dependencies,
12:59:13 PM [mysql] improper privileges, a crash, or a shutdown by another method.
12:59:13 PM [mysql] Press the Logs button to view error logs and check
12:59:13 PM [mysql] the Windows Event Viewer for more clues
12:59:13 PM [mysql] If you need more help, copy and post this
12:59:13 PM [mysql] entire log window on the forums
yua
 
Posts: 1
Joined: 29. November 2021 13:30
XAMPP version: 3.3.0
Operating System: windows

Re: Error: MySQL shutdown unexpectedly.

Postby macksix » 27. February 2022 21:03

This happens all the time on Windows for me.

Do what Altrea says here: https://community.apachefriends.org/f/viewtopic.php?t=81753&p=275704#p275701

It the above does not fully work, so need to:

1. backup the \xampp\mysql\data folder to data_old folder.

2. Empty data folder and then copy contents of \xampp\mysql\backup to empty data folder.

3. Copy all database folder from data_old folder to data folder, but DO NOT copy mysql, phpmyadmin, performance_schema to data folder.

4. Copy ibdata1 from data_old folder to data folder.

Run MariaDB.

If you get the message: "The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. To find out why click here." in phpMyAdmin, then:

Run this SQL in phpMyAdmin with the phpmyadmin table selected:

Code: Select all
GRANT SELECT, INSERT, UPDATE, DELETE ON phpmyadmin.* TO 'pma'@'localhost';


Then if you had made user(s) before, you will have to make the users again, grant the privileges and use old password. If you don't have old password, make a new one. If you have projects already, the username and password may be in the configuration file for the project and you use those.

I have read if you install as service, which you can do on the Control Panel under the Service column , this won't happen. I am going to start doing that. You have to run Control Panel as Administrator in Windows.
macksix
 
Posts: 2
Joined: 11. February 2022 20:27
XAMPP version: 7.4.27
Operating System: Windows 11

Re: Error: MySQL shutdown unexpectedly.

Postby CathyInCanada » 17. April 2022 22:13

Above did not correct my MySQL not starting. :(

Cannot include the entire log because it's too many characters. Removing [NOTE] lines without following [ERROR]

2022-04-09 14:41:27 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2022-04-09 14:41:27 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2022-04-09 14:41:27 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-04-09 14:41:27 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-04-09 14:41:27 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-04-09 14:41:27 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2022-04-09 14:41:27 0 [ERROR] Aborting
2022-04-09 14:41:28 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2022-04-09 14:41:28 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2022-04-09 14:41:28 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-04-09 14:41:28 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-04-09 14:41:28 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-04-09 14:41:28 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2022-04-09 14:41:28 0 [ERROR] Aborting
2022-04-09 14:41:29 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2022-04-09 14:41:29 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2022-04-09 14:41:29 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-04-09 14:41:29 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-04-09 14:41:29 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-04-09 14:41:29 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2022-04-09 14:41:29 0 [ERROR] Aborting

2022-04-10 11:06:48 0 [Note] Server socket created on IP: '::'.
2022-04-10 11:16:57 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2022-04-10 11:16:57 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2022-04-10 11:16:57 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-04-10 11:16:57 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-04-10 11:16:57 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-04-10 11:16:57 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2022-04-10 11:16:57 0 [ERROR] Aborting
2022-04-10 11:16:58 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2022-04-10 11:16:58 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2022-04-10 11:16:58 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-04-10 11:16:58 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-04-10 11:16:58 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-04-10 11:16:58 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2022-04-10 11:16:58 0 [ERROR] Aborting
Cannot find checkpoint record at LSN (1,0x6cec)
2022-04-10 11:16:59 0 [ERROR] mysqld: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2022-04-10 11:16:59 0 [ERROR] Plugin 'Aria' init function returned error.
2022-04-10 11:16:59 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2022-04-10 11:16:59 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2022-04-10 11:16:59 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2022-04-10 11:16:59 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-04-10 11:16:59 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-04-10 11:16:59 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-04-10 11:16:59 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2022-04-10 11:16:59 0 [ERROR] Failed to initialize plugins.
2022-04-10 11:16:59 0 [ERROR] Aborting
Cannot find checkpoint record at LSN (1,0x6cec)
2022-04-17 13:10:36 0 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2022-04-17 13:10:36 0 [ERROR] Plugin 'Aria' init function returned error.
2022-04-17 13:10:36 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.

2022-04-17 13:10:36 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-04-17 13:10:36 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2022-04-17 13:10:36 0 [ERROR] Failed to initialize plugins.
2022-04-17 13:10:36 0 [ERROR] Aborting
Cannot find checkpoint record at LSN (1,0x6cec)
2022-04-17 13:33:58 0 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2022-04-17 13:33:58 0 [ERROR] Plugin 'Aria' init function returned error.
2022-04-17 13:33:58 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.

2022-04-17 13:33:58 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-04-17 13:33:58 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2022-04-17 13:33:58 0 [ERROR] Failed to initialize plugins.
2022-04-17 13:33:58 0 [ERROR] Aborting
Cannot find checkpoint record at LSN (1,0x6cec)
2022-04-17 13:34:13 0 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2022-04-17 13:34:13 0 [ERROR] Plugin 'Aria' init function returned error.
2022-04-17 13:34:13 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.

2022-04-17 17:27:14 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-04-17 17:27:14 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-04-17 17:27:14 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2022-04-17 17:27:14 0 [Note] InnoDB: Buffer pool(s) load completed at 220417 17:27:14
2022-04-17 17:27:14 0 [ERROR] Failed to initialize plugins.
2022-04-17 17:27:14 0 [ERROR] Aborting
CathyInCanada
 
Posts: 2
Joined: 17. April 2022 22:07
XAMPP version: 3.3.0
Operating System: Windows 10

Re: Error: MySQL shutdown unexpectedly.

Postby CathyInCanada » 18. April 2022 14:03

I ended up reinstalling.
CathyInCanada
 
Posts: 2
Joined: 17. April 2022 22:07
XAMPP version: 3.3.0
Operating System: Windows 10

Re: Error: MySQL shutdown unexpectedly.

Postby pgielen » 09. August 2022 00:55

I have exactly the same problem. From one day to another, MySQL has gone to the dogs, leaving me with an orphaned database of an unfinished website that I am developing on my laptop... I have installed a second copy of xampp in a different directory and that seems to work fine but that does not help if I cannoit transfer the database from the old copy to the new one. Is there any way to make the new copy read the old database? Or can I rescue the database manually, without having to start MySQL? The files appear not to be in a human readable form..

Frustrated,
Pierre :?
pgielen
 
Posts: 2
Joined: 09. August 2022 00:49
XAMPP version: latest
Operating System: Windows 11


Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 7 guests