[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 275
  • Last Modified:

we are using mysql 5.1.39. how to know which user has run a particular statement.

we are using mysql 5.1.39.


a) how to know which user or through which machine a particular statement was executed.
Is it through bin logs or log file.

b) If we don't know exactly the time when the update/insert statement was run to look into the binlog, but know the primary id and the date we need to check for any modifications done. How to look into this.

0
Jsara
Asked:
Jsara
  • 2
1 Solution
 
JsaraAuthor Commented:
thanks, it answers my question to some extent, how to corelate this with who exceuted a particular statement or made a change to the record or deleted or infact inserted a new record.
0
 
Steve BinkCommented:
The article's images show this to you.  Specifically, see the second image for how information from the log can be used to identify the user running the query, time and date of the request, and the full text of the command.

http://3.bp.blogspot.com/_bOa3aOPXCQo/SYyTLCScVHI/AAAAAAAAAFY/_oH661nPqTc/s1600-h/mysql_2.png
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now