CVE-2024-36039: SQL Injection

Published May 21, 2024
·
Updated

Last updated 24 July 2024

Other sources

PyMySQL through 1.1.0 allows SQL injection if used with untrusted JSON input because keys are not escaped by escapedict.

— GitHub

PyMySQL through 1.1.0 allows SQL injection if used with untrusted JSON input because keys are not escaped by escapedict.

— Launchpad

Affected Software

6 affected componentsFixes available
pip/pymysql<1.1.1
1.1.1
redhat/pymysql<1.1.1
1.1.1
debian/python-pymysql<1.0.2-2+deb12u1
1.0.2-2+deb12u1
debian/python-pymysql<1.1.1-1
1.1.1-1
debian/python-pymysql<1.1.1-1
1.1.1-1
debian/python-pymysql
1.0.2-2+deb12u11.1.1-21.2.0-1

Remediation

Recommended actions to resolve this vulnerability, in priority order.

  1. Upgrade

    Upgrade pip/pymysql to a version that resolves this vulnerability.

    Fixed in 1.1.1
  2. Upgrade

    Upgrade redhat/pymysql to a version that resolves this vulnerability.

    Fixed in 1.1.1
  3. Upgrade

    Upgrade debian/python-pymysql to a version that resolves this vulnerability.

    Fixed in 1.0.2-2+deb12u1
  4. Upgrade

    Upgrade debian/python-pymysql to a version that resolves this vulnerability.

    Fixed in 1.1.1-1
  5. Upgrade

    Upgrade debian/python-pymysql to a version that resolves this vulnerability.

    Fixed in 1.0.2-2+deb12u1Fixed in 1.1.1-2Fixed in 1.2.0-1
  6. Upgrade

    Upgrade PyMySQL to a version that resolves this vulnerability.

    Patch 521e40050cb386a499f68f483fefd144c493053c

Event History

May 21, 2024
CVE Published
via MITRE·12:00 AM
Data Sourced
via MITRE·12:00 AM
Description
Data Sourced
via NVD·04:15 PM
DescriptionSeverityWeakness
Data Sourced
via OSV·04:15 PM
DescriptionSeverityAffected Software
Advisory Published
via GitHub·06:31 PM
Data Sourced
via GitHub·06:31 PM
DescriptionSeverityWeaknessAffected Software

Parent advisories

This vulnerability appears in the following advisories.

Peer vulnerabilities

Found alongside the following vulnerabilities.

Frequently Asked Questions

1

What is the severity of CVE-2024-36039?

CVE-2024-36039 is classified as a high severity vulnerability due to its potential to allow SQL injection attacks.

2

How do I fix CVE-2024-36039?

To fix CVE-2024-36039, upgrade to PyMySQL version 1.1.1 or later.

3

What versions of PyMySQL are affected by CVE-2024-36039?

CVE-2024-36039 affects all PyMySQL versions up to and including 1.1.0.

4

Can CVE-2024-36039 affect applications using untrusted JSON input?

Yes, CVE-2024-36039 specifically allows SQL injection when untrusted JSON input is used.

5

What are the potential consequences of exploiting CVE-2024-36039?

Exploiting CVE-2024-36039 can lead to unauthorized access to the database and manipulation of sensitive data.

Contact

SecAlerts Pty Ltd.
132 Wickham Terrace
Fortitude Valley,
QLD 4006, Australia
info@secalerts.co
By using SecAlerts services, you agree to our services end-user license agreement. This website is safeguarded by reCAPTCHA and governed by the Google Privacy Policy and Terms of Service. All names, logos, and brands of products are owned by their respective owners, and any usage of these names, logos, and brands for identification purposes only does not imply endorsement. If you possess any content that requires removal, please get in touch with us.
© 2026 SecAlerts Pty Ltd.
ABN: 70 645 966 203, ACN: 645 966 203