SQL Injection Attack Tutorial (2019)

Поделиться
HTML-код
  • Опубликовано: 28 авг 2024

Комментарии • 493

  • @HackhappyOrg
    @HackhappyOrg  6 лет назад +24

    If I get 300 comments on this video I will upload a SQL Injection CTF lab for you to download and practice with.
    Did you like the new format of this video?
    📌Get 5 Hacker Books for $1: goo.gl/DHEUYs

    • @M5REC
      @M5REC 6 лет назад +1

      I liked it. Is this a continuation of your other project from last year? (Bushi Security course on Python for Network Surveillance if I remember correctly? Whats the status of that?)

    • @theelektriccowboy7661
      @theelektriccowboy7661 6 лет назад

      i want it

    • @angelinecaponpon9065
      @angelinecaponpon9065 6 лет назад

      md5('xxx') OR 1 = 1 -- ]');
      105or1=1

    • @farrashaz
      @farrashaz 6 лет назад

      I want SQL Injection CTF lab pleaseeeee

    • @simonskurek8343
      @simonskurek8343 5 лет назад

      171 comments

  • @bgsmurf4e731
    @bgsmurf4e731 5 лет назад +210

    Thank you. Now I hacked NASA and went to federal jail for it.

    • @HackhappyOrg
      @HackhappyOrg  5 лет назад +23

      Thanks for watching bgSmurf4e and be sure to subscribe if you haven't goo.gl/6A36Fc

    • @Dante_bethar
      @Dante_bethar 4 года назад +15

      Great... I'll be sure to join you in a couple of minutes

    • @COURTZYOUTUBE
      @COURTZYOUTUBE 3 года назад +4

      Yoel Cabj lol snitch

    • @Happy-hc4se
      @Happy-hc4se 3 года назад +2

      @@COURTZRUclips man shut the hell up we're stressed out here

    • @sh1ft3r79
      @sh1ft3r79 3 года назад +2

      @@Happy-hc4se lmfao don't take jokes so seriously

  • @DC-of7lp
    @DC-of7lp 4 года назад +72

    SQL Injection attacks: *exist*
    Prepared Statements: I'm about to end this man's whole career

    • @ashleybishton742
      @ashleybishton742 4 года назад +2

      Its not really a career. It doesn't take any hard work at all to bring up databases up. My PC is crawling google right now getting me the targets. It also does the vulnerability and then I run it through sqlmap. Boom all your databases are dumped. Its all automated for me I dont know about anyone else. I find databases all the time. And make money from going back to the companys and hope they reward me for my discovery's I hope they do but not really had success so I ask now if they going to pay me for my services first before I give them the database files back. SQLmap sorts all that out for me.

    • @michaelplayz5972
      @michaelplayz5972 3 года назад +1

      Devs: OOOOOOOOHHHHHHHH

  • @mosesanthony4916
    @mosesanthony4916 5 лет назад +54

    When you are teaching, please be doing it with the targeted url or web so we can get a clear ideas and error we are supposed to encountered and how to navigate our way out and get it right. this tutorial is for those who already have a basic idea.

    • @zitoschouten5068
      @zitoschouten5068 4 года назад +6

      great comment im new to this and have a case abd still have no idea what im doing

    • @Dante_bethar
      @Dante_bethar 4 года назад

      Exactly what I wanted to ask..... Great job....!!

    • @auruds3592
      @auruds3592 3 года назад

      So, how can I learn the basic from Sql Injections?

  • @bradbohn5959
    @bradbohn5959 4 года назад +8

    Thank you for posting this tutorial. I'm wanting to transition into IT and am attending my first cybersecurity meetup at the end of January and the topic is SQL injections. At least I won't be entirely lost! Lol.

  • @sanskarsingh9541
    @sanskarsingh9541 5 лет назад +21

    So vedio was uploaded 8 months ago but it is showing tutorial 2019 .
    *GOOD JOB CREATER* 😂😂

    • @swoluigi3828
      @swoluigi3828 5 лет назад +1

      Dreadnaught 717 thats stating it works IN 2019

    • @sanskarsingh9541
      @sanskarsingh9541 5 лет назад +1

      Swoluigi where ! It just said 2019

  • @DaveAsp81
    @DaveAsp81 5 лет назад +4

    This video helped me so much, you explained everything perfectly and every step was great, I knew a little about SQL injection before watching, but now I feel like I can make much more use of SQL injection attacks in any future CTF's I do.

  • @shanemiller7043
    @shanemiller7043 3 месяца назад

    Great walk-through, thanks!
    I'd like to see a little bit of discussion added about passwords that are encrypted in the database. Just providing some additional context and pointers about that could be useful.

  • @HackhappyOrg
    @HackhappyOrg  5 лет назад +19

    SQL Injection Lab is Here: ruclips.net/video/zYss5J56VBQ/видео.html&lc

    • @ayalafinch-mishkovsky6723
      @ayalafinch-mishkovsky6723 5 лет назад +1

      Thank you that was very helpfull!
      I am trying to write code that recognize SQL injection and prevent it.
      can you show how that works on live? i meen how sql injection works on real websites , and the code behind it.

    • @JediMaster362
      @JediMaster362 5 лет назад

      Looking forward to it.

    • @jiayaoou8254
      @jiayaoou8254 5 лет назад

      could post some bypass way?

    • @mosesanthony4916
      @mosesanthony4916 5 лет назад

      demonstrate it with a real website so we can catch the real message and sink it. lets practice with a real url as you do it and we watch and follow you steps.

  • @roberthorn6707
    @roberthorn6707 6 лет назад +9

    Awesome format. i could easily follow the whole tutorial! Looking forward to the SQL Injection CTF Lab!!!!

  • @Dabo8935
    @Dabo8935 6 лет назад +20

    Awesome videos, keep going pls!!
    Can't wait for the lab
    p.s
    The format is super exciting, easy to follow, great job on that

    • @HackhappyOrg
      @HackhappyOrg  6 лет назад +1

      Thanks, glad it was easy to follow Dabo8935. Thanks for watching!

  • @netballqueens9137
    @netballqueens9137 3 года назад

    finally a decent "how and why it works" tutorial... looking forward to trying your lab

  • @aravindaddula8137
    @aravindaddula8137 4 года назад +1

    Its really great bro,even a guy from other than computer science background can easily understand.keet it up.pls

  • @joshaquatic
    @joshaquatic 3 года назад

    This is the best explanation i have heard yet. But what's with the video just past the 9 minute mark. Your talking head just disappeared.

  • @user-dy4qc5su4w
    @user-dy4qc5su4w Год назад

    Very thorough explanation, thank you!

  • @olawunmiolakunle6856
    @olawunmiolakunle6856 2 года назад

    This tutorial is one the best out there

  • @Ash_Pirate
    @Ash_Pirate 6 лет назад +4

    Yes, i want a CTF lab for practice and i liked the new format of the video. Keep doing...

    • @HackhappyOrg
      @HackhappyOrg  6 лет назад

      Glad you found it useful ASH Sharma. Thanks for watching!

  • @h4k-d424
    @h4k-d424 5 лет назад

    Thanks dude. You explained SQL injection very well. I understand it better now .

  • @patravel-tv3676
    @patravel-tv3676 6 лет назад +1

    Finally someone how can actually explain SQLi :) Thanks!

    • @HackhappyOrg
      @HackhappyOrg  6 лет назад

      Glad you found it useful PaTravel - TV. Thanks for watching!

  • @gurramkondaaslam2033
    @gurramkondaaslam2033 5 лет назад +1

    The explanation of the xxe as well as sql injection was awesome i think if you can start "SAST" course it will be very useful for the beginners. And by the way this was my first comment in the youtube not for course.(Because i got more things from your videos). Thank you.

  • @MukeshSharma-up9lc
    @MukeshSharma-up9lc 5 лет назад +1

    First time I clearly understand sql injection..Thanks men 👍

  • @kemoknows6035
    @kemoknows6035 5 лет назад +1

    Love the video. Thanks for taking the time to make it.

  • @extemporebypriyanka7616
    @extemporebypriyanka7616 4 года назад

    Very informative.. I am now following your videos to elevate my career

  • @chrisrasoa5492
    @chrisrasoa5492 6 лет назад

    More than 100, Can‘t wait to see your next video... by the way greeting from Switzerland 👍🏽

  • @erickreitzer3342
    @erickreitzer3342 4 года назад

    Awesome, simple video. Glad to have stumbled upon your channel. Thanks.

  • @iamgalaxey
    @iamgalaxey 5 лет назад

    Wow you have made this so easy to understand! great work!

  • @olayideayanbisi6520
    @olayideayanbisi6520 Год назад

    Awesome, Lovely Video. You are really good in lecturing as in you are a good teacher. and please, i will like to have the SQL Injection Lab Download.

  • @TigerStrikeReviewsAndMore
    @TigerStrikeReviewsAndMore 3 года назад

    nice i was able to use this to secure some areas of our site

  • @MainEffort
    @MainEffort 5 лет назад +6

    Hey, thanks a lot for this video, you are a TEACHER ! Please keep it coming, waiting for the CTF Lab :)

  • @gustavwahl
    @gustavwahl 5 лет назад +48

    I guess sql injections is already very known now and all developers use prepared statements to avoid this exploit, would be great if you also could inform people about how to prevent this as that is very important as well

    • @bodolawale5448
      @bodolawale5448 5 лет назад

      Will hashing the password work?. Like storing a hashed value of the password in your database

    • @habiuskorpus9329
      @habiuskorpus9329 5 лет назад +5

      @@bodolawale5448 Yes, but you have little control over users using weak passwords so hashing is no guarantee of security, and should never be considered as such. Matching a weak hash might not be too trivial. In reality, you'd probably never encounter plain-text passwords in a database the way is shown in this video (although there have been far too many high-profile instances of just that from large companies that should know better).
      If visitors to your site are able to insert dynamic queries into your database using SQL the damage is done. Bit like shutting the gate after the horse has bolted. Better to prevent this in the first place. Never insert user input into a query dynamically; you have absolutely no idea what that input will be. *My default approach when programming is to assume that all your end users have malicious intent. Just don't ever - EVER - trust user input.*
      Basically lazy coding opens the door to SQL injection. You can prevent it by doing things you should've been doing in the first place: Validation on input fields, sanitize the inserted data before working with it and completely separate the database query from the user data, using prepared statements or stored procedures. That way you can explicitly instruct what data type will be used in place of the temporary placeholders.

    • @leonardfabris1548
      @leonardfabris1548 5 лет назад +1

      get cleaned data when saving forms to database

    • @toma1610
      @toma1610 4 года назад

      You mean mysqli_real_escape_string() function? Should it be a way how to attack this kind of escapes???

  • @enderst81
    @enderst81 6 лет назад +1

    Great video! Labs are fun too, hopefully you get 100.

    • @HackhappyOrg
      @HackhappyOrg  6 лет назад

      Thanks for watching enderst!! We did it!

  • @nveenjain
    @nveenjain 6 лет назад +2

    Yeah I want SQL injection CTF lab... BTW Awesome video.. More stuff in this format please

    • @HackhappyOrg
      @HackhappyOrg  6 лет назад

      Glad you found it useful Naveen Jain. Thanks for watching!

  • @bluekplus1885
    @bluekplus1885 4 года назад +1

    Honestly, This is the simplest Tutorial i will ever see. It's very simple, But there is a problem at 9:14.

  • @jhdzlia
    @jhdzlia 5 лет назад

    Very useful and clear, Thanks! How many comments left to get the lab?

  • @leeguy1183
    @leeguy1183 3 года назад

    This was great, but I didn't understand how you were getting the coding.. But it gave me the basic understanding.

  • @cytechnet
    @cytechnet 6 лет назад +46

    I want the sql injecton ctf lab!!!

  • @sarahghanei1997
    @sarahghanei1997 5 лет назад +3

    That was such a great tutorial , thanks.

  • @NowWhat01
    @NowWhat01 6 лет назад

    You just earned a new subscriber...great content! Now I have to watch it again so I can create a cheat sheet.

  • @rukotanaavianrogers7924
    @rukotanaavianrogers7924 4 года назад

    Awesome tutorial. Awaiting for the lab

  • @ghengiskhan8604
    @ghengiskhan8604 6 лет назад

    Very informative. Especially like the executing query displayed at the bottom. CTF lab would be great.

  • @elamathi3420
    @elamathi3420 5 лет назад

    Great video,easy understanding, plz create a video on how to prevent from SQL injection also.

  • @jacossantos2795
    @jacossantos2795 3 года назад +1

    Hi, its there any free I can get a SQL injection?

  • @pratyushsingh3278
    @pratyushsingh3278 4 года назад

    very nice i could understand everything and follow it please keep going

  • @dagabaaz709
    @dagabaaz709 4 года назад +1

    0:00 neck jurk like a DJ.. that was good

  • @nomanmalik677
    @nomanmalik677 5 лет назад +1

    That's a really cool tutorial sir!!!!
    Thank you so much

  • @radheshyamsingh6355
    @radheshyamsingh6355 4 года назад

    i loved the way you teaching.....amazing keep it up...

  • @blakeyun5089
    @blakeyun5089 5 лет назад

    Great video, Very nicely explained
    can u suggest any reading material or videos for SQL

  • @anonanon2601
    @anonanon2601 6 лет назад +1

    Subbed. Thanks for the guide! Constructive criticism: explaining what sanitizing is, why the SQLi DB is the target, how to ID a DB type for SQL syntax, and of course some disclaimer about usage. Look forward to watching your other stuff!

  • @rahaper
    @rahaper 5 лет назад

    Thanks buddy, very clear explanation.

  • @christopherwestlake4159
    @christopherwestlake4159 4 года назад

    Thank you so much for breaking it down for me to a way I understood it, if I had seen this video 15years ago, my life would be so much better/different than it is now, I had the ambition to learn it but needed the breakdown like you did so I'd feel it was something I would be successful at because I'm sick of trying something for way too long then just giving up, that's just too much time wasted and I have no time available to waste

  • @ishitas1
    @ishitas1 4 года назад

    Thank you it was good to learn the basics

  • @Jojo-nf1yk
    @Jojo-nf1yk 5 лет назад

    Great job, fantastic video, very didactics. Thanks a lot !!

  • @user-xp9yj5uu5r
    @user-xp9yj5uu5r 2 дня назад

    am just learning

  • @jaishankarpatil4554
    @jaishankarpatil4554 5 лет назад +2

    Thank you for sharing the Idea 🧠🤯. Please upload the Practical SQL injection video. You are a amazing explainer

  • @danielgattiker568
    @danielgattiker568 5 лет назад

    Very nice explanation! You got a new sub ;D

  • @RajendraPrasad__Its_my_profile
    @RajendraPrasad__Its_my_profile 4 года назад +1

    Love the way you explained with that calm voice. School kiddos also understand easily without any technical background. Waiting for the CTF lab materials. Thank you!! @HackHappy

  • @reddemon3981
    @reddemon3981 5 лет назад

    I am new to this. your video is very useful to me. thanks for your vid.

  • @potatosmasher1072
    @potatosmasher1072 4 года назад +1

    4:25 YOOO IT’S A BOOLEAN THAT’S SICK

  • @neopolythe
    @neopolythe 5 лет назад

    Great video and content clearly presented. Do you mind me asking what software you are using to edit and compose your videos?

  • @rolandprice5768
    @rolandprice5768 5 лет назад

    Great vid! Looking forward to the lab!

  • @AtomicBl453
    @AtomicBl453 5 лет назад

    You're the fucking Bob Ross of SQL injections!

  • @preetigoel
    @preetigoel 4 года назад

    Awesome and very helpful video 👍

  • @firozbhuyian7172
    @firozbhuyian7172 4 года назад

    Wonderful Tutorial, Always hope ahead.....!!

  • @gehadhilal42
    @gehadhilal42 5 лет назад

    thanks a lot it was really a good job . I hope you continue .

  • @jlow304
    @jlow304 5 лет назад +1

    Great video, keep up the good work :)

  • @SlayerFoxX
    @SlayerFoxX 4 года назад

    Great video!!

  • @ZerixxHD
    @ZerixxHD 6 лет назад +1

    awesome vid, esay to understand, good job

    • @HackhappyOrg
      @HackhappyOrg  6 лет назад +2

      Glad you found it useful XacT. Thanks for watching!

  • @iceweasel3790
    @iceweasel3790 6 лет назад +5

    I watched it twice and i still dont get what you are trying to do :( thanks for trying to help people though.

  • @xs1l3n7x
    @xs1l3n7x 6 лет назад

    I'll be waiting for that CTF, good stuff.

  • @zhanny8211
    @zhanny8211 3 года назад

    Me be like ha finally i can crack open someone's firewall

  • @mutemwaboltonkacanamutemwa3715
    @mutemwaboltonkacanamutemwa3715 4 года назад

    Sweet video, still waiting for the LAB!

    • @oblio10
      @oblio10 4 года назад

      lol same

  • @user-xw9tn8zx1g
    @user-xw9tn8zx1g 6 лет назад

    Great video. Thank you for the help

    • @HackhappyOrg
      @HackhappyOrg  6 лет назад

      Glad you found it useful Max Barkouras. Thanks for watching!

  • @deadlock107
    @deadlock107 6 лет назад

    Very informative tutorial, thank you!

  • @luqmanahmad3153
    @luqmanahmad3153 5 лет назад

    I Learnt something new. Thank u

  • @devinwat
    @devinwat 5 лет назад

    I don’t know anything about coding...I just started getting into this all and trying to learn as much computer science type stuff as I can, so...how do you know what coding to type out while doing this? Is it always going to be this type of line to go through them? Or just from experience?

  • @otkennix
    @otkennix 3 года назад +1

    Please sir you how can I use web browser to try the injection

  • @lorimariepeavey1164
    @lorimariepeavey1164 4 года назад

    Thank you 😎

  • @NonchalantSquid
    @NonchalantSquid 4 года назад

    I don't really understand the need the the random numbers (at first all 1's, but then 3, 4, 5, 6, & 7).. Seems like a lot of people here understand it's purpose, it could be my lack of adequate experience with mySQL; what are those numbers used for ?
    also the random single quotation marks (like before 7; '7), not really sure what its purpose is. It was never explicitly explained..
    thanks in advanced

  • @optimalk4662
    @optimalk4662 6 лет назад

    Great video, very informative!

    • @HackhappyOrg
      @HackhappyOrg  6 лет назад

      Glad you found it useful K'Ci Beckford. Thanks for watching!

  • @HRZ007
    @HRZ007 4 года назад

    i llike your videos,plz update more

  • @ratulsikdar5598
    @ratulsikdar5598 4 года назад

    Thank you for your video! It was very helpful but I'm curious to know how I can find the 2nd user from the table without knowing the userid and password? If you could answer that, I would greatly appreciate you!

  • @Abhishekkumar-vf8qe
    @Abhishekkumar-vf8qe 5 лет назад

    nice one... I teared down my login

    • @HackhappyOrg
      @HackhappyOrg  5 лет назад

      Thanks for watching Abhishek kumar!

  • @virajchethiyasamaranayake1803
    @virajchethiyasamaranayake1803 4 года назад

    I need to practice this....

  • @AlineBora
    @AlineBora 3 года назад +1

    Where are you inserting all the codes to get such results? This was not clear

    • @DrakeOola
      @DrakeOola 3 года назад

      He literally shows you on the screen.
      You put it where user input is expected. For example when you log on to your youtube account, you put the code where you would normally put your username or you can put it in as your password. You can even copy/paste it into a comment or the search bar. It can go wherever user input is expected. Now this obviously doesn't work on youtube. In fact it will not work on 99% of the sites you visit. It happens when the creators forget to sanitize their inputs but it is an extremely well known exploit and extremely easy to fix. Hard to explain to a non-coder what sanitized inputs are but I'll try if you even read this comment and ask 😅

  • @Kevin-jl8ps
    @Kevin-jl8ps 5 лет назад +1

    wow, this is so intresting!

  • @mustache2295
    @mustache2295 4 года назад

    Late but I don't understand how switching table_schema between 3 and 4 has anything to do with whether or not your injection works. Can OP or anyone else explain this for me please? The audio cuts out during this portion of the video for whatever reason.

  • @alexissuarezalvarez5622
    @alexissuarezalvarez5622 4 года назад

    Thanks for the tutorial. I have a question, after searching for matches in the database, what happens if the user and password validation is done with java, c #, javascript, etc? Would injection sql work?

  • @loser1238
    @loser1238 4 года назад

    So why did we use the number 3,4,5,6 and 7?

  • @aiselcatify
    @aiselcatify 6 месяцев назад

    But what do you do if the forms have required fields? I put the sql code in 1 field and can't even execute it because the other field is blanks :(

  • @jackakif
    @jackakif 3 года назад

    thanks got rusticated from my university

  • @lethabo5705
    @lethabo5705 5 лет назад +2

    Hey, where is the lab??

  • @dmcandar353
    @dmcandar353 5 лет назад

    Thanks for this 😊😊

  • @lubinlfb3563
    @lubinlfb3563 4 года назад

    Please help I don’t understand where the black board is supposed to be… html code when inspecting element???

  • @wasiyanilofardpsnacharam1253
    @wasiyanilofardpsnacharam1253 5 лет назад

    very nice explanaiton ....bingo liked it

  • @forhadhossain7382
    @forhadhossain7382 5 лет назад

    nice tutorial :) well explained

  • @MistralKriss
    @MistralKriss 3 года назад

    Very interesting

  • @mydailymiracles
    @mydailymiracles 5 лет назад +2

    Good video... Just had to put the speed at 1.25 ;)

  • @christianity_education
    @christianity_education 4 года назад

    It was educational

  • @ramjasoria4462
    @ramjasoria4462 6 лет назад +2

    nice work please upload sql injection ctf labs beginner to advance