Skip to Content
The Database Hacker's Handbook: Defending Database Servers
book

The Database Hacker's Handbook: Defending Database Servers

by David Litchfield, Chris Anley, John Heasman, Bill Grindlay
July 2005
Intermediate to advanced
528 pages
12h 21m
English
Wiley
Content preview from The Database Hacker's Handbook: Defending Database Servers

Hacking MySQL

This section covers the following:

  • SQL injection in MySQL
  • Known MySQL bugs
  • Trojanning MySQL
  • Dangerous extensions: MyLUA and MyPHP

SQL Injection in MySQL

SQL injection is probably the most worrying attack on a MySQL system because it's the most probable initial attack vector on an Internet-connected server. Using SQL injection, it is possible to use the database server as a beachhead into the internal network — or at least, the network that the MySQL server is in — and as a platform for launching further attacks.

Frequently, applications inadvertently allow the execution of arbitrary queries in their database backends, by neglecting to vet incoming data. The problem occurs when an application creates a string that holds a SQL query, and includes user-supplied data in that string without applying any input validation.

Imagine a login form where the user supplies a username and password. This data is passed to a database query directly, so if the user inputs the username fred and the password sesame into the form, the SQL query looks like this:

select * from tblUsers where username = 'fred' and password = 'sesame'

In this example, the problems occur when the user specifies a string with a single quote in it. The user can submit a username like this:

fred'#

which will result in the SQL query string

select * from tblUsers where username = 'fred'#' and password = 'sesame'

which of course will log the user on as fred without knowing fred's password, because the database ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

The Oracle® Hacker's Handbook: Hacking and Defending Oracle

The Oracle® Hacker's Handbook: Hacking and Defending Oracle

David Litchfield
The Mac Hacker's Handbook

The Mac Hacker's Handbook

Charlie Miller, Dino Dai Zovi
The Browser Hacker's Handbook

The Browser Hacker's Handbook

Wade Alcorn, Christian Frichot, Michele Orru

Publisher Resources

ISBN: 9780764578014Purchase bookDownloads