Display / Select all tables from all the data bases in MySql

Selects / Displays all the tables that are present in the data base from all the data bases;

SELECT *
FROM information_schema.Tables;


Use this following command for more precise data.

SELECT table_name, table_type, engine
    -> FROM information_schema.tables
    -> WHERE table_schema = 'db5'
    -> ORDER BY table_name DESC;