Solved

How to tell if MySQL was hacked

Posted on 2009-03-30
5
252 Views
Last Modified: 2013-12-12
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
Comment
Question by:btny
  • 2
5 Comments
 
LVL 8

Accepted Solution

by:
vinurajr earned 250 total points
ID: 24026195
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
 
LVL 3

Assisted Solution

by:HMoellendorf
HMoellendorf earned 250 total points
ID: 24026778
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
 
LVL 3

Expert Comment

by:HMoellendorf
ID: 24143484
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
 

Author Closing Comment

by:btny
ID: 31564622
Thanks for your input.

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

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

Developers of all skill levels should learn to use current best practices when developing websites. However many developers, new and old, fall into the trap of using deprecated features because this is what so many tutorials and books tell them to u…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now