Is it possible to get the information of which user changed what in a database? I'm trying to create a log of changes in a given table in a database.
To do this, I'm going to get the info about all the fields in the original table and create a new one using a function.

In addition to the fields in the original table, the new table should contain the time of the change, the type of the change (insert, delete, update) and an identification of the user that made the change.

I've figured out where I can get the information about the columns of the original table in MySQL (table INFORMATION_SCHEMA.Columns), but I don't know where I can find the information related to the user.

Can anyone please point me in the right direction?
The right direction for this is to use an audit logging plugin. There are some choices out there. Please check out the following post for more information

http://www.mysqlperformanceblog.com/2014/05/20/database-auditing-alternatives-mysql/

My personal preference is the Percona Audit Plugin but you should be using Percona Server (MySQL Alternative) for this.