Error: MySQL shutdown unexpectedly.

[makamo66]

I can start Apache but I can't start MySQL. I get error: MySQL shutdown unexpectedly.
When I tried to start XAMPP, the following appeared as a pop-up:

Windows Defender Firewall has blocked some features of mysqld on all public and private networks. This app has already been blocked or unblocked for a different network type. Allow mysqld to communicate on these networks.

So I turned off all of the firewalls and re-started my computer. It didn't change anything.

This is the error message that I get in mysql_error.log:
InnoDB: using atomic writes.
2021-08-13 19:37:09 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-08-13 19:37:09 0 [Note] InnoDB: Uses event mutexes
2021-08-13 19:37:09 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-08-13 19:37:09 0 [Note] InnoDB: Number of pools: 1
2021-08-13 19:37:09 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-08-13 19:37:09 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-08-13 19:37:09 0 [Note] InnoDB: Completed initialization of buffer pool
2021-08-13 19:37:09 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-08-13 19:37:09 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-08-13 19:37:09 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-08-13 19:37:09 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-08-13 19:37:09 0 [Note] InnoDB: Waiting for purge to start
2021-08-13 19:37:09 0 [Note] InnoDB: 10.4.18 started; log sequence number 314346; transaction id 381
2021-08-13 19:37:09 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-08-13 19:37:09 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-08-13 19:37:09 0 [Note] Server socket created on IP: '::'.

I have XAMPP version 3.2.4 and I'm on a Windows operating system. My drive is set to read-only and I haven't been able to fix this yet even though I've googled a lot and posted in forums. But my drive has been read-only for a month now and XAMPP was working before.

[makamo66]

I found a post similar to mine and this was the answer:

Try to start MariaDB as console application in XAMPP Shell with the following command and tell us what it responses.
CODE:
mysqld --defaults-file=mysql\bin\my.ini --standalone --console

I ran the command and it responded with an avalanche of code. It's too much to post here. Which part should I post?

[Altrea]

the character limit for a post is set to 60000, this should be enough to post 750 line of command line output (at 80 characters per line).

so maybe you can post the last 100 lines, or split it to multiple postings.

[makamo66]

