Share via

Mysql connection error on xampp

Ylenia_ 21 Reputation points
2022-08-15T11:42:21.823+00:00

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!

SQL Server on Azure Virtual Machines
Azure SQL Database
Azure Database for MySQL
0 comments

Answer accepted by question author

Bjoern Peters 8,921 Reputation points
2022-08-15T13:52:49.087+00:00

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)

Was this answer helpful?

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.