I am using Mysql 5.7 and 2-days back someone drop my table. I didn't enable my general log. How can i find the username who dropped the table?

  • Welcome to the site , By default, the server writes files for all enabled logs in the data directory. Did you checked that. – Md Haidar Ali Khan Feb 26 '18 at 6:41
  • Did you have the binlog turned on? – Rick James Mar 3 '18 at 23:35
  • yes. Its configure for replication. – Irfi Mar 6 '18 at 9:37

By default MySQL doesnot log general SQL statements. Configure MySQL to do so. The MySQL documentation on logging (MySQL :: MySQL 5.1 Reference Manual :: 5.2 MySQL Server Logs) should help you do that.

| improve this answer | |
  • Unfortunately, i didn't enable general log when the table was dropped. From which server logs i can get my desired information – Irfi Feb 27 '18 at 4:27

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.