This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-17. For the latest, interactive version please visit https://mariadb.com/kb/.

Crashed site

After a Windows update the Mysql (MariaDb 10.4.8) my Xampp installation wouldn't start up and gave as error message "Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.## files".

When I do so I get the long list of messages shown below. After finishing it I can start mysql but I cannot use it as the user/password combination is no longer recognized. What can I do to get out of this situation?

Output of aria-chk:
mysql.db
info : Wrong CRC on datapage at 1
info : Wrong CRC on datapage at 2
info : Wrong CRC on datapage at 3
info : Wrong CRC on datapage at 4
[Removed entries for 5 to 520]
info : Wrong CRC on datapage at 521
info : Wrong CRC on datapage at 522
status : OK
mysql.event OK
mysql.func OK
mysql.global_priv
warning : Number of rows changed from 0 to 6
status : OK
mysql.gtid_slave_pos
note : The storage engine for the table doesn't support repair
mysql.help_category
warning : Number of rows changed from 0 to 40
status : OK
mysql.help_keyword
warning : Number of rows changed from 0 to 475
status : OK
mysql.help_relation
warning : Number of rows changed from 0 to 1059
status : OK
mysql.help_topic
warning : Number of rows changed from 0 to 529
status : OK
mysql.index_stats OK
mysql.innodb_index_stats
note : The storage engine for the table doesn't support repair
mysql.innodb_table_stats
note : The storage engine for the table doesn't support repair
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv
warning : Number of rows changed from 0 to 1
status : OK
mysql.roles_mapping OK
mysql.servers OK
mysql.slave_master_info
note : The storage engine for the table doesn't support repair
mysql.slave_relay_log_info
note : The storage engine for the table doesn't support repair
mysql.slave_worker_info
note : The storage engine for the table doesn't support repair
mysql.table_stats OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.transaction_registry
note : The storage engine for the table doesn't support repair
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.