Check error in mysql

Check all tables and all databases:
mysqlcheck -c -u root -p --all-databases

Check all tables in pippo and pluto databases:
mysqlcheck -c -u root -p --databases pippo pluto

Check, optimize, and repair tables all databases:
mysqlcheck -u root -p --auto-repair -c -o --all-databases