'Customization of mysql log file(Adding and synching diffrent columns to mysql log file)

I am new to mysql, could you help me in find a solution for my requirement?

My requirement is: Mysql log file should be in File format & in log file i have to fetch & view below information

  1. Event date & Time
  2. Database User id /Name
  3. User privilege
  4. Source IP
  5. Destination IP
  6. User privilege
  7. Operation

information from the mysql log file.

I am expecting when I open the 'log' file, I should be able to view

  1. Event date & Time
  2. Database User id /Name
  3. User privilege
  4. Source IP
  5. Destination IP
  6. User privilege
  7. Operation

related information in file format



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source