Question

How to display the queries executed by a particular user in MySQL

Answer 1

From the version 5.1.7 onward, MySQL allows to use the PROCESSLIST table of the INFORMATION_SCHEMA. So a query similar to this can be used:

SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER='<name_of_the_user>';

Hope this helps,

Happy Learning!