MySQL Trigger only for a certain mysql user

Question

I'm trying to find out if a specific MySQL User is still in use in our system (and what queries it is executing).

So I thought of writing a trigger that would kick in anytime user X executes a query, and it would log the query in a log table.

How can I do that? I know how to write a query for a specific table, but not for a specific user (any table).

Thanks

Answer 1

You could branch your trigger function on USER().

Answer 2

The easiest would be to have the trigger always fire, but only logs if the user is X.