How can I find the user who performed a database transaction?
Yes you can find what you are looking for in mysql log files.
Binary Log keeps track of the transactions that describe database changes such as table creation operations or changes to table data. 

Query Log keeps track of all operations including Select and Show statements.

Both log files describe the action with the user who performed it.

This link is a tutorial for how to read binary log file.