How to get the list of tables using a query

Sometimes you can not enter phpMyAdmin to see the list of tables, use this query somewhere in your code to test:
select table_name from information_schema.tables where TABLE_TYPE = 'BASE TABLE'