[ GLSA 200606-13 ] MySQL: SQL Injection

[GLSA]

Gentoo Linux Security Advisory

Title: MySQL: SQL Injection (GLSA 200606-13)
Severity: normal
Exploitable: remote
Date: June 11, 2006
Updated: December 13, 2006
Bug(s): #135076
ID: 200606-13

Synopsis

MySQL is vulnerable to an SQL Injection flaw in the multi-byte encoding process.

Background

MySQL is a popular multi-threaded, multi-user SQL server.

Affected Packages

Package: dev-db/mysql
Vulnerable: < 5.0.22
Unaffected: >= 5.0.22
Unaffected: >= 4.1.20 < 4.1.21
Unaffected: >= 4.1.21 < 4.1.22
Unaffected: >= 4.1.22 < 4.1.23
Unaffected: < 4.1
Architectures: All supported architectures


Description

MySQL is vulnerable to an injection flaw in mysql_real_escape() when used with multi-byte characters.

Impact

Due to a flaw in the multi-byte character process, an attacker is still able to inject arbitary SQL statements into the MySQL server for execution.

Workaround

There are a few workarounds available: NO_BACKSLASH_ESCAPES mode as a workaround for a bug in mysql_real_escape_string(): SET sql_mode='NO_BACKSLASH_ESCAPES'; SET GLOBAL sql_mode='NO_BACKSLASH_ESCAPES'; and server command line options: --sql-mode=NO_BACKSLASH_ESCAPES.

Resolution

All MySQL users should upgrade to the latest version: