How to check the creation date of your databases (MySQL)

The Query

If you have a lot of databases and you want to check their creation dates just run this SELECT.

If the ‘create_time’ is null then your user won’t have the necessary permissions.

SELECT
    table_schema,
    MAX(create_time) create_time,
FROM information_schema.tables
-- where TABLE_SCHEMA ='myDb' -- uncomment for specific database
GROUP BY TABLE_SCHEMA
SORT BY create_time

More hints here

How to run MySQL 5.7 in K/Ubuntu 20.04 with docker here

Hits: 8

Share area

Leave a Reply

Your email address will not be published. Required fields are marked *

Scroll Up