how to check mysql database tables code example Example 1: show tables mysql SHOW TABLES; Example 2: mysql check all tables mysqlcheck -c mydatabasename -u root -p