I connect to mysql client using the command
mysql -uroot -p
And I execute queries there. If I press the up arrow, i could see the history of almost all the queries there. Where will this query log be stored.
I found a log file under /var/log/mysql/mysql.log
and I indeed see some logging happening there. But it has queries from other users as well. However, I only need queries executed by the specific user (root
in this case). How to get it? Please help me.
Note: I need to debug some logs, so a solution to filter these logs with the existing setup would be great.
History for
root
is stored in/root/.mysql_history
.