Jump to content
CyberKid

How to Perform Manual SQL Injection With Integer Based Method

Recommended Posts

CyberKid
SQL Injection
 

Today we will perform manual SQL injection with integer based method for the MySQL database. I hope the last article on error based string injection is useful to everyone, especially for beginners.Now I will quickly drive into yet another writing for SQL injection with the integer based method.

 

SQL Injection ONLINE LAB:

  • Beginners can use this website to practice skills for SQL injection
  • To Access the LAB Click Here

STEP 1: Breaking the Query

  • Visting the website testphp.vulnweb.com/artists.php?artist=1 
  • let us add & check single quote to existing URL to check whether the website is vulnerable to SQL Injection by adding testphp.vulnweb.com/artists.php?artist=1′

Screenshot-488.png?resize=627%2C234&ssl=

 
  • Here we are trying to break query to receive error messages with the database so that we can balance the query.
  • But we are not getting error statements with respect to our input, which means single quote as input.
  • Now I understand that when the input string is not getting an error with the database, let me try to fix without a single quote.
 

Screenshot-486.png?resize=413%2C61&ssl=1

  • Above figure shows that website is getting fixed & we have joined the query with no errors with integer method.So this is called as SQL Injection With Integer Based Method.

STEP 2: Finding the Backend Columns

  • It is time to have a conversation with the database to find the number of columns.To enumerate columns we can use order by command.
  • Let me ask database with any number so that I can check that columns availability in the database.

SQL injection

  • Above figure, I have asked for 4 columns, but it throws an error.
  • Keep asking database, let me ask for 3 columns !!!

SQL injection

 
  • Above Figure shows no SQL errors, Yes! we have only 3 columns

STEP 3: Finding the Backend Table & Table Names

  • Let us ask database its table path with the command union all select 

SQL injection

  • Above figure shows the execution of union all select gives the path of tables.2 & 3 the tables path.

SQL injection

  • Above figure shows the execution of database() & version() on the path of tables 2 & 3 provides us the database name and version.
  • So here database name is acuart and version is 5.1.73-0ubuntu0.10.04.1

STEP 4: Dumping Database Tables

  • Group_concat() is the function returns a string with the concatenated non-NULL value from a group.
  • So we can use this Function to list all Tables from the database.
  • In Addition, we can use Information_Schema to view metadata about the objects within a database

SQL injection

Screenshot-473.png?resize=696%2C85&ssl=1

  • The Above Figure shows the dump of all tables as carts,categ,featured,guestbook,pictures,products,users

STEP 5: Dumping all Data in Columns of Tables

  • Here I will dump for users in table

SQL injection

 

Screenshot-477.png?resize=696%2C86&ssl=1

  • The Above Figure shows the dump of all columns of tables contains
    uname,pass,cc,address,email,name,phone,cart.

STEP 6: Dumping all Usernames & passwords

  • Here we can dump all usernames & passwords in the database.

Screenshot-479.png?resize=696%2C232&ssl=

Screenshot-484.png?resize=696%2C88&ssl=1

  • Here we got the username as test and password as test !!!!
  • practice and try to dump all columns of tables contains cc, address, email, name, phone, cart. Happy Hacking !!!

Disclaimer

All the. This article is only for an Educational purpose. Any actions and or activities related to the material contained within this Website is solely your responsibility. The misuse of the information in this website can result in criminal charges brought against the persons in question.

Share this post


Link to post
Share on other sites

Δημιουργήστε ένα λογαριασμό ή συνδεθείτε προκειμένου να το δείτε

Πρέπει να είστε μέλος για να μπορέσετε να αφήσετε κάποιο σχόλιο

Δημιουργία λογαριασμού

Κάντε μια δωρεάν εγγραφή στην κοινότητά μας. Η εγγραφές μας είναι εύκολες.!

Εγγραφή τώρα

Σύνδεση

Εάν έχετε ήδη λογαριασμό σε αυτό το Forum; Συνδεθείτε εδώ.

