Plugins Plugin hub Backup SEO Caching Security Forms WooCommerce Images Best backup plugins
Hosting Hosting directory Shared hosting Managed WordPress Cloud hosting VPS hosting By reader location Hosting finder
Themes & builders Compare Rank Math vs Yoast
Tools All tools Hosting finder Plugin stack builder Cost calculator Salt generator Theme detector Who is hosting this? Speed test Headline analyzer robots.txt generator Redirect generator Uptime calculator Blog name generator
Blog Best backup plugins Deals
Guides All guides Speed up WordPress Choose hosting Back up WordPress
How we test

Explainers · Explainer

What Is MySQL? A Plain Explanation

What Is MySQL? A Plain Explanation

Short answer

MySQL is an open-source relational database system that stores data in tables and answers questions written in SQL. WordPress uses it to store posts, users, comments, and settings, with each post kept as a row in the wp_posts table. WordPress.org recommends MySQL 8.4 or greater, or MariaDB 10.11 or greater, as of November 2026.

Key takeaways

  • MySQL is an open-source relational database system, developed and supported by Oracle, that stores data in tables.
  • WordPress stores posts in wp_posts, settings in wp_options, users in wp_users, and comments in wp_comments.
  • WordPress.org recommends MySQL 8.4 or greater, or MariaDB 10.11 or greater, as of November 2026.
  • MySQL 8.4 LTS has premier support to April 2029 and extended support to April 2032 under Oracle's policy.
  • LTS releases get only necessary fixes, while Innovation releases add new features and are supported only until the next one.

What is MySQL?

MySQL is an open-source relational database system that stores data in tables and answers questions written in SQL.

MySQL's own manual calls it the most popular open-source SQL database management system, developed, distributed, and supported by Oracle Corporation.

A database is a structured collection of data, and a relational database stores that data in separate tables instead of one big store, according to the same manual.

SQL stands for Structured Query Language, and it is the standard language used to read and change data in a database.

MySQL is free to use under the GPL licence, and anyone can download it and change the source code. You pay nothing for the software itself.

How does MySQL store your WordPress content?

WordPress keeps almost all of its content in MySQL tables, with one table for posts, one for users, and one for settings.

Learn WordPress, the project's own teaching site, states that WordPress uses MySQL to store, retrieve, and display all the content you create, including posts, pages, comments, and user data.

The wp_posts table holds posts, pages, and custom post types, and each row in it represents a single post. The wp_postmeta table holds extra fields for each post, often called custom fields.

The wp_options table holds site settings in key-value form, including the site URL, the tagline, the active theme, and the active plugins.

Comments live in wp_comments, users in wp_users, and categories and tags in wp_terms and wp_term_taxonomy.

All tables share a prefix set in wp-config.php, and the default prefix is wp_. You can change the prefix when you install WordPress.

You rarely touch these tables by hand. WordPress reads and writes them for you on every page load, and most hosts provide phpMyAdmin, a free web-based tool for looking inside them.

TableWhat it stores
wp_postsPosts, pages, attachments, menu items, custom post types
wp_postmetaExtra fields for posts, such as custom fields
wp_usersUser accounts, logins, and emails
wp_usermetaExtra fields for users
wp_optionsSettings, site URL, active theme and plugins
wp_commentsComments on posts and pages
wp_termsCategories and tags
wp_term_taxonomyWhether a term is a category or a tag

Our guide on how to optimize the WordPress database explains how to keep these tables fast.

What is the difference between MySQL and MariaDB?

MariaDB is a fork of MySQL built to stay free and open source, and WordPress accepts either one.

WordPress.org's requirements page lists MariaDB 10.11 or greater OR MySQL 8.4 or greater, so both meet the current recommendation.

The WordPress hosting handbook describes MariaDB as a fork of MySQL, intended to remain free and open-source software under the GNU General Public License.

For most WordPress sites, the two behave the same. Your host picks one, and WordPress runs on either without changes.

Our guide on MySQL vs MariaDB for WordPress compares the two in more detail.

Which MySQL version should WordPress use?

Use MySQL 8.4 or greater, or MariaDB 10.11 or greater, because that is what WordPress.org recommends as of November 2026.

WordPress.org's requirements page states the recommendation plainly: PHP 8.3 or greater, MariaDB 10.11 or greater or MySQL 8.4 or greater, and HTTPS support.

Older versions still run WordPress, but WordPress.org warns that PHP 7.4 and MySQL 5.5.5 have reached their official end of life and may expose a site to security vulnerabilities.

MySQL 8.0 is past its end of life too. Oracle's Lifetime Support Policy lists MySQL 8.0 with extended support ending in April 2026, so it gets no new fixes now.

Check with your host before you assume your version. Many hosts still run older MySQL, and the fix is a host setting, not a WordPress setting.

Our guide on WordPress hosting requirements lists the full set of versions WordPress recommends.

What are LTS and Innovation releases?

MySQL ships two tracks: LTS releases for stable production sites, and Innovation releases for people who want the newest features.

