CODEWITHSUNDEEP
mysql
Citizen
Citizen

Reputation: 12957

MySQL Database Hacked, how can I tell which rows were affected?

I have a database that was compromised. It's a very big content table and I don't know if any of the rows were altered. Is there a way in MySQL to see which rows were edited and when?

Upvotes: 0

Views: 747

Answers (2)

Ankit Sharma
Ankit Sharma

Reputation: 4069

You can use The General Query Log to track down the queries if its not turned off. For future you can use this steps mentioned in answer to set the query log How to show the last queries executed on MySQL?.

Upvotes: 1

Niko Hujanen
Niko Hujanen

Reputation: 733

If it was compromised by injection you have to crawl through HTTP server's access log. MySQL has a query logging ability but it's "always" disabled since it seriously slows down the server. Otherwise: No.

Upvotes: 4

Related Questions