My boss wants to have some kind of log on the server running mysql which would log user activity.
Kind of like:
- User blah logged in
- User blah ran some query
- User blah logedd off
- User asdf logged on
- ..and so on
I did some research and found out about triggers: How to log successful login attempts to a database?
Also, is that information logged into the mysql general log?
- mysql is installed on a server running Redhat
- Installed mysql version is: 5.0.91
I'm not a DBA, so please go easy on me! Thanx in advance!