Error: mySQL shutdown unexpectedly.

[jac daniel]

Hi guys,

Got this error after a clean installation and migration of my wordpress site:

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

I saw that this error has been posted a number of times by other users, and that a reply to one of these posts was that there's no 'one solution that fits all' as far as this error's concerned.

So to be more specific -

Having click on the mysql_error.log it indicates that it is related to plugins that failed to initialize. Here's the relevant extract:

2021-03-04 17:55:12 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-03-04 17:55:12 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-03-04 17:55:12 0 [Note] InnoDB: 10.4.17 started; log sequence number 21544873; transaction id 4014
2021-03-04 17:55:12 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-03-04 17:55:12 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-03-04 17:55:12 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2021-03-04 17:55:12 0 [ERROR] Failed to initialize plugins.
2021-03-04 17:55:12 0 [ERROR] Aborting

If anyone knows how I fix this it will be much appreciated. I was thinking that perhaps I have to delete some installation files or something, but really have no real idea.

Gaz

[nascoli]

I have the same problem and no solution so far.

[jac daniel]

UPDATE:

Not sure but I saw something to do with this:

Resizing the ibtmp1 file in MySQL (from the 12MB indicated by the error up to say,1GB for example).

I'm using Windows 10. Not sure if I'm on the right lines with this, or what even the correct procedure would be to take for Windows to do this.