List tables in all the databases

Question

I have three databases in mysql. And I would like to list all the tables in each database. How can I achieve this?

Answer 1

select table_schema as database_name, table_name
    from information_schema.tables
where table_type = 'BASE TABLE'
    and table_schema not in ('information_schema','mysql',
                             'performance_schema','sys')
order by database_name, table_name;