If you are looking for the lab of Cyber Security and Web Development Labs. Then you arrived at the correct place. We do have the Cyber Security and Web development labs and more knowingly they are free.

Today, in this article we are gonna learn about what is SQL injection and what damage it can create if an SQL injection had found on a website. So let’s jump into the topic without wasting time.

What is SQL injection?

SQL is one of the most common web hacking techniques that might destroy your database. It is a code injection technique that takes a user input and produces output for that input. If the user inputs any SQL injection payloads and if it is vulnerable then it might show information that shouldn’t be seen by a normal user.

And we do have different types of SQL injections and in most known SQL injections are:

  1. Time-Based SQL injection
  2. Blind SQL injection
  3. SQL injection
  4. Error-based SQL injection

and many more.

Why does SQL injection arises?

  • When the user-given input isn’t validated then SQL injection arises.
  • Code reviews should be done occasionally to avoid these attacks.

Where we can write find those SQL injections:

  1. Username, passwords fields
  2. Email fields
  3. Forum posts
  4. Contact form
  5. Feedback pages. And etc.

How to identify SQL injection on a live website

  1. First, select the target domain which you wanna test.
  2. Then do little research about parameters, which will store the data in the database,
  3. Then try to insert some primary SQL injection payloads like
  4. Single quotation (‘), double quotation (“), and many more.
  5. There are some other payloads that can be used to find SQL injection vulnerability
  6. And if you see any error, and from that using some SQL statements we can gather the information about the system using manually,
  7. Otherwise, you can get that using a tool called, “SQLMAP” which is available in the Kali Linux Operating system by default.
  8.  This is a basic way to find a SQL injection on a website.

And there is a video which is already been uploaded in our YouTube Channel and the video link is:

And by watching that video you can get some more detailed information about how to find SQL injection.

SQL injection to Account Takeover:

First, we usually visit websites everyday and login to some pages to view some content.

Now, here comes the special part:

There are different ways to escalate SQL

  1. Go to any login page which is having input fields like username, and password.
  2. Then try to just log in with username: admin and password: admin
  3. These are basic credentials used for login purposes.
  4. If it logged in, Boom! You logged in as an admin into that website.
  5. If not there are some SQL injection payloads that will help to bypass the restrictions and still somehow manage to login.
  6. Basic SQL injection payloads used at the time of login:
    1. ‘=’’or’
    1. ‘=’’or’–
  7. The above steps which are mentioned are some basic types of SQL injection to Account takeover techniques.
  8. And we did upload a YouTube video about the same topic ( SQL injection to Account takeover ) by Faiyaz Ahmad bro.

Here is the Youtube video link:

Mitigation’s to protect from SQL injection:

  1. Use a WAF ( Web application Firewall )
  2. Try to validate the user-given input everywhere.
  3. Try to put filters to avoid entering some dangerous characters

Conclusion:

I think to know, you have some information about what is SQL injection and how can we find SQL injection vulnerabilities right. And soon we are going to add more labs and I think SQL injection would be one of that.

Thanks for your time and thanks for reading.

Have a good day!