Mysql connection error on xampp

Question

Hi, I keep receving this error on xampp: "Error: MySQL shutdown unexpectedly. This may be due to a blocked port, missing dependencies, improper privileges, a crash, or a shutdown by another method".

I tried to create a new data folder with the old ibdata file, which helped me with the connection to Mysql, but I had my database deleted as result of that, so I'd better get another solution this time.

Here comes the entire error:
2022-08-15 13:24:56 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-08-15 13:24:56 0 [Note] InnoDB: Uses event mutexes
2022-08-15 13:24:56 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-08-15 13:24:56 0 [Note] InnoDB: Number of pools: 1
2022-08-15 13:24:56 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-08-15 13:24:56 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-08-15 13:24:56 0 [Note] InnoDB: Completed initialization of buffer pool
2022-08-15 13:24:56 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-08-15 13:24:56 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-08-15 13:24:56 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-08-15 13:24:56 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-08-15 13:24:56 0 [Note] InnoDB: Waiting for purge to start
2022-08-15 13:24:56 0 [Note] InnoDB: 10.4.24 started; log sequence number 1431981; transaction id 1629
2022-08-15 13:24:56 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-08-15 13:24:56 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-08-15 13:24:56 0 [Note] InnoDB: Buffer pool(s) load completed at 220815 13:24:56
2022-08-15 13:24:56 0 [Note] Server socket created on IP: '::'.

Thanks in advance!

Answer 1

As Xampp is a software-package, including a mySQL (which is an Oracle product!) database... posting your question in an Microsoft forum, might not bring you a helpful answer...

and your posted "error message" does NOT contain any error, from that text I would expect that the mySQL engine is running fine (but maybe your are missing your database)

from my personal experience, move your ibdata file to a secure folder, delete all user databases in your mySQL, re-create that one database, shutdown the service/engine, replace the new ibdata with the old, restart the service and hope it come up fine...

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)