Error: MySQL shutdown unexpectedly.

[ArGoMo]

So today Mysql started giving me this error, I didn't change any configuration at all and I really don't know what to do. I was going to create a backup for the DB in case something breaks in the future and I find this log:

InnoDB: using atomic writes.
2020-01-22 13:02:57 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-01-22 13:02:57 0 [Note] InnoDB: Uses event mutexes
2020-01-22 13:02:57 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-01-22 13:02:57 0 [Note] InnoDB: Number of pools: 1
2020-01-22 13:02:57 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-01-22 13:02:57 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-01-22 13:02:57 0 [Note] InnoDB: Completed initialization of buffer pool
2020-01-22 13:02:57 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-01-22 13:02:57 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-01-22 13:02:57 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-01-22 13:02:57 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-01-22 13:02:57 0 [Note] InnoDB: 10.4.8 started; log sequence number 485608508; transaction id 274346
2020-01-22 13:02:57 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-01-22 13:02:57 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-01-22 13:02:57 0 [Note] Server socket created on IP: '::'.
2020-01-22 13:02:57 0 [Note] InnoDB: Buffer pool(s) load completed at 200122 13:02:57
2020-01-22 13:02:57 7 [Note] Reading Master_info: 'master-2020@002d01@002d20@002013@003a05@003a40@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info' Relay_info:'relay-log-2020@002d01@002d20@002013@003a05@003a40@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
2020-01-22 13:02:57 7 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--log-basename=#' or '--relay-log=mysql-relay-bin' to avoid this problem.
2020-01-22 13:02:57 7 [ERROR] log 2020-01-20 13:06:14 7 [Note] Initialized Master_info from 'master-2020@002d01@002d20@002013@003a05@003a40@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
listed in the index, but failed to stat
2020-01-22 13:02:57 7 [ERROR] Error counting relay log space
2020-01-22 13:02:57 7 [ERROR] Initialized Master_info from 'master-2020@002d01@002d20@002013@003a05@003a40@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info' failed
2020-01-22 13:02:57 7 [Note] Added new Master_info '2020-01-20 13:05:40 0 [Note] Reading of all Master_info entries succeeded
' to hash table
2020-01-22 13:02:57 7 [Note] Reading Master_info: 'master-2020@002d01@002d20@002013@003a05@003a40@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info' Relay_info:'relay-log-2020@002d01@002d20@002013@003a05@003a40@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
2020-01-22 13:02:57 7 [Note] Initialized Master_info from 'master-2020@002d01@002d20@002013@003a05@003a40@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
2020-01-22 13:02:57 7 [Note] Added new Master_info '2020-01-20 13:05:40 0 [Note] Added new Master_info '' to hash table
' to hash table
2020-01-22 13:02:57 8 [Note] Master '2020-01-20 13:05:40 0 [Note] Added new Master_info '' to hash table
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2020-01-22 13:02:57 7 [Note] Started replication for '2020-01-20 13:05:40 0 [Note] Added new Master_info '' to hash table
'
2020-01-22 13:02:57 9 [Note] Master '2020-01-20 13:05:40 0 [Note] Added new Master_info '' to hash table
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2020@002d01@002d20@002013@003a05@003a40@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000009' position: 4
2020-01-22 13:02:57 8 [ERROR] Master '2020-01-20 13:05:40 0 [Note] Added new Master_info '' to hash table
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2020-01-22 13:02:57 7 [Note] Reading Master_info: 'master-2020@002d01@002d20@002013@003a05@003a40@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info' Relay_info:'relay-log-2020@002d01@002d20@002013@003a05@003a40@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
2020-01-22 13:02:57 8 [Note] Master '2020-01-20 13:05:40 0 [Note] Added new Master_info '' to hash table
': Slave I/O thread killed while connecting to master
2020-01-22 13:02:57 8 [Note] Master '2020-01-20 13:05:40 0 [Note] Added new Master_info '' to hash table
': Slave I/O thread exiting, read up to log 'FIRST', position 4
2020-01-22 13:02:58 7 [Note] Initialized Master_info from 'master-2020@002d01@002d20@002013@003a05@003a40@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
2020-01-22 13:02:58 7 [Note] Added new Master_info '2020-01-20 13:05:40 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
' to hash table
2020-01-22 13:02:58 10 [Note] Master '2020-01-20 13:05:40 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2020-01-22 13:02:58 7 [Note] Started replication for '2020-01-20 13:05:40 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
'
2020-01-22 13:02:58 11 [Note] Master '2020-01-20 13:05:40 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2020@002d01@002d20@002013@003a05@003a40@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000009' position: 4
2020-01-22 13:02:58 10 [ERROR] Master '2020-01-20 13:05:40 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2020-01-22 13:02:58 7 [Note] Reading Master_info: 'master-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info' Relay_info:'relay-log-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
2020-01-22 13:02:58 10 [Note] Master '2020-01-20 13:05:40 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave I/O thread killed while connecting to master
2020-01-22 13:02:58 10 [Note] Master '2020-01-20 13:05:40 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave I/O thread exiting, read up to log 'FIRST', position 4
2020-01-22 13:02:58 7 [Note] Initialized Master_info from 'master-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
2020-01-22 13:02:58 7 [Note] Added new Master_info 'Version: '10.4.8-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
' to hash table
2020-01-22 13:02:58 12 [Note] Master 'Version: '10.4.8-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2020-01-22 13:02:58 7 [Note] Started replication for 'Version: '10.4.8-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
'
2020-01-22 13:02:58 13 [Note] Master 'Version: '10.4.8-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000008' position: 4
2020-01-22 13:02:58 12 [ERROR] Master 'Version: '10.4.8-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2020-01-22 13:02:58 0 [Warning] Reading of some Master_info entries failed
2020-01-22 13:02:58 12 [Note] Master 'Version: '10.4.8-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
': Slave I/O thread killed while connecting to master
2020-01-22 13:02:58 0 [ERROR] Failed to initialize multi master structures
2020-01-22 13:02:58 12 [Note] Master 'Version: '10.4.8-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
': Slave I/O thread exiting, read up to log 'FIRST', position 4
2020-01-22 13:02:58 0 [ERROR] Aborting

the version of xampp I´m using is 3.2.4 showing the error trace:

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

[ArGoMo]

Solved the issue by reinstalling xampp, notify me if someone founds a solution to this problem apart from reinstalling xampp

[alnolan]

There seems to be a few scenarios that can cause this but what I ended up doing was to copy all files from drive:\xampp\mysql\backup to drive:\xampp\mysql\data and viola mysql starts from the xampp control panel. Ive also read that runnin the xampp control panel without running it as administrator can be what causes your db data files to get corrupt in the first place, so be sure to run as admin. Hope this helps!

[juanchoarboleda1]

There seems to be a few scenarios that can cause this but what I ended up doing was to copy all files from drive:\xampp\mysql\backup to drive:\xampp\mysql\data and viola mysql starts from the xampp control panel. Ive also read that runnin the xampp control panel without running it as administrator can be what causes your db data files to get corrupt in the first place, so be sure to run as admin. Hope this helps!

Thanks. This fixed the problem.

The only issue is you will loose users db. Anyhow, much better than re-installing xampp