Setting environment for using XAMPP for Windows.
makam@DESKTOP-UERKCNQ c:\xampp
# mysqld --defaults-file=mysql\bin\my.ini --standalone --console
2021-08-14 10:04:46 0 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2021-08-14 10:04:46 0 [Note] mysqld (mysqld 10.4.18-MariaDB) starting as process 4472 ...
InnoDB: using atomic writes.
2021-08-14 10:04:46 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-08-14 10:04:46 0 [Note] InnoDB: Uses event mutexes
2021-08-14 10:04:46 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-08-14 10:04:46 0 [Note] InnoDB: Number of pools: 1
2021-08-14 10:04:46 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-08-14 10:04:46 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-08-14 10:04:46 0 [Note] InnoDB: Completed initialization of buffer pool
2021-08-14 10:04:46 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-08-14 10:04:46 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-08-14 10:04:46 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-08-14 10:04:46 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-08-14 10:04:46 0 [Note] InnoDB: Waiting for purge to start
2021-08-14 10:04:46 0 [Note] InnoDB: 10.4.18 started; log sequence number 314389; transaction id 381
2021-08-14 10:04:46 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-08-14 10:04:46 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-08-14 10:04:46 0 [Note] Server socket created on IP: '::'.
2021-08-14 10:04:46 0 [Note] InnoDB: Buffer pool(s) load completed at 210814 10:04:46
2021-08-14 10:04:46 7 [Note] Reading Master_info: 'master-2021@002d08@002d13@0020@00208@003a56@003a54@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info' Relay_info:'relay-log-2021@002d08@002d13@0020@00208@003a56@003a54@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
2021-08-14 10:04:46 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.
2021-08-14 10:04:46 7 [Note] Initialized Master_info from 'master-2021@002d08@002d13@0020@00208@003a56@003a54@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
2021-08-14 10:04:46 7 [Note] Added new Master_info '2021-08-13 8:56:54 0 [Note] Reading of all Master_info entries succ' to hash table
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4ntries succeeded
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2021-08-14 10:04:46 7 [Note] Started replication for '2021-08-13 8:56:54 0 [Note] Reading of all Master_info entries su'ceeded
': Slave I/O thread killed while connecting to master:54 0 [Note] Reading of all Master_info entries succeeded
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2021@002d08@002d13@0020@00208@003a56@003a54@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000011' position: 4
2021-08-14 10:04:46 7 [Note] Reading Master_info: 'master-2021@002d08@002d13@0020@00208@003a56@003a54@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info' Relay_info:'relay-log-2021@002d08@002d13@0020@00208@003a56@003a54@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
': Slave I/O thread exiting, read up to log 'FIRST', position 4e] Reading of all Master_info entries succeeded
': master was :3306 8 [Note] Master '2021-08-13 8:56:54 0 [Note] Reading of all Master_info entries succeeded
2021-08-14 10:04:46 7 [Note] Initialized Master_info from 'master-2021@002d08@002d13@0020@00208@003a56@003a54@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
' to hash table4:46 7 [Note] Added new Master_info '2021-08-13 8:56:54 0 [Note] Added new Master_info '' to hash table
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4 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
2021-08-14 10:04:46 7 [Note] Started replication for '2021-08-13 8:56:54 0 [Note] Added new Master_info '' to hash tabl'
': Slave I/O thread killed while connecting to master6:54 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-2021@002d08@002d13@0020@00208@003a56@003a54@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000011' position: 4
2021-08-14 10:04:46 7 [Note] Reading Master_info: 'master-2021@002d08@002d13@0020@00208@003a56@003a54@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info' Relay_info:'relay-log-2021@002d08@002d13@0020@00208@003a56@003a54@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
': Slave I/O thread exiting, read up to log 'FIRST', position 4te] Added new Master_info '' to hash table
': master was :3306 10 [Note] Master '2021-08-13 8:56:54 0 [Note] Added new Master_info '' to hash table
2021-08-14 10:04:46 7 [Note] Initialized Master_info from 'master-2021@002d08@002d13@0020@00208@003a56@003a54@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
2021-08-14 10:04:46 7 [Note] Added new Master_info '2021-08-13 8:56:54 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready fo' to hash table
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4xe: ready for connections.
2021-08-14 10:04:46 12 [ERROR] Master '2021-08-13 8:56:54 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
2021-08-14 10:04:46 7 [Note] Started replication for '2021-08-13 8:56:54 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready 'or connections.
': Slave I/O thread killed while connecting to master6:54 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-2021@002d08@002d13@0020@00208@003a56@003a54@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000011' position: 4
2021-08-14 10:04:46 7 [Note] Reading Master_info: 'master-version@003a@0020@002710@002e4@002e18@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@002e18@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
': Slave I/O thread exiting, read up to log 'FIRST', position 4te] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': master was :3306 12 [Note] Master '2021-08-13 8:56:54 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
2021-08-14 10:04:46 7 [Note] Initialized Master_info from 'master-version@003a@0020@002710@002e4@002e18@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
2021-08-14 10:04:46 7 [Note] Added new Master_info 'Version: '10.4.18-MariaDB' socket: '' port: 3306 mariadb.org bina' to hash table
2021-08-14 10:04:46 14 [Note] Master 'Version: '10.4.18-MariaDB' socket: '' port: 3306 mariadb.org binary distributio': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2021-08-14 10:04:46 14 [ERROR] Master 'Version: '10.4.18-MariaDB' socket: '' port: 3306 mariadb.org binary distributi': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2021-08-14 10:04:46 7 [Note] Started replication for 'Version: '10.4.18-MariaDB' socket: '' port: 3306 mariadb.org bi'ary distribution
2021-08-14 10:04:46 14 [Note] Master 'Version: '10.4.18-MariaDB' socket: '' port: 3306 mariadb.org binary distributio': Slave I/O thread killed while connecting to master
2021-08-14 10:04:46 15 [Note] Master 'Version: '10.4.18-MariaDB' socket: '' port: 3306 mariadb.org binary distributio': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-version@003a@0020@002710@002e4@002e18@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000029' position: 4
2021-08-14 10:04:46 7 [Note] Reading Master_info: 'master-2021@002d08@002d13@0020@00208@003a57@003a50@002031@0020@005berror@005d@0020mysqld@002eexe@003a@0020table@0020@0027@002e@005cpp_66@005cbios@0027@0020is@0020marked@0020as@0020crashed@0020and@0020should@0020be@0020repaired@000d.info' Relay_info:'relay-log-2021@002d08@002d13@0020@00208@003a57@003a50@002031@0020@005berror@005d@0020mysqld@002eexe@003a@0020table@0020@0027@002e@005cpp_66@005cbios@0027@0020is@0020marked@0020as@0020crashed@0020and@0020should@0020be@0020repaired@000d.info'
2021-08-14 10:04:46 14 [Note] Master 'Version: '10.4.18-MariaDB' socket: '' port: 3306 mariadb.org binary distributio': Slave I/O thread exiting, read up to log 'FIRST', position 4
2021-08-14 10:04:46 14 [Note] Master 'Version: '10.4.18-MariaDB' socket: '' port: 3306 mariadb.org binary distributio': master was :3306
2021-08-14 10:04:46 7 [ERROR] Error reading master configuration
2021-08-14 10:04:46 7 [ERROR] Initialized Master_info from 'master-2021@002d08@002d13@0020@00208@003a57@003a50@002031@0020@005berror@005d@0020mysqld@002eexe@003a@0020table@0020@0027@002e@005cpp_66@005cbios@0027@0020is@0020marked@0020as@0020crashed@0020and@0020should@0020be@0020repaired@000d.info' failed
2021-08-14 10:04:46 7 [Note] Added new Master_info '2021-08-13 8:57:50 31 [ERROR] mysqld.exe: Table '.\pp_66\bios' is m' to hash tabled and should be repaired
2021-08-14 10:04:46 7 [Note] Reading Master_info: 'master-2021@002d08@002d13@0020@00208@003a57@003a50@002031@0020@005bwarning@005d@0020checking@0020table@003a@0020@0020@0020@0027@002e@005cpp_66@005cbios@0027@000d.info' Relay_info:'relay-log-2021@002d08@002d13@0020@00208@003a57@003a50@002031@0020@005bwarning@005d@0020checking@0020table@003a@0020@0020@0020@0027@002e@005cpp_66@005cbios@0027@000d.info'
2021-08-14 10:04:46 7 [Note] Initialized Master_info from 'master-2021@002d08@002d13@0020@00208@003a57@003a50@002031@0020@005bwarning@005d@0020checking@0020table@003a@0020@0020@0020@0027@002e@005cpp_66@005cbios@0027@000d.info'
' to hash table4:46 7 [Note] Added new Master_info '2021-08-13 8:57:50 31 [Warning] Checking table: '.\pp_66\bios'
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4_66\bios'
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
'021-08-14 10:04:46 7 [Note] Started replication for '2021-08-13 8:57:50 31 [Warning] Checking table: '.\pp_66\bios'
': Slave I/O thread killed while connecting to master7:50 31 [Warning] Checking table: '.\pp_66\bios'
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2021@002d08@002d13@0020@00208@003a57@003a50@002031@0020@005bwarning@005d@0020checking@0020table@003a@0020@0020@0020@0027@002e@005cpp_66@005cbios@0027@000d.000011' position: 4
2021-08-14 10:04:46 7 [Note] Reading Master_info: 'master-2021@002d08@002d13@002010@003a02@003a35@002077@0020@005berror@005d@0020mysqld@002eexe@003a@0020table@0020@0027@002e@005cpp_66@005csurveys@0027@0020is@0020marked@0020as@0020crashed@0020and@0020should@0020be@0020repaired@000d.info' Relay_info:'relay-log-2021@002d08@002d13@002010@003a02@003a35@002077@0020@005berror@005d@0020mysqld@002eexe@003a@0020table@0020@0027@002e@005cpp_66@005csurveys@0027@0020is@0020marked@0020as@0020crashed@0020and@0020should@0020be@0020repaired@000d.info'
': Slave I/O thread exiting, read up to log 'FIRST', position 4arning] Checking table: '.\pp_66\bios'
': master was :3306 16 [Note] Master '2021-08-13 8:57:50 31 [Warning] Checking table: '.\pp_66\bios'
2021-08-14 10:04:46 7 [ERROR] Error reading master configuration
2021-08-14 10:04:46 7 [ERROR] Initialized Master_info from 'master-2021@002d08@002d13@002010@003a02@003a35@002077@0020@005berror@005d@0020mysqld@002eexe@003a@0020table@0020@0027@002e@005cpp_66@005csurveys@0027@0020is@0020marked@0020as@0020crashed@0020and@0020should@0020be@0020repaired@000d.info' failed
2021-08-14 10:04:46 7 [Note] Added new Master_info '2021-08-13 10:02:35 77 [ERROR] mysqld.exe: Table '.\pp_66\surveys' i' to hash tableshed and should be repaired
2021-08-14 10:04:46 7 [Note] Reading Master_info: 'master-2021@002d08@002d13@002010@003a02@003a35@002077@0020@005bwarning@005d@0020checking@0020table@003a@0020@0020@0020@0027@002e@005cpp_66@005csurveys@0027@000d.info' Relay_info:'relay-log-2021@002d08@002d13@002010@003a02@003a35@002077@0020@005bwarning@005d@0020checking@0020table@003a@0020@0020@0020@0027@002e@005cpp_66@005csurveys@0027@000d.info'
2021-08-14 10:04:46 7 [Note] Initialized Master_info from 'master-2021@002d08@002d13@002010@003a02@003a35@002077@0020@005bwarning@005d@0020checking@0020table@003a@0020@0020@0020@0027@002e@005cpp_66@005csurveys@0027@000d.info'
' to hash table4:46 7 [Note] Added new Master_info '2021-08-13 10:02:35 77 [Warning] Checking table: '.\pp_66\surveys'
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4_66\surveys'
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2021-08-14 10:04:46 7 [Note] Started replication for '2021-08-13 10:02:35 77 [Warning] Checking table: '.\pp_66\survey''
': Slave I/O thread killed while connecting to master2:35 77 [Warning] Checking table: '.\pp_66\surveys'
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2021@002d08@002d13@002010@003a02@003a35@002077@0020@005bwarning@005d@0020checking@0020table@003a@0020@0020@0020@0027@002e@005cpp_66@005csurveys@0027@000d.000011' position: 4
2021-08-14 10:04:46 7 [Note] Reading Master_info: 'master-2021@002d08@002d13@002010@003a03@003a17@002082@0020@005berror@005d@0020mysqld@002eexe@003a@0020table@0020@0027@002e@005cpp_66@005crecipes@0027@0020is@0020marked@0020as@0020crashed@0020and@0020should@0020be@0020repaired@000d.info' Relay_info:'relay-log-2021@002d08@002d13@002010@003a03@003a17@002082@0020@005berror@005d@0020mysqld@002eexe@003a@0020table@0020@0027@002e@005cpp_66@005crecipes@0027@0020is@0020marked@0020as@0020crashed@0020and@0020should@0020be@0020repaired@000d.info'
': Slave I/O thread exiting, read up to log 'FIRST', position 4arning] Checking table: '.\pp_66\surveys'
': master was :3306 18 [Note] Master '2021-08-13 10:02:35 77 [Warning] Checking table: '.\pp_66\surveys'
2021-08-14 10:04:46 7 [ERROR] Error reading master configuration
2021-08-14 10:04:46 7 [ERROR] Initialized Master_info from 'master-2021@002d08@002d13@002010@003a03@003a17@002082@0020@005berror@005d@0020mysqld@002eexe@003a@0020table@0020@0027@002e@005cpp_66@005crecipes@0027@0020is@0020marked@0020as@0020crashed@0020and@0020should@0020be@0020repaired@000d.info' failed
2021-08-14 10:04:46 7 [Note] Added new Master_info '2021-08-13 10:03:17 82 [ERROR] mysqld.exe: Table '.\pp_66\recipes' i' to hash tableshed and should be repaired
2021-08-14 10:04:46 7 [Note] Reading Master_info: 'master-2021@002d08@002d13@002010@003a03@003a17@002082@0020@005bwarning@005d@0020checking@0020table@003a@0020@0020@0020@0027@002e@005cpp_66@005crecipes@0027@000d.info' Relay_info:'relay-log-2021@002d08@002d13@002010@003a03@003a17@002082@0020@005bwarning@005d@0020checking@0020table@003a@0020@0020@0020@0027@002e@005cpp_66@005crecipes@0027@000d.info'
2021-08-14 10:04:46 7 [Note] Initialized Master_info from 'master-2021@002d08@002d13@002010@003a03@003a17@002082@0020@005bwarning@005d@0020checking@0020table@003a@0020@0020@0020@0027@002e@005cpp_66@005crecipes@0027@000d.info'
' to hash table4:46 7 [Note] Added new Master_info '2021-08-13 10:03:17 82 [Warning] Checking table: '.\pp_66\recipes'
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4_66\recipes'
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2021-08-14 10:04:46 7 [Note] Started replication for '2021-08-13 10:03:17 82 [Warning] Checking table: '.\pp_66\recipe''
': Slave I/O thread killed while connecting to master3:17 82 [Warning] Checking table: '.\pp_66\recipes'
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2021@002d08@002d13@002010@003a03@003a17@002082@0020@005bwarning@005d@0020checking@0020table@003a@0020@0020@0020@0027@002e@005cpp_66@005crecipes@0027@000d.000011' position: 4
2021-08-14 10:04:46 0 [Warning] Reading of some Master_info entries failed
': Slave I/O thread exiting, read up to log 'FIRST', position 4arning] Checking table: '.\pp_66\recipes'
2021-08-14 10:04:46 0 [ERROR] Failed to initialize multi master structures
': master was :3306 20 [Note] Master '2021-08-13 10:03:17 82 [Warning] Checking table: '.\pp_66\recipes'
2021-08-14 10:04:46 0 [ERROR] Aborting
Warning: Memory not freed: 256

