Question finding plesk database id

[erkanboz032]

Server operating system version

Ubuntu 22.04.3 LTS

Plesk version and microupdate number

Plesk Obsidian 18.0.55

database: Databases

The database utility is used to manage databases and database users in Plesk through CLI. By using this utility, you ...

docs.plesk.com

I am creating a database with the create command from the API above. After creating it, it gives a database id. There is no problem with this. What I want is to retrieve the database ids previously created on the hosting. If you have the knowledge, I would be happy to help you.

 

[Peter Debik]

As far as I know there is no history of past database creation processes. Instead, you could add an event trigger "Database created" that calls a script each time a database is created. Then you can log all these transactions to build a history of events. You could also examine the file timestamps in /var/lib/mysql for user database directories. From there you can find the most recently created databases and - if you need more data on them - query MariaDB (or MySQL) on them.