CVE-2024-36039 is a medium-severity (CVSS 6.3) SQL Injection vulnerability in pymysql. A fix is available for pymysql — see the affected versions and patch details below.
PyMySQL SQL Injection vulnerability
Exploitation Status
No confirmed exploitation observed yet
- CISA’s own triage has not observed active exploitation or public proof-of-concept code for this CVE as of its last assessment.
Exploitation and automatability from CISA’s SSVC triage for CVE-2024-36039.
EPSS Exploitation Probability
Probability of exploitation in the next 30 days, from FIRST.org EPSS.
How urgent is this, really
Where this sits among everything scored
Real-World Exposure
pymysqlReal-time download stats are indexed for npm and PyPI packages. This vulnerability affects PyPI packages — download data is not available via public APIs for these ecosystems.
Description
PyMySQL through 1.1.0 allows SQL injection if used with untrusted JSON input because keys are not escaped by escape_dict.
Affected Packages
| Ecosystem | Package | Vulnerable range | Fix |
|---|---|---|---|
| 🐍PyPI | pymysql | all versions | 1.1.1pip install --upgrade 'pymysql==1.1.1' |
Detection & mitigation playbook
Open-source dependencyDetect
Scan your dependency tree (package-lock.json, pnpm-lock.yaml, requirements.txt, go.sum, etc.) for pymysql, including transitive dependencies — a direct dependency you never call can still pull in a vulnerable version.
Fix
Update pymysql to 1.1.1 or later, then make sure no transitive (indirect) dependency still pins the vulnerable range — O3 confirms CVE-2024-36039 is resolved across your whole dependency graph.
Workarounds
Until you can upgrade, make sure every query built from user input uses parameterised statements or a prepared-statement API rather than string concatenation, and reduce the database account's privileges so an injected query cannot read or alter data beyond what the feature needs.
Fixing This On Your OS
If you run this on a Linux distribution, patch through your package manager against the distro's own security advisory below — it tracks the exact backported fix for your release, which can ship on a different timeline (and sometimes a different severity) than the upstream project.
Applications not exposed to untrusted JSON input are not vulnerable to this issue. Additionally, exploitation of this vulnerability depends on the permissions granted to the database user, limiting the security impact. For this reason, this flaw was rated with a Moderate severity.
Make sure the permissions are set correctly for each user, database, table, operation, etc. Do not expose the PyMySQL library to untrusted JSON input.Source: Red Hat security advisory for CVE-2024-36039 (CC BY 4.0)
| Product | Fixed in | Advisory |
|---|---|---|
| Red Hat Enterprise Linux 8 | python3.11-PyMySQL-0:1.0.2-2.el8_10 | RHSA-2024:4244 |
| Red Hat Enterprise Linux 8 | python3.12-PyMySQL-0:1.1.0-3.el8_10 | RHSA-2024:4245 |
| Red Hat Enterprise Linux 9 | python3.12-PyMySQL-0:1.1.0-3.el9 | RHSA-2024:9193 |
| Red Hat Enterprise Linux 9 | python3.11-PyMySQL-0:1.0.2-2.el9 | RHSA-2024:9194 |
| Red Hat Quay 3 | quay/clair-rhel8:v3.12.1-1 | RHBA-2024:5039 |
Frequently Asked Questions
Is CVE-2024-36039 in your dependencies?
Find it across PyPI, including transitive dependencies.