makam@DESKTOP-UERKCNQ c:\xampp
#

[Altrea]

• Open your folder "\xampp\mysql\data"
• Delete the file "multi-master.info"
• Delete all files beginning with "master-"
• Delete all files beginning with "mysql_relay-bin-"
• Delete all files beginning with "relay-log-"
• Delete all files beginning with "ib_logfile"
• Delete all files beginning with "aria_log."

Now try to start mariadb the normal way again.

[makamo66]

Thanks, Altrea. What does that mean to start mariadb? Is that the XAMPP MySQL Start button? Also, I can't start Apache any more either so I can't even view my websites that don't use a database in the browser at localhost now. So I'm not sure deleting files in the mysql directory would even help since I can't start Apache either and that doesn't use the mysql folder.

[Altrea]

What does that mean to start mariadb? Is that the XAMPP MySQL Start button?

The MySQL Button in the XAMPP control panel.

Also, I can't start Apache any more either so I can't even view my websites that don't use a database in the browser at localhost now. So I'm not sure deleting files in the mysql directory would even help since I can't start Apache either and that doesn't use the mysql folder.

That is a separate problem we can try to solve.
For that we need different information: [Q&A] Insufficient debug information - Apache starting issue

[makamo66]

Thanks, Altrea. Instead of deleting all those files, can't I do something less dangerous and re-name the folder and copy over the files that I need back to a new "\xampp\mysql\data" folder?