Συνδεθείτε τώρα

  • Μηνύματα

    • vn5socks.net
      LIVE ~ 118.139.176.242:1197 | 0.047 | Unknown | Unknown | Unknown | Singapore | Checked at vn5socks.net
      LIVE ~ 97.74.230.16:36446 | 0.198 | Scottsdale | AZ | 85260 | United States | Checked at vn5socks.net
      LIVE ~ 192.169.218.61:16003 | 0.187 | Unknown | Unknown | Unknown | Unknown | Checked at vn5socks.net
      LIVE ~ 118.126.117.146:27011 | 0.17 | Shanghai | 23 | Unknown | China | Checked at vn5socks.net
      LIVE ~ 50.62.35.225:53638 | 0.227 | Scottsdale | AZ | 85260 | United States | Checked at vn5socks.net
      LIVE ~ 107.170.7.132:47810 | 0.25 | Unknown | Unknown | Unknown | Unknown | Checked at vn5socks.net
      LIVE ~ 165.227.113.239:2018 | 0.232 | Santa Cruz | CA | 95060 | United States | Checked at vn5socks.net
      LIVE ~ 80.211.146.160:5636 | 0.276 | Unknown | Unknown | Unknown | Denmark | Checked at vn5socks.net
      LIVE ~ 200.37.7.75:9999 | 0.347 | Lima | 15 | Unknown | Peru | Checked at vn5socks.net
      LIVE ~ 165.227.52.169:2018 | 0.188 | Santa Cruz | CA | 95060 | United States | Checked at vn5socks.net
      LIVE ~ 45.55.169.78:64486 | 0.259 | Unknown | Unknown | Unknown | Unknown | Checked at vn5socks.net
      LIVE ~ 45.55.169.78:19556 | 0.259 | Unknown | Unknown | Unknown | Unknown | Checked at vn5socks.net
      LIVE ~ 104.168.127.225:2018 | 0.283 | Unknown | Unknown | Unknown | Unknown | Checked at vn5socks.net
      LIVE ~ 162.243.14.144:2182 | 0.241 | Unknown | Unknown | Unknown | Unknown | Checked at vn5socks.net
      LIVE ~ 45.55.169.78:9467 | 0.264 | Unknown | Unknown | Unknown | Unknown | Checked at vn5socks.net
      LIVE ~ 216.187.82.76:1922 | 0.276 | Unknown | Unknown | Unknown | Canada | Checked at vn5socks.net
      LIVE ~ 50.63.13.254:37554 | 0.221 | Scottsdale | AZ | 85260 | United States | Checked at vn5socks.net
      LIVE ~ 97.74.230.16:44951 | 0.195 | Scottsdale | AZ | 85260 | United States | Checked at vn5socks.net
    • tisocks
      SOCKS Proxy List by Tisocks.net
      If you Need Socks5 , Please visit service and add fund via PM , BTC WMZ , WEX . Thanks all!!
      Add fund : https://tisocks.net/addfund
      Check socks5 Online here : https://checksocks5.com
      LIVE | 192.169.232.12:9295 | 0.234 | SOCKS5 | Arizona | 85260 | ip-192-169-232-12.ip.secureserver.net | United States | Checked at https://tisocks.net
      LIVE | 192.169.250.198:40759 | 0.232 | SOCKS5 | Arizona | 85260 | ip-192-169-250-198.ip.secureserver.net | United States | Checked at https://tisocks.net
      LIVE | 181.225.99.251:9999 | 0.355 | SOCKS5 | Unknow | Unknow | azteca-comunicaciones.com | Colombia | Checked at https://tisocks.net
      LIVE | 132.148.129.183:33814 | 0.331 | SOCKS5 | Arizona | 85260 | ip-132-148-129-183.ip.secureserver.net | United States | Checked at https://tisocks.net
      LIVE | 84.21.102.89:9999 | 0.505 | SOCKS5 | Vysocina | 592 42 | cl084021102089.unet.cz | Czech Republic | Checked at https://tisocks.net
      LIVE | 46.151.104.160:9999 | 0.526 | SOCKS5 | Moskva | 141342 | 46-151-104-160.telecombis.ru | Russian Federation | Checked at https://tisocks.net
      LIVE | 195.123.210.73:443 | 0.51 | SOCKS5 | Unknow | Unknow | kostelvania.uaserver2 | Latvia | Checked at https://tisocks.net
      LIVE | 109.106.136.6:9999 | 0.554 | SOCKS5 | Voronezh | 394000 | N/A | Russian Federation | Checked at https://tisocks.net
      LIVE | 88.203.36.209:9999 | 0.516 | SOCKS5 | Unknow | QRM | c36-209.i05-10.onvol.net | Malta | Checked at https://tisocks.net
      LIVE | 165.98.96.126:9999 | 0.395 | SOCKS5 | Managua | Unknow | ip-96-126.amnet.com.ni | Nicaragua | Checked at https://tisocks.net
      LIVE | 185.156.232.228:9999 | 0.556 | SOCKS5 | Puglia | 71011 | N/A | Italy | Checked at https://tisocks.net
      LIVE | 206.223.246.71:42599 | 0.094 | SOCKS5 | Unknow | Unknow | | Unknow | Checked at https://tisocks.net
      LIVE | 202.61.121.145:9999 | 1.025 | SOCKS5 | Tamil Nadu | 601301 | N/A | India | Checked at https://tisocks.net
      LIVE | 178.32.207.56:55678 | 0.235 | SOCKS5 | Texas | 79022 | N/A | United States | Checked at https://tisocks.net
      LIVE | 157.119.225.225:9999 | 1.09 | SOCKS5 | Rajasthan | 321001 | N/A | India | Checked at https://tisocks.net
       
    • shopsocks5.com
      [Shopsocks5.com] Service Socks5 Cheap
      Payment Instantly Perfectmoney, Bitcoin, Wmtransfer, BTC-E ( Please click Buy Socks )
      Check Socks Online  http://shopsocks5.com/check/




        Live | 45.55.169.78:19556 | United States | New York | NY | 10118 | Checked at Shopsocks5.com Live | 80.211.146.160:5636 | Denmark | Unknown | Unknown | Unknown | Checked at Shopsocks5.com Live | 97.74.230.16:44951 | United States | Scottsdale | AZ | 85260 | Checked at Shopsocks5.com Live | 118.139.176.242:1197 | Singapore | Singapore | 00 | Unknown | Checked at Shopsocks5.com Live | 45.55.169.78:64486 | United States | New York | NY | 10118 | Checked at Shopsocks5.com Live | 222.165.225.245:18959 | Indonesia | Jakarta | 04 | Unknown | Checked at Shopsocks5.com Live | 216.187.82.76:1922 | United States | New York | NY | 10004 | Checked at Shopsocks5.com Live | 97.74.230.16:36446 | United States | Scottsdale | AZ | 85260 | Checked at Shopsocks5.com Live | 107.170.254.167:40370 | United States | San Francisco | CA | 94101 | Checked at Shopsocks5.com Live | 60.248.223.190:3021 | Taiwan | Unknown | Unknown | Unknown | Checked at Shopsocks5.com Live | 109.104.79.203:14541 | United Kingdom | Unknown | Unknown | Unknown | Checked at Shopsocks5.com Live | 125.227.69.220:3265 | Taiwan | Unknown | Unknown | Unknown | Checked at Shopsocks5.com Live | 116.212.152.103:60595 | Cambodia | Phnom Penh | 11 | Unknown | Checked at Shopsocks5.com Live | 185.222.202.130:3128 | Unknown | Unknown | Unknown | Unknown | Checked at Shopsocks5.com Live | 138.68.67.164:10800 | United States | Wilmington | DE | 19880 | Checked at Shopsocks5.com Live | 69.12.65.105:8912 | United States | Los Angeles | CA | 90014 | Checked at Shopsocks5.com
    • Black
      Δεν λειτουργεί το link, μήπως τα έχει κάποιος? Ευχαριστώ.  
    • dionysos
      ΣΑΡΑΝΤΑ ΠΡΑΓΜΑΤΑ ΠΟΥ ΘΕΛΩ ΝΑ ΣΟΥ ΠΩ ΑΛΙΣ ΚΑΙΠΕΡΣ - KUIPERS ALICE


      Η ΚΟΡΥΦΑΙΑ ΣΥΜΒΟΥΛΗ: ΟΡΙΣΜΕΝΑ ΜΥΣΤΙΚΑ ΕΙΝΑΙ ΑΔΥΝΑΤΟΝ ΝΑ ΤΑ ΚΡΑΤΗΣΕΙΣ Η Έιμι φαίνεται να έχει την τέλεια ζωή: γονείς που την καταλαβαίνουν, ένα καυτό αγόρι και την καλύτερη κολλητή. Κρατάει και μια διαδικτυακή στήλη με συμβουλές προς τους εφήβους προκειμένου να πάρουν τον έλεγχο της ζωής τους. Όταν όμως στο σχολείο κάνει την εμφάνισή του ένας σούπερ τύπος, η Έιμι είναι ανίκανη να ακολουθήσει τις ίδιες τις συμβουλές της. Ο Πιτ είναι το κλασικό «κακό» αγόρι. Είναι όλα όσα δεν είναι η Έιμι: άγριος, χωρίς φιλοδοξίες και λίγο επικίνδυνος. Και παρόλο που η Έιμι τα συνειδητοποιεί όλα αυτά, δεν μπορεί να κρατηθεί μακριά του. Και όσο πιο πολύ κολλάει μαζί του, τόσο περισσότερο ραγίζει η σχέση της με τον Γκρίφιν. Ένα λάθος, μια στιγμιαία απώλεια ελέγχου αρκεί για να καταστρέψει για πάντα το μέλλον της…


      Συγγραφέας: Kuipers Alice
      Ξενόγλωσσος Τίτλος: 40 THINGS I WANT TO TELL YOU
      Εκδότης: Ψυχογιός
      Γλώσσα: ελληνικά
      Μεταφραστής: ΜΠΟΥΜΠΟΥΡΗ ΡΑΝΙΑ
      Έτος Έκδοσης: 2013
      Σελίδες: 181
      Μορφή αρχείου: pdf
      Μέγεθος αρχείου zip: 12.0MB



      [hide] http://www.easybytez.com/zx4tabedntb3 [/hide]

Footer title

This content can be configured within your theme settings in your ACP. You can add any HTML including images, paragraphs and lists.

Footer title

This is an example of a list.

Footer title

This content can be configured within your theme settings in your ACP. You can add any HTML including images, paragraphs and lists.

Footer title

This content can be configured within your theme settings in your ACP. You can add any HTML including images, paragraphs and lists.

×