how to see all tables of databases in mysql code example Example 1: mysql show all tables show tables; Example 2: mysql command line see all databases SHOW DATABASES;