The MySQL 8.4 manual states that the release model is divided into two main tracks, LTS and Innovation, and that both are production-grade quality.

LTS releases contain only necessary fixes, and no features are removed within an LTS series. An LTS series follows Oracle's Lifetime Support Policy, with 5 years of premier support and 3 years of extended support.

Innovation releases add new features and behaviour changes, and each one is supported only until the next Innovation release arrives.

Since July 2026, Innovation releases use calendar version numbers. Oracle's MySQL blog states that MySQL 26.7.0 was the first Innovation release to use the new calendar-versioning model, and that 26.10.0 followed in the October 2026 window.

You cannot skip an LTS series when you upgrade. The manual states that 8.4.x can move to 9.7.x, but 8.4.x cannot skip 9.7.x to reach 28.4.x directly.

ReleaseTypeFirst releasePremier support endsExtended support ends
8.4LTSApril 2024April 2029April 2032
9.7LTSApril 2026April 2031April 2034
26.10InnovationOctober 2026Next Innovation releaseNext Innovation release

How do you check your MySQL version?

Your host controls the MySQL version, so the simplest check is to ask your host or look in your hosting panel.

Most hosts provide phpMyAdmin, a free web-based tool that lets you interact with your WordPress database from a browser, according to Learn WordPress.

Compare the version you find with the WordPress.org numbers: MySQL 8.4 or greater, or MariaDB 10.11 or greater.

If your version is older, ask your host to move you to a newer one. A database upgrade is a server job, and your host should do it or guide you through it.

Never edit the database directly unless you have a backup. One wrong change in wp_options can lock you out of your own site.

What happens when MySQL has a problem?

When MySQL stops or the login details are wrong, WordPress shows an “Error establishing a database connection” message and no pages load.

The database holds every post, user, and setting, so a database failure takes the whole site down, not just one page.

MySQL's manual notes that the mysqld server program does most of the work in an installation, and that it handles configuration, logs, and multiple servers on one machine.

MySQL also protects your data while it works. Its manual states that the InnoDB storage engine offers full ACID transactions with row-level locking, multi-versioning, nonlocking repeatable reads, and all four SQL standard isolation levels.

Backups matter because the database is where your content lives. Our guide on how to back up a WordPress database shows how to make a copy you can restore.

What are common myths about MySQL?

Five myths about MySQL keep coming back, and each one falls apart against the manual.

Myth one: MySQL and MariaDB are the same thing. They share roots, but MariaDB is a separate fork with its own releases, and WordPress lists them as separate options.

Myth two: a bigger database is always slower. Size matters less than indexes and queries, and MySQL's manual notes that its server was built to handle large databases faster than earlier solutions.

Myth three: MySQL stores your files. It stores text and settings. Your images and uploads live as files on the server, and only their records sit in wp_posts.

Myth four: you need to learn SQL to run WordPress. You do not. WordPress writes the queries for you, and you only need SQL if you want to inspect or fix the database by hand.

Myth five: MySQL is only for big sites. It runs on a laptop beside your other apps, and it can also scale up to clusters of machines, according to its manual.

Frequently asked questions

Can I use MariaDB instead of MySQL for WordPress?

Yes, and most hosts already do. WordPress.org lists MariaDB 10.11 or greater OR MySQL 8.4 or greater, so both meet the current recommendation. MariaDB is a fork of MySQL built to stay free and open source, and for most WordPress sites the two behave the same.

Does MySQL store my images?

No. MySQL is a database, not a file store. Your images and uploads live as files on the server, and only their records sit in the wp_posts table. The database holds text and settings, such as post content, user accounts, and site options.

Is MySQL 8.0 still safe to use?

MySQL 8.0 is past its end of life. Oracle's Lifetime Support Policy lists its extended support ending in April 2026, so it gets no new fixes. Move to MySQL 8.4 LTS, which has premier support to April 2029 and extended support to April 2032.

Do I need to learn SQL to run WordPress?

No. MySQL stores the data, and WordPress writes the queries for you, so you can run a site without writing SQL. You only need SQL if you want to inspect the database by hand, and most hosts provide phpMyAdmin, a free web-based tool, for that.

How do I find out which MySQL version my site uses?

Your host controls it, so ask your host or look in your hosting panel. Most hosts also provide phpMyAdmin for looking at the database. Compare what you find with the WordPress.org recommendation of MySQL 8.4 or greater, or MariaDB 10.11 or greater.

Sources

  1. What is MySQL? MySQL
  2. MySQL Releases: Innovation and LTS MySQL
  3. The WordPress Database Learn WordPress
  4. Requirements WordPress.org
  5. Oracle Lifetime Support Policy Oracle

Is your product missing, or something out of date?

Tell us what to add or correct. We read every note and reply when we need a source. A message does not buy a ranking.

About the editors

Written and checked byWPLegible Editorial Team Independent WordPress reviews and guides

Researched from the primary sources listed above and checked against our editorial rules before publishing.