PyMySQL through 1.1.0 allows SQL injection if used with untrusted JSON input because keys…
Priority LOW 29CWE-89Published · Updated
Key facts
- Attack vector
- Network
- Privileges required
- Low
- User interaction
- None
- Attack complexity
- Low
- Impact type
- SQL injection
- Confidentiality · integrity · availability
- Low · Low · Low
- Fix status
- Partial Red Hat: 3 fixed, 3 without a fix
Attack profile from CVSS 3.1 · CISA ADP. Fix status from CNA, GitHub and Red Hat. Impact type from CWE-89.
Summary
PyMySQL through 1.1.0 allows SQL injection if used with untrusted JSON input because keys are not escaped by escape_dict.
Why it matters now
Exploitation None reported CISA SSVC · not in CISA KEV
EPSS 0.00691 53rd percentileScored 2026-11-07
Fix Partial pymysql (PyPI): 1.1.1Red Hat: 4 advisoriesRed Hat: 3 fixed, 3 without a fix
SSVC decision points
CISA ADP · SSVC 2.0.3
- Exploitation
- None
- Automatable
- No
- Technical impact
- Partial
The decision (Track, Attend, Act) also depends on your mission and well-being impact; see CISA's SSVC guide.
Affected products
| Vendor | Product | Affected versions | Fixed in | Status | Source |
|---|---|---|---|---|---|
| — | — | all versions | — | No fix listed | CNA |
| — | pymysql (PyPI) | before 1.1.1 | 1.1.1 | Patch available | GHSA-v9hf-5j83-6xpp |
- — Vendor— Affected all versions Fixed in — No fix listed CNA
- pymysql (PyPI) Vendor— Affected before 1.1.1 Fixed in 1.1.1 Patch available GHSA-v9hf-5j83-6xpp
Remediation
- Fix · GHSA-v9hf-5j83-6xpp pymysql (PyPI) Fixed in 1.1.1 Advisory →
Red Hat 4 advisories
- RHSA-2024:9194 Released 2024-11-12 · Red Hat rating Moderatepython3.11-PyMySQL security update
- Red Hat Enterprise Linux AppStream (v. 9) python3.11-PyMySQL+rsa-1.0.2-2.el9, python3.11-PyMySQL-1.0.2-2.el9
- RHSA-2024:9193 Released 2024-11-12 · Red Hat rating Moderatepython3.12-PyMySQL security update
- Red Hat Enterprise Linux AppStream (v. 9) python3.12-PyMySQL+rsa-1.1.0-3.el9, python3.12-PyMySQL-1.1.0-3.el9
- RHSA-2024:4244 Released 2024-07-02 · Red Hat rating Moderatepython3.11-PyMySQL security update
- Red Hat Enterprise Linux AppStream (v. 8) python3.11-PyMySQL-1.0.2-2.el8_10
Show 1 more Red Hat advisories
- RHSA-2024:4245 Released 2024-07-02 · Red Hat rating Moderatepython3 security update
- Red Hat Enterprise Linux AppStream (v. 8) python3.12-PyMySQL-1.1.0-3.el8_10
Vendor assessments
Red Hat
Red Hat rating: Moderate. Red Hat's page for this CVE →
| Product | Status | Plan or fix |
|---|---|---|
| Red Hat Enterprise Linux 8 | Affected | No fix planned: Will not fix |
| Red Hat Enterprise Linux 9 | Affected | No fix planned: Will not fix |
| Red Hat Software Collections | Affected | No fix planned: Will not fix |
| Quay v3 | Fixed | — |
| Red Hat Enterprise Linux AppStream (v. 8) | Fixed | RHSA-2024:4244, RHSA-2024:4245 |
| Red Hat Enterprise Linux AppStream (v. 9) | Fixed | RHSA-2024:9193, RHSA-2024:9194 |
Not affected: 1 product
- Red Hat Enterprise Linux 10
Timeline
- 2026-10-02 Threatist record created from CVE-2024-36039
- 2026-10-03 Alias added: GHSA-v9hf-5j83-6xpp
References
Advisory 3
Other 6
- https://github.com/PyMySQL/PyMySQL/releases/tag/v1.1.1
- [debian-lts-announce] 20240527 [SECURITY] [DLA 3822-1] python-pymysql security update
- https://github.com/PyMySQL/PyMySQL/commit/521e40050cb386a499f68f483fefd144c493053c
- https://github.com/PyMySQL/PyMySQL
- https://lists.fedoraproject.org/archives/list/package-announce%40lists.fedoraproject.org/message/23VXBV34GFRICCVYZ6KFMSSWY5UEXCF5
- https://lists.fedoraproject.org/archives/list/package-announce%40lists.fedoraproject.org/message/35VOJS3SRJNLQIO7YTZFNM6RWHIHWTMK
Sources
- CVE-2024-36039 · CVE Program
- CVE-2024-36039 · NVD
- FIRST EPSS
- GHSA-v9hf-5j83-6xpp · GitHub Advisory Database · CC BY 4.0
- CVE-2024-36039 · Red Hat security data · CC BY 4.0
This product uses the NVD API but is not endorsed or certified by the NVD. Sources and licences