Description
PyMySQL through 1.1.0 allows SQL injection if used with untrusted JSON input because keys are not escaped by escape_dict.
Fixed in Linux distributions
Distributions backport fixes, so the version that fixes this vulnerability differs per release — upgrade to at least the version shown. From the distributions' security trackers and advisories.
Debian
Security tracker ↗| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| Debian 14 | python-pymysql | 1.1.1-1 | — |
| Debian 13 | python-pymysql | 1.1.1-1 | — |
| Debian 12 | python-pymysql | 1.0.2-2+deb12u1 | DSA-5700-1 |
| Debian 11 | python-pymysql | 0.9.3-2+deb11u1 | DSA-5700-1 |
| Debian 10 | python-pymysql | 0.9.3-1+deb10u1 | DLA-3822-1 |
Ubuntu
Security tracker ↗| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| Ubuntu 24.04 LTS | python-pymysql | 1.0.2-2ubuntu1.1 | USN-6801-1 |
| Ubuntu 22.04 LTS | python-pymysql | 1.0.2-1ubuntu1.22.04.1 | USN-6801-1 |
| Ubuntu 20.04 LTS | python-pymysql | 0.9.3-2ubuntu3.1 | USN-6801-1 |
| Ubuntu 18.04 LTS | python-pymysql | No fix yet | — |
| Ubuntu 16.04 LTS | python-pymysql | No fix yet | — |
Red Hat
Security tracker ↗| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| RHEL 9 | python3.11-PyMySQL +1 | 1.0.2-2.el9 | RHSA-2024:9194 |
| RHEL 9 | python3.12-PyMySQL +1 | 1.1.0-3.el9 | RHSA-2024:9193 |
| RHEL 8 | python3.11-PyMySQL | 1.0.2-2.el8_10 | RHSA-2024:4244 |
| RHEL 8 | python3.12-PyMySQL | 1.1.0-3.el8_10 | RHSA-2024:4245 |
AlmaLinux
Errata ↗| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| AlmaLinux 9 | python3.11-PyMySQL +1 | 1.0.2-2.el9 | ALSA-2024:9194 |
| AlmaLinux 9 | python3.12-PyMySQL +1 | 1.1.0-3.el9 | ALSA-2024:9193 |
| AlmaLinux 8 | python3.11-PyMySQL | 1.0.2-2.el8_10 | ALSA-2024:4244 |
| AlmaLinux 8 | python3.12-PyMySQL | 1.1.0-3.el8_10 | ALSA-2024:4245 |
Rocky Linux
Errata ↗| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| Rocky Linux 9 | python3.12-PyMySQL | 1.1.0-3.el9 | RLSA-2024:9193 |
| Rocky Linux 8 | python3.11-PyMySQL | 1.0.2-2.el8_10 | RLSA-2024:4244 |
| Rocky Linux 8 | python3.12-PyMySQL | 1.1.0-3.el8_10 | RLSA-2024:4245 |
SUSE
Security tracker ↗| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| SLES 15 SP6 | python-PyMySQL | 0.7.11-150000.3.3.1 | SUSE-SU-2024:1855-1 |
| SLES 15 SP5 | python-PyMySQL | 0.7.11-150000.3.3.1 | SUSE-SU-2024:1855-1 |
openSUSE
Security tracker ↗| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| openSUSE Tumbleweed | python-PyMySQL | 1.2.0-1.2 | openSUSE-SU-2026:11995-1 |
| openSUSE Leap 15.6 | python-PyMySQL | 1.1.0-150600.3.3.1 | SUSE-SU-2024:1925-1 |
| openSUSE Leap 15.5 | python-PyMySQL | 0.7.11-150000.3.3.1 | SUSE-SU-2024:1855-1 |
Azure Linux
| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| Azure Linux 3 | python-PyMySQL | 1.1.1-3 | — |
| Azure Linux 2 (CBL-Mariner) | python-PyMySQL | No fix yet | — |
Oracle Linux
| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| Oracle Linux 9 | python3.11-PyMySQL +1 | 1.0.2-2.el9 | ELSA-2024-9194 |
| Oracle Linux 9 | python3.12-PyMySQL +1 | 1.1.0-3.el9 | ELSA-2024-9193 |
| Oracle Linux 8 | python3.11-PyMySQL | 1.0.2-2.el8_10 | ELSA-2024-4244 |
| Oracle Linux 8 | python3.12-PyMySQL | 1.1.0-3.el8_10 | ELSA-2024-4245 |
Wolfi
| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| Wolfi rolling | py3-pymysql | 1.1.1-r0 | — |
Public exploits
Exploit or proof-of-concept code for this vulnerability is publicly available, which lowers the bar for attackers. Treat it as a reason to patch sooner.
Third-party code, not reviewed by us. Public PoCs are sometimes fake or contain malware. Read the code first and run it only in an isolated lab, against systems you are authorised to test.
GitHub 1 repository
-
zenniskayy2k4/CVE-2024-36039_PoC ★ 1 · Mar 26, 2026
PoC for CVE-2024-36039: Demonstrating SQL Injection via PyMySQL Object-to-String serialization flaw
Sources: PoC-in-GitHub, Metasploit Framework, Exploit-DB — updated daily. Only links are listed; no exploit code is hosted here.
Affected packages
| Ecosystem | Package | Affected | Fixed | Record |
|---|---|---|---|---|
| PyPI | pymysql | < 1.1.1 | 1.1.1 | GHSA-v9hf-5j83-6xpp |
Advisories 22
- ALSA-2024:9193 Moderate: python3.12-PyMySQL security update AlmaLinux Security Advisories · Oct 29, 2026
- ALSA-2024:9194 Moderate: python3.11-PyMySQL security update AlmaLinux Security Advisories · Oct 29, 2026
- ALSA-2024:4245 Moderate: python3 security update AlmaLinux Security Advisories · Oct 29, 2026
- ALSA-2024:4244 Moderate: python3.11-PyMySQL security update AlmaLinux Security Advisories · Oct 29, 2026
- WID-SEC-2024-1513 Red Hat Enterprise Linux (PyMySQL): Schwachstelle ermöglicht SQL Injection BSI CERT-Bund (WID) · Oct 11, 2026
- openSUSE-SU-2026:11995-1 python313-PyMySQL-1.2.0-1.2 on GA media SUSE / openSUSE Security Updates · Oct 5, 2026
- RHSA-2024:9193 Red Hat Security Advisory: python3.12-PyMySQL security update Red Hat Security Advisories (RHSA) · Aug 8, 2026
- RHSA-2024:9194 Red Hat Security Advisory: python3.11-PyMySQL security update Red Hat Security Advisories (RHSA) · Aug 8, 2026
- RHSA-2024:4245 Red Hat Security Advisory: python3 security update Red Hat Security Advisories (RHSA) · Aug 8, 2026
- RHSA-2024:4244 Red Hat Security Advisory: python3.11-PyMySQL security update Red Hat Security Advisories (RHSA) · Aug 8, 2026
- USN-6801-1 python-pymysql vulnerability Ubuntu Security Notices (USN) · Apr 27, 2026
- DSA-5700-1 python-pymysql - security update Debian Security (DSA / DLA) · Mar 9, 2026
- DLA-3822-1 python-pymysql - security update Debian Security (DSA / DLA) · Mar 9, 2026
- SUSE-SU-2024:1855-1 Security update for python-PyMySQL SUSE / openSUSE Security Updates · Feb 4, 2026
- SUSE-SU-2024:1925-1 Security update for python-PyMySQL SUSE / openSUSE Security Updates · Feb 4, 2026
- RLSA-2024:9193 Moderate: python3.12-PyMySQL security update Rocky Linux Security Advisories · Oct 9, 2025
- RLSA-2024:4244 Moderate: python3.11-PyMySQL security update Rocky Linux Security Advisories · May 7, 2025
- RLSA-2024:4245 Moderate: python3 security update Rocky Linux Security Advisories · May 7, 2025
- ELSA-2024-9194 Moderate: python3.11-PyMySQL security update (Oracle Linux 9) Oracle Linux Security Advisories (ELSA) · Nov 14, 2024
- ELSA-2024-9193 Moderate: python3.12-PyMySQL security update (Oracle Linux 9) Oracle Linux Security Advisories (ELSA) · Nov 14, 2024
- ELSA-2024-4245 Moderate: python3 security update (Oracle Linux 8) Oracle Linux Security Advisories (ELSA) · Jul 3, 2024
- ELSA-2024-4244 Moderate: python3.11-PyMySQL security update (Oracle Linux 8) Oracle Linux Security Advisories (ELSA) · Jul 2, 2024
References
- https://github.com/PyMySQL/PyMySQL/releases/tag/v1.1.1
- [debian-lts-announce] 20240527 [SECURITY] [DLA 3822-1] python-pymysql security update mailing-list
- FEDORA-2024-e7141ab284 vendor-advisory
- FEDORA-2024-b26f07d27b vendor-advisory