Is there any way to retrieve the history of all queries executed on a MySql server?

Question

Is there any way to retrieve the history of all queries executed on a MySql server?

Navigation

#1 by (1 votes)

0

I have a transaction in a table of a MySql database and (php + apache). I was wondering if I could retrieve (either in the apache log or in the MySql log) the ip from where the query that made this insert was generated. Any ideas?

mysql apache

asked by anonymous 26.03.2018 / 22:39

1 answer

Turn a search into a field that you dial when clicking on the cell Create array and count values

score 1 · Accepted Answer

It is called general query log and is disabled by default. By enabling it, the server will store each operation performed; it is worth reading documentation on the subject as it is possible to create a list of SQL commands that you do not need to save in the log.