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

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Help Decoding SQL - Hack Attempt?

Author  Topic 

Rick5150
Starting Member

2 Posts

Posted - 2013-01-31 : 04:42:44
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

52326 Posts

Posted - 2013-01-31 : 05:00:01
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 - 2013-01-31 : 05:29:40
I am such an idiot. Thank you for the link.
Go to Top of Page
   

- Advertisement -