• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 295
  • Last Modified:

How to tell if MySQL was hacked

Hello,

We have a website with apps/DBs running on mySQL.  User feels one of the DBs may have been hacked and certain words put into a table.

Is there a log we can review with activity or a way to tell if this is old or recent?

Thanks
0
btny
Asked:
btny
  • 2
2 Solutions
 
vinurajrCommented:
Activities can be logged like Username ,LoginTime,Logouttime and so on... but this wouldnt tell is hacked or not but can track who and all used at a poin of time....
0
 
HMoellendorfCommented:
Hi btny,

you should have a backup and then you could find differncies. This could also a way to check if you have been hacked. Another way doesn't exists, because mySql doesn't save any connection.

Kind regards,
Henning
0
 
HMoellendorfCommented:
Hi,

the deletion request is not permitted, because my comment reflects and answers the question of the user.
There is no better answer I think.

Please review this deletion request.

Kind regards,
Henning
0
 
btnyAuthor Commented:
Thanks for your input.

Both solutions helped, we wound up adding tables which show timestamps, etc.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now