This question already has an answer here:
- Mysql remote connections logging 1 answer
I have a website to which I have allowed someone to enter to make some modifications. However, I have discovered that they made changes that compromised the security of the website and I know that the changes made would have sent queries to a MySQL database on the server.
What I would like to know is, is it possible either via plesk or SSH to view MYSQL query logs relative to a specific IP address (the IP address the guy who compromised the site).
On an additional note, I am very new to SSH, so if you can recommend any use of this please make sure they're dumbed down instructions.
Many thanks :)