Is it possible to see recent activity on a MySQL Database using PHPMyAdmin?

Question

I've used this tool to manage MySQL databases on several hosting sites. Does anyone know how to do this?

Answer 1

In order to track history, you need to enable the "SQL history feature" of phpMyAdmin. You can find details on how to do this on the documentation site.

One thing to note is that the SQL history feature will only track commands entered via the phpMyAdmin interface. If you're looking for specific transaction history on a given table that an application does, you will need to implement some kind of tracking or log feature into the application(s) involved.

Depending on how things are setup, you may be able to access the binary log of the MySQL database itself through phpMyAdmin. You'll need to look into your current database configuration to see where/how to access it.

Answer 2

it's not exactly what you mean but when you go to status tab it gathered some information for you:

you can get some info but not exactly get the time.