MySQL 8.0 vs MySQL 8.4 LTS
MySQL 8.4 LTS was released 6 years after MySQL 8.0. Source: endoflife.date (aggregating official MySQL/Oracle and MariaDB Foundation EOL announcements), checked 2026-07-31.
| Fact | MySQL 8.0 | MySQL 8.4 LTS |
|---|---|---|
| Release date | 2018-04-08 | 2024-04-10 |
| End of life | 2026-04-30 | 2032-04-30 |
| LTS release | Yes | Yes |
| Currently supported | No | Yes |
Feature differences
Unchanged New capability Behavior changed Deprecated Removed
| Feature | MySQL 8.0 | MySQL 8.4 LTS |
|---|---|---|
| Default authentication plugin | caching_sha2_password (since 8.0.4) | caching_sha2_password; mysql_native_password disabled by default |
| GROUP BY implicit sort order | Never guaranteed — add explicit ORDER BY | Never guaranteed — add explicit ORDER BY |
| Default character set | utf8mb4 | utf8mb4 |
| Query cache | Removed entirely — no ON/OFF option exists | Removed entirely |
| Window functions (OVER()) | Supported | Supported |
| Common Table Expressions (WITH) | Supported, including RECURSIVE | Supported, including RECURSIVE |
| Roles (CREATE ROLE) | Supported | Supported |
| JSON column type | Native binary JSON type, expanded functions | Native binary JSON type |
| Replication terminology | SOURCE / REPLICA syntax added (8.0.23+); old terms still accepted | SOURCE / REPLICA is standard; old MASTER/SLAVE syntax deprecated |
| Upgrade process | Automatic upgrade on startup (since 8.0.16) | Automatic upgrade on startup |
| New reserved keywords | Adds OVER, RECURSIVE, ROW_NUMBER, RANK, LAG, LEAD, GROUPS, WINDOW, and more | Same expanded keyword set as 8.0 |
Explore another pair
Compare any two versions
All 45 released MySQL and MariaDB version lines are listed here — pick any two. Source: endoflife.date (aggregating official MySQL/Oracle and MariaDB Foundation EOL announcements), checked 2026-07-31.