Repair all MySQL databases

If you need to check and repair all MySQL databases you can use:

mysqlcheck -u USER -p -Ar

If you also want to optimize them, use:

mysqlcheck -u USER -p -Aor

-A: all databases
-o: optimize
-r: repair

Have a look at the man page of mysqlcheck for more information.