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.

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

Run the query in your favourite tool (like HeidiSQL)






More hints here

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


Hits: 470

Share area

Leave a Reply

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