12:24:56 [mysql] Attempting to start MySQL app...
12:24:56 [mysql] Status change detected: running
12:29:31 [mysql] Status change detected: stopped
12:29:31 [mysql] Error: MySQL shutdown unexpectedly.
12:29:31 [mysql] This may be due to a blocked port, missing dependencies,
12:29:31 [mysql] improper privileges, a crash, or a shutdown by another method.
12:29:31 [mysql] Press the Logs button to view error logs and check
12:29:31 [mysql] the Windows Event Viewer for more clues
12:29:31 [mysql] If you need more help, copy and post this
12:29:31 [mysql] entire log window on the forums
Looking in the log file I saw the following:
2022-02-01 12:24:57 0 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2022-02-01 12:24:57 0 [ERROR] Plugin 'Aria' init function returned error.
2022-02-01 12:24:57 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
InnoDB: using atomic writes.
2022-02-01 12:24:57 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-02-01 12:24:57 0 [Note] InnoDB: Uses event mutexes
2022-02-01 12:24:57 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-02-01 12:24:57 0 [Note] InnoDB: Number of pools: 1
2022-02-01 12:24:57 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-02-01 12:24:58 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-02-01 12:24:58 0 [Note] InnoDB: Completed initialization of buffer pool
2022-02-01 12:29:29 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-02-01 12:29:29 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-02-01 12:29:30 0 [Note] InnoDB: Setting file 'D:\xampp73\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-02-01 12:29:30 0 [Note] InnoDB: File 'D:\xampp73\mysql\data\ibtmp1' size is now 12 MB.
2022-02-01 12:29:30 0 [Note] InnoDB: Waiting for purge to start
2022-02-01 12:29:30 0 [Note] InnoDB: 10.4.8 started; log sequence number 32030148760; transaction id 7983255
2022-02-01 12:29:30 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-02-01 12:29:30 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2022-02-01 12:29:30 0 [ERROR] Failed to initialize plugins.
2022-02-01 12:29:30 0 [ERROR] Aborting
Following also some advice on Stackoverflow I tried aria_chk both after just deleting the log file and also deleting the log file and aria_log_control.
After some time the aria error disappeared. But Mysql still shuts down after a minute. In the logfile I see now:
InnoDB: using atomic writes.
2022-02-01 21:33:33 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-02-01 21:33:33 0 [Note] InnoDB: Uses event mutexes
2022-02-01 21:33:33 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-02-01 21:33:33 0 [Note] InnoDB: Number of pools: 1
2022-02-01 21:33:33 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-02-01 21:33:33 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-02-01 21:33:33 0 [Note] InnoDB: Completed initialization of buffer pool
2022-02-01 21:33:34 0 [Note] InnoDB: Resizing redo log from 2*50331648 to 2*524288000 bytes; LSN=32030149168
2022-02-01 21:33:34 0 [Note] InnoDB: Starting to delete and rewrite log files.
2022-02-01 21:33:34 0 [Note] InnoDB: Setting log file D:\xampp73\mysql\data\ib_logfile101 size to 524288000 bytes
2022-02-01 21:33:34 0 [Note] InnoDB: Setting log file D:\xampp73\mysql\data\ib_logfile1 size to 524288000 bytes
2022-02-01 21:33:34 0 [Note] InnoDB: Renaming log file D:\xampp73\mysql\data\ib_logfile101 to D:\xampp73\mysql\data\ib_logfile0
2022-02-01 21:33:34 0 [Note] InnoDB: New log files created, LSN=32030149168
2022-02-01 21:34:32 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-02-01 21:34:32 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-02-01 21:34:32 0 [Note] InnoDB: Setting file 'D:\xampp73\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-02-01 21:34:32 0 [Note] InnoDB: File 'D:\xampp73\mysql\data\ibtmp1' size is now 12 MB.
2022-02-01 21:34:32 0 [Note] InnoDB: Waiting for purge to start
2022-02-01 21:34:33 0 [Note] InnoDB: 10.4.8 started; log sequence number 32030149168; transaction id 7983255
2022-02-01 21:34:33 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp73\mysql\data\ib_buffer_pool
2022-02-01 21:34:33 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-02-01 21:34:33 0 [Note] Server socket created on IP: '::'.
I tried to to run mysqld but after a minute or so it brings me back to the command prompt.
In this forum I saw the following command recommended: mysqld --console --skip-grant-tables --skip-external-locking
I tried it but then too I don't enter the Mysql prompt. I get this output:
2022-02-01 21:11:55 0 [Note] D:\xampp73\mysql\bin\mysqld.exe (mysqld 10.4.8-MariaDB) starting as process 24672 ...
InnoDB: using atomic writes.
2022-02-01 21:11:55 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-02-01 21:11:55 0 [Note] InnoDB: Uses event mutexes
2022-02-01 21:11:55 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-02-01 21:11:55 0 [Note] InnoDB: Number of pools: 1
2022-02-01 21:11:55 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-02-01 21:11:55 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-02-01 21:11:55 0 [Note] InnoDB: Completed initialization of buffer pool
2022-02-01 21:12:15 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-02-01 21:12:15 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-02-01 21:12:15 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-02-01 21:12:15 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2022-02-01 21:12:15 0 [Note] InnoDB: Waiting for purge to start
2022-02-01 21:12:15 0 [Note] InnoDB: 10.4.8 started; log sequence number 32030149150; transaction id 7983255
2022-02-01 21:12:15 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp73\mysql\data\ib_buffer_pool
2022-02-01 21:12:15 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-02-01 21:12:15 0 [Note] InnoDB: Buffer pool(s) load completed at 220201 21:12:15
2022-02-01 21:12:15 0 [Note] Server socket created on IP: '::'.
2022-02-01 21:12:15 0 [Note] Zerofilling moved table: '.\mysql\time_zone_leap_second'
2022-02-01 21:12:15 0 [Note] Zerofilling moved table: '.\mysql\time_zone_name'
2022-02-01 21:12:15 0 [Note] Zerofilling moved table: '.\mysql\time_zone'
2022-02-01 21:12:15 0 [Note] Zerofilling moved table: '.\mysql\time_zone_transition_type'
2022-02-01 21:12:15 0 [Note] Zerofilling moved table: '.\mysql\time_zone_transition'
2022-02-01 21:12:16 7 [Note] Reading Master_info: 'master-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info' Relay_info:'relay-log-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
2022-02-01 21:12:16 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=LAPTOP-JOD2HF4P-relay-bin' to avoid this problem.
2022-02-01 21:12:16 7 [ERROR] Failed to open the relay log '.\mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000001' (relay_log_pos 4)
2022-02-01 21:12:16 7 [ERROR] Could not find target log during relay log initialization
2022-02-01 21:12:16 7 [ERROR] Initialized Master_info from 'master-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info' failed
2022-02-01 21:12:16 7 [Note] Added new Master_info '2020-11-03 17:22:24 0 [Note] Reading of all Master_info entries succ' to hash table
2022-02-01 21:12:16 7 [Note] Reading Master_info: 'master-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info' Relay_info:'relay-log-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
2022-02-01 21:12:16 7 [ERROR] Failed to open the relay log '.\mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000001' (relay_log_pos 4)
2022-02-01 21:12:16 7 [ERROR] Could not find target log during relay log initialization
2022-02-01 21:12:16 7 [ERROR] Initialized Master_info from 'master-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info' failed
' to hash table2:16 7 [Note] Added new Master_info '2020-11-03 17:22:24 0 [Note] Added new Master_info '' to hash table
2022-02-01 21:12:16 7 [Note] Reading Master_info: 'master-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info' Relay_info:'relay-log-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
2022-02-01 21:12:16 7 [ERROR] Failed to open the relay log '.\mysql-relay-bin-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000001' (relay_log_pos 4)
2022-02-01 21:12:16 7 [ERROR] Could not find target log during relay log initialization
2022-02-01 21:12:16 7 [ERROR] Initialized Master_info from 'master-2020@002d11@002d03@002017@003a22@003a24@00200@0020@005bnote@005d@0020d@003a@005cxampp73@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info' failed
2022-02-01 21:12:16 7 [Note] Added new Master_info '2020-11-03 17:22:24 0 [Note] d:\xampp73\mysql\bin\mysqld.exe: ready ' to hash table.
2022-02-01 21:12:16 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'
2022-02-01 21:12:16 7 [ERROR] Failed to open the 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.000001' (relay_log_pos 4)
2022-02-01 21:12:16 7 [ERROR] Could not find target log during relay log initialization
2022-02-01 21:12:16 7 [ERROR] 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' failed
2022-02-01 21:12:16 7 [Note] Added new Master_info 'Version: '10.4.8-MariaDB' socket: '' port: 3306 mariadb.org binar' to hash table
2022-02-01 21:12:16 0 [Warning] Reading of some Master_info entries failed
2022-02-01 21:12:16 0 [ERROR] Failed to initialize multi master structures
2022-02-01 21:12:16 0 [ERROR] Aborting
What should I do to get out of this?