Check and Repair All MySQL Databases on Ubuntu

The following command can be used to check and repair all MySQL databases on a Ubuntu or Debian Linux System. I’ve tested the commands on Ubuntu 20.04 and Debian 10.

Repair MySQL databases on Ubuntu Linux

sudo mysqlcheck --defaults-file=/etc/mysql/debian.cnf --auto-repair --optimize --all-databases

MySQL database repair on Debian

mysqlcheck --defaults-file=/etc/mysql/debian.cnf --auto-repair --optimize --all-databases

The benefit of the above command is that it uses the debian-sys-maint login to MySQL which is available on every Debian and Ubuntu System, so you don’t have to provide the MySQL root login details.

The post Check and Repair All MySQL Databases on Ubuntu appeared first on FAQforge.

Ubuntu Server Admin

Recent Posts

Ubuntu MATE 26.10 Release Notes

Lo and behold 👐, Ubuntu MATE 26.10 (Stonking Stingray) is here! 🎊 We are back…

1 week ago

How to Deploy Kiwix Server on Ubuntu VPS

This article provides a guide demonstrating how to deploy Kiwix Server on Ubuntu VPS. What…

1 week ago

How to Host a Discord Bot on Ubuntu VPS

This article provides a guide demonstrating how to host a Discord bot on Ubuntu VPS.…

2 weeks ago

Myna speech-to-text is now available as a technology preview

A few months ago, we introduced Myna, our project to bring private, local speech-to-text dictation…

2 weeks ago

What’s new in security for Ubuntu 26.10?

Ubuntu 26.10 “Stonking Stingray” arrives at a time when AI tools are accelerating vulnerability discovery.…

2 weeks ago

Devpack for Rust: Zero to Rust in seconds

One of the best things about Rust is how easy it is to get started.…

3 weeks ago