Solved

How to tell if MySQL was hacked

Posted on 2009-03-30
5
255 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Problem sending file attachments 8 24
Checking if varaible is empty 6 31
php function to remove a file 26 11
PHP Sessions in WordPress 8 9
It is possible to boost certain documents at query time in Solr. Query time boosting can be a powerful resource for finding the most relevant and "best" content. Of course the more information you index, the more fields you will be able to use for y…
This article discusses how to create an extensible mechanism for linked drop downs.
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
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 …

867 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

22 Experts available now in Live!

Get 1:1 Help Now