Show Database Creation Date

There is currently (Oct-2023) no way to retrieve the database creation time. However, you can retrieve the creation time of the first table...

SELECT table_schema "Database",

       MAX(create_time)

  FROM information_schema.tables

 WHERE table_type='BASE TABLE'

   AND table_schema NOT IN('information_schema', 'mysql', 'performance_schema', 'sys')

 GROUP BY table_schema;

Show Database Size

Use this query to show how large each database is...

SELECT table_schema "DB Name",

       ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) "DB Size MB",

       ROUND(SUM(data_length + index_length) / 1024 / 1024 / 1024, 1) "DB Size GB"

  FROM information_schema.tables 

 GROUP BY table_schema; 

Bibliography