This code displays approx size of all databases and tables

databases and tables sizes.sql

-- selects approx size of all databases
SELECT
  table_schema AS "Database",
  SUM( data_length + index_length )/1024/1024 AS "Size, MB"
FROM information_schema.TABLES
GROUP BY table_schema;

SELECT 
  CONCAT(table_schema, '.', table_name) AS "Table", 
  ROUND(((data_length + index_length) / 1024 / 1024), 2) AS "Total size, MB",
  ROUND(((data_length) / 1024 / 1024), 2) AS "Data size, MB",
  ROUND(((index_length) / 1024 / 1024), 2) AS "Index size, MB" 
FROM information_schema.TABLES 
WHERE table_schema NOT IN ("information_schema", "mysql");