SQL Server Forums
Profile | Register | 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?
 New Topic  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
52309 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  
 New 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.1 seconds. Powered By: Snitz Forums 2000