Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Help Decoding SQL - Hack Attempt?
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Rick5150
Starting Member

2 Posts

Posted - 01/31/2013 :  04:42:44  Show Profile  Reply with Quote
In my mysql_slow_queries logs I am getting data like this, and I fear I am getting hacked... Can anyone explain what the code means?

# Thu Jan 31 01:49:42 2013
# Query_time: 4.551053  Lock_time: 0.003295 Rows_sent: 1  Rows_examined: 1
use mysite_wrd1;
SET timestamp=1359622182;
SHOW columns from customers LIKE 'guest_account'


# Thu Jan 31 01:41:46 2013
# Query_time: 1.161772  Lock_time: 0.032310 Rows_sent: 1  Rows_examined: 307589
use mysite_php1;
SET timestamp=1359621706;
SELECT user_id
  FROM WWH_TABLE
  WHERE user_ip = '220.200.49.12'
 LIMIT 1


# Thu Jan 31 01:41:35 2013
# Query_time: 18.222432  Lock_time: 4.215960 Rows_sent: 1  Rows_examined: 1
use mysite_php1;
SET timestamp=1359621695;
SELECT u.*, s.*
  FROM phpbb_sessions s, phpbb_users u
  WHERE s.session_id = 'def72a54e16508d34a1d02161318a0e9'
  AND u.user_id = s.session_user_id


# Thu Jan 31 01:41:35 2013
# Query_time: 13.815010  Lock_time: 2.111738 Rows_sent: 0  Rows_examined: 1
use mysite_php1;
SET timestamp=1359621695;
UPDATE phpbb_config
		SET config_value = '1359621681'
		WHERE config_name = 'rand_seed_last_update'

visakh16
Very Important crosS Applying yaK Herder

India
52326 Posts

Posted - 01/31/2013 :  05:00:01  Show Profile  Reply with Quote
this is ms sql server forum.
you may be better off posting mysql questions on some mysql forums like www.dbforums.com

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

Rick5150
Starting Member

2 Posts

Posted - 01/31/2013 :  05:29:40  Show Profile  Reply with Quote
I am such an idiot. Thank you for the link.
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000