CVE-2024-36039: Mycli · PyMySQL SQL Injection vulnerability
Affects mycliSource GCVE Database
Not known to be exploited · CVSS 6.3 Medium : upgrade to 1.27.2_1 when convenient.
Data as of 17 Nov 2026, 19:19 UTC
- Patch
- Available – fixed in 1.27.2_1
CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:L/A:LExploitation evidence
Disclosed: evidence found.
CVE published 21 May 2024
Detectable: no evidence on record.
No public nuclei template indexed
Weaponized: no evidence on record.
No public exploit code indexed in Metasploit or Exploit-DB
Exploited in the wildExploited: no evidence on record.
Not in CISA KEV and no source reports exploitation
Observed by OffSeq MirageSeen by Mirage: no evidence on record.
No attack traffic recorded by OffSeq Mirage sensors
A missing step is not evidence of safety. Sources: cve.org (opens in a new tab), the Metasploit, Exploit-DB and nuclei-templates index as of 16 Nov 2026.
What to do
Upgrade mycli to 1.27.2_1.
Affected software
| Product | Affected | Fixed in |
|---|---|---|
Homebrewmyclipkg:brew/mycliOther threats | Affected
| Fixed in
|
Check your own hosts for these packages with threat-finder (opens in a new tab), our free open-source scanner.
AI-suggested
Upgrade mycli to version 1.27.2_1 or later, where this SQL injection vulnerability is fixed. No other mitigations are specified or required once the patch is applied.
Description
CVE-2024-36039 is a critical SQL injection vulnerability in PyMySQL versions through 1.1.0 when used by the mycli client with untrusted JSON input. The flaw arises because keys in JSON input are not properly escaped by the escape_dict function, allowing injection of malicious SQL code. This vulnerability affects mycli versions from 1.0.0 up to but not including 1.27.2_1. A fix is available in version 1.27.2_1.
References
- nvd.nist.gov/vuln/detail/CVE-2024-36039 (opens in a new tab)
- github.com/PyMySQL/PyMySQL/commit/521e40050cb386a499f68f483fefd144c493053c (opens in a new tab)
- github.com/PyMySQL/PyMySQL (opens in a new tab)
- github.com/PyMySQL/PyMySQL/releases/tag/v1.1.1 (opens in a new tab)
- github.com/pypa/advisory-database/tree/main/vulns/pymysql/PYSEC-2026-502.yaml (opens in a new tab)
- lists.debian.org/debian-lts-announce/2024/05/msg00017.html (opens in a new tab)
- lists.fedoraproject.org/archives/list/package-announce%40lists.fedoraproject.org/message/23VXBV34GFRICCVYZ6KFMSSWY5UEXCF5 (opens in a new tab)
- lists.fedoraproject.org/archives/list/package-announce%40lists.fedoraproject.org/message/35VOJS3SRJNLQIO7YTZFNM6RWHIHWTMK (opens in a new tab)
- pypi.org/project/pymysql (opens in a new tab)