Get record counts for all tables in MySQL database

SELECT table_name, table_rows

FROM INFORMATION_SCHEMA.TABLES 

WHERE TABLE_SCHEMA = YOUR SCHEMA;