I want to find all the queries executed by an particular user in a database over a period of time in MYSQL. Even they executed query by using MYSQL workbench i want to see log in my Database cloud server. Is there any possible there in MYSQL.

Thanks in advance.

  • 2
    What version of MySQL? Do you have an 'audit' or 'authentication' plugin installed?
    – Rick James
    Jun 28, 2019 at 17:42
  • i have used MYSQL 5.6 version and it installed centos 6.5. Jun 29, 2019 at 11:58
  • If you have not turned on the "general log", nor have any type of auditing plugin, then the information you request is not available.
    – Rick James
    Jun 29, 2019 at 14:35


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.