sql injection - percona · what is sql injection? sql injection is an attack vector an attacker...

36
SQL injection What is it and how to avoid it 4/15/2015

Upload: vuongtuong

Post on 21-Jul-2018

242 views

Category:

Documents


1 download

TRANSCRIPT

Page 1: SQL injection - Percona · What is SQL injection? SQL injection is an attack vector An attacker modifies the SQL queries which will be executed by the server But the attacker does

SQL injection

What is it and how to avoid it

4/15/2015

Page 2: SQL injection - Percona · What is SQL injection? SQL injection is an attack vector An attacker modifies the SQL queries which will be executed by the server But the attacker does
Page 3: SQL injection - Percona · What is SQL injection? SQL injection is an attack vector An attacker modifies the SQL queries which will be executed by the server But the attacker does
Page 4: SQL injection - Percona · What is SQL injection? SQL injection is an attack vector An attacker modifies the SQL queries which will be executed by the server But the attacker does
Page 5: SQL injection - Percona · What is SQL injection? SQL injection is an attack vector An attacker modifies the SQL queries which will be executed by the server But the attacker does
Page 6: SQL injection - Percona · What is SQL injection? SQL injection is an attack vector An attacker modifies the SQL queries which will be executed by the server But the attacker does
Page 7: SQL injection - Percona · What is SQL injection? SQL injection is an attack vector An attacker modifies the SQL queries which will be executed by the server But the attacker does
Page 8: SQL injection - Percona · What is SQL injection? SQL injection is an attack vector An attacker modifies the SQL queries which will be executed by the server But the attacker does
Page 9: SQL injection - Percona · What is SQL injection? SQL injection is an attack vector An attacker modifies the SQL queries which will be executed by the server But the attacker does
Page 10: SQL injection - Percona · What is SQL injection? SQL injection is an attack vector An attacker modifies the SQL queries which will be executed by the server But the attacker does
Page 11: SQL injection - Percona · What is SQL injection? SQL injection is an attack vector An attacker modifies the SQL queries which will be executed by the server But the attacker does
Page 12: SQL injection - Percona · What is SQL injection? SQL injection is an attack vector An attacker modifies the SQL queries which will be executed by the server But the attacker does
Page 13: SQL injection - Percona · What is SQL injection? SQL injection is an attack vector An attacker modifies the SQL queries which will be executed by the server But the attacker does
Page 14: SQL injection - Percona · What is SQL injection? SQL injection is an attack vector An attacker modifies the SQL queries which will be executed by the server But the attacker does
Page 15: SQL injection - Percona · What is SQL injection? SQL injection is an attack vector An attacker modifies the SQL queries which will be executed by the server But the attacker does
Page 16: SQL injection - Percona · What is SQL injection? SQL injection is an attack vector An attacker modifies the SQL queries which will be executed by the server But the attacker does
Page 17: SQL injection - Percona · What is SQL injection? SQL injection is an attack vector An attacker modifies the SQL queries which will be executed by the server But the attacker does
Page 18: SQL injection - Percona · What is SQL injection? SQL injection is an attack vector An attacker modifies the SQL queries which will be executed by the server But the attacker does
Page 19: SQL injection - Percona · What is SQL injection? SQL injection is an attack vector An attacker modifies the SQL queries which will be executed by the server But the attacker does
Page 20: SQL injection - Percona · What is SQL injection? SQL injection is an attack vector An attacker modifies the SQL queries which will be executed by the server But the attacker does
Page 21: SQL injection - Percona · What is SQL injection? SQL injection is an attack vector An attacker modifies the SQL queries which will be executed by the server But the attacker does
Page 22: SQL injection - Percona · What is SQL injection? SQL injection is an attack vector An attacker modifies the SQL queries which will be executed by the server But the attacker does
Page 23: SQL injection - Percona · What is SQL injection? SQL injection is an attack vector An attacker modifies the SQL queries which will be executed by the server But the attacker does
Page 24: SQL injection - Percona · What is SQL injection? SQL injection is an attack vector An attacker modifies the SQL queries which will be executed by the server But the attacker does
Page 25: SQL injection - Percona · What is SQL injection? SQL injection is an attack vector An attacker modifies the SQL queries which will be executed by the server But the attacker does
Page 26: SQL injection - Percona · What is SQL injection? SQL injection is an attack vector An attacker modifies the SQL queries which will be executed by the server But the attacker does
Page 27: SQL injection - Percona · What is SQL injection? SQL injection is an attack vector An attacker modifies the SQL queries which will be executed by the server But the attacker does
Page 28: SQL injection - Percona · What is SQL injection? SQL injection is an attack vector An attacker modifies the SQL queries which will be executed by the server But the attacker does
Page 29: SQL injection - Percona · What is SQL injection? SQL injection is an attack vector An attacker modifies the SQL queries which will be executed by the server But the attacker does
Page 30: SQL injection - Percona · What is SQL injection? SQL injection is an attack vector An attacker modifies the SQL queries which will be executed by the server But the attacker does
Page 31: SQL injection - Percona · What is SQL injection? SQL injection is an attack vector An attacker modifies the SQL queries which will be executed by the server But the attacker does
Page 32: SQL injection - Percona · What is SQL injection? SQL injection is an attack vector An attacker modifies the SQL queries which will be executed by the server But the attacker does
Page 33: SQL injection - Percona · What is SQL injection? SQL injection is an attack vector An attacker modifies the SQL queries which will be executed by the server But the attacker does
Page 34: SQL injection - Percona · What is SQL injection? SQL injection is an attack vector An attacker modifies the SQL queries which will be executed by the server But the attacker does
Page 35: SQL injection - Percona · What is SQL injection? SQL injection is an attack vector An attacker modifies the SQL queries which will be executed by the server But the attacker does

Noinject-MySQL – My Lua script for MySQL proxy + web interface

GreenSQL – Commercial proxy for MySQL and other databases

MySQL Enterprise Firewall – New SQL injection prevention firewall from Oracle

Page 36: SQL injection - Percona · What is SQL injection? SQL injection is an attack vector An attacker modifies the SQL queries which will be executed by the server But the attacker does