MYSQL get all table names for a specific database.

Here is the sql query to get all the table names of a specific database.

select table_name from information_schema.tables where TABLE_SCHEMA='dbname';