Skip to main content

Glossary

What Is MySQL

MySQL is a popular open-source relational database used to store and manage data for websites and applications. Learn what MySQL is and when it is used.

Definition

MySQL is an open-source relational database management system that stores data in structured tables with defined relationships between them. It uses SQL (Structured Query Language) to create, read, update, and delete data. MySQL has been one of the most widely used databases on the web for over two decades and powers everything from small business websites to large-scale applications. It is the default database for many popular platforms, including WordPress, and is supported by virtually every hosting provider and web framework.

Why It Matters

MySQL is the database behind a significant proportion of the websites and applications you interact with daily. Its popularity means there is extensive documentation, a large community, and broad hosting support, which keeps development and hosting costs lower. For most small to medium business applications (content management, e-commerce, customer portals) MySQL provides more than enough performance and reliability. Understanding that your site runs on MySQL helps you have informed conversations with developers about performance, backups, and scaling, even if you never write a database query yourself. See the database glossary entry for the underlying concepts, or what is PostgreSQL if you want to compare the two most common open-source options.

Example

A business runs their website on WordPress, which uses MySQL to store all of their pages, blog posts, user accounts, and settings. When a visitor loads a page, WordPress queries the MySQL database to retrieve the content, assembles it into HTML, and sends it to the browser. When the site administrator publishes a new blog post, it is written to the MySQL database. Backups of the database ensure that if anything goes wrong, all content can be restored to its last saved state. Browse the full glossary for related definitions.

Portrait of Alexander De Sousa, founder of Digital Royalty
Founder-led
“I’ve put everything I know into how this company works — the standards, the method, the care on every project. It runs through the whole team, and I hold us all to it.”

Alexander De Sousa · Founder LinkedIn

Featured on BBC Radio Solent

Get started

Tell us what you need

A few quick questions, then a straight answer from a real person — usually within a few hours.

Tell us what you're working on

Whether it's a new site, a platform, or a process that shouldn't be manual any more — we'll tell you honestly if we can help.