[Altrea]

If you only delete the named files, there is no risk. This method has brought several MariaDB instances back to life without any data loss.
You can of course copy the mysql/data folder for backup purposes and if something goes horrible wrong copy it back.

[makamo66]

Hi, Altrea. I deleted all the files and I couldn't start Apache the normal way. It just didn't start but I didn't get an error message. So I had to run it as an administrator and when I did it returned an error message and didn't start.

[makamo66]

Something that worries me is all of the log messages about pp_66. pp_66 is one of my databases and maybe I corrupted it when I changed some of the code. But I haven't been working on the other database lately so maybe that's why there are no messages about that one.

[Altrea]

I deleted all the files and I couldn't start Apache the normal way.

Of course not. This should solve your mariaDB problems, not your Apache problems.
And if it does not solve your MariaDB problems, go back to the analysis, so we need new up to date log messages (log files, console window).

[makamo66]

Nothing from today in Apache access.log or Apache error.log. When I try to view the PHP php_error_log, there is a pop-up that says: "The system cannot find the path specified." I deleted all of the content for mysql_error.log and saved the file and then tried to start Apache again but it didn't write anything to this file. That was to be expected. When I tried to start MySQL, it wrote the following:

InnoDB: using atomic writes.
2021-08-14 19:39:18 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-08-14 19:39:18 0 [Note] InnoDB: Uses event mutexes
2021-08-14 19:39:18 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-08-14 19:39:18 0 [Note] InnoDB: Number of pools: 1
2021-08-14 19:39:18 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-08-14 19:39:18 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-08-14 19:39:18 0 [Note] InnoDB: Completed initialization of buffer pool
2021-08-14 19:39:18 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-08-14 19:39:18 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-08-14 19:39:18 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-08-14 19:39:18 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-08-14 19:39:18 0 [Note] InnoDB: Waiting for purge to start
2021-08-14 19:39:18 0 [Note] InnoDB: 10.4.18 started; log sequence number 314901; transaction id 381
2021-08-14 19:39:18 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-08-14 19:39:18 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-08-14 19:39:18 0 [Note] Server socket created on IP: '::'.

[Altrea]

When I try to view the PHP php_error_log, there is a pop-up that says: "The system cannot find the path specified."

Thats a different problem. In path \xampp\php\ create a new empty folder named logs. If this folder is not present, PHP is not able to create the php_error_log file in it.

I deleted all of the content for mysql_error.log and saved the file and then tried to start Apache again but it didn't write anything to this file.

Of course not. Apache do not write anything to MariaDB log files. These are two completely different webserver programs.

When I tried to start MySQL, it wrote the following:
[...]
2021-08-14 19:39:18 0 [Note] Server socket created on IP: '::'.

That last line is a success message that indicates, that MariaDB is not running successful and listening on the specified port(s).

But you still seems to habe problems with Apache.
You really should read the linked Q&A i posted you earlier.

[makamo66]

Thanks for all of the help, Altrea. My httpd.conf file had a typo. I corrected it and now Apache starts but MySQL still doesn't start.

I created a file named \xampp\php\logs\php_error_log
Now when I want to view the PHP error log, XAMPP can find it but after I started Apache, nothing was written to the file.

I read the linked Q&A you posted me earlier and it said I need the full log contents and there was nothing from today in Apache access.log. In Apache error.log, I got the following:

[Sun Aug 15 09:17:29.257974 2021] [ssl:warn] [pid 14048:tid 576] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Sun Aug 15 09:17:29.320573 2021] [core:warn] [pid 14048:tid 576] AH00098: pid file C:/xampp/apache/logs/httpd.pid overwritten -- Unclean shutdown of previous Apache run?
[Sun Aug 15 09:17:29.320573 2021] [ssl:warn] [pid 14048:tid 576] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Sun Aug 15 09:17:29.351744 2021] [mpm_winnt:notice] [pid 14048:tid 576] AH00455: Apache/2.4.46 (Win64) OpenSSL/1.1.1j PHP/7.4.16 configured -- resuming normal operations
[Sun Aug 15 09:17:29.351744 2021] [mpm_winnt:notice] [pid 14048:tid 576] AH00456: Apache Lounge VC15 Server built: Feb 18 2021 10:09:17
[Sun Aug 15 09:17:29.351744 2021] [core:notice] [pid 14048:tid 576] AH00094: Command line: 'c:\\xampp\\apache\\bin\\httpd.exe -d C:/xampp/apache'
[Sun Aug 15 09:17:29.367335 2021] [mpm_winnt:notice] [pid 14048:tid 576] AH00418: Parent: Created child process 6248
[Sun Aug 15 09:17:29.708752 2021] [ssl:warn] [pid 6248:tid 580] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Sun Aug 15 09:17:29.781712 2021] [ssl:warn] [pid 6248:tid 580] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Sun Aug 15 09:17:29.812959 2021] [mpm_winnt:notice] [pid 6248:tid 580] AH00354: Child: Starting 150 worker threads.

This is the log message that I get in mysql_error.log

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