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 at 17:42
  • i have used MYSQL 5.6 version and it installed centos 6.5. – Thilakar Raj Jun 29 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 at 14:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.