Compare UK Hosting
Last updated: 2026-03-16

What is MySQL?

Definition

MySQL is the world's most popular open-source relational database management system, powering millions of websites including WordPress, Drupal, and countless web applications. It stores and organises website data in structured tables, enabling dynamic content, user accounts, and e-commerce functionality.

Why It Matters

  • Powers WordPress and most PHP-based websites
  • Essential for dynamic websites with user-generated content
  • Stores products, orders, and customers for e-commerce
  • Database performance directly affects website speed
  • Required for most content management systems

How It Works

MySQL stores data in tables with rows and columns, similar to spreadsheets but far more powerful. Tables are linked through relationships (relational database). When you visit a WordPress page, PHP queries the MySQL database for content, processes it, and generates HTML. MySQL uses SQL (Structured Query Language) for data operations like SELECT, INSERT, UPDATE, and DELETE.

Pros & Cons

Advantages

  • Free and open-source
  • Extremely well-documented
  • Supported by virtually all web hosts
  • Handles large datasets efficiently
  • Strong community and ecosystem

Disadvantages

  • Can become slow without optimisation
  • Requires technical knowledge to manage directly
  • Backup and recovery need attention
  • Performance tuning is complex
  • Large databases increase hosting requirements

Common Misconceptions

  • !MySQL is only for large websites (Small sites use it too—WordPress always needs it)
  • !You need to know SQL to use MySQL (CMS platforms handle it automatically)
  • !More databases mean better performance (One optimised database is usually sufficient)
  • !MySQL and MariaDB are completely different (MariaDB is a MySQL fork, largely compatible)

Do You Need MySQL? Checklist

Consider mysql if any of these apply to you:

  • Your hosting plan includes sufficient MySQL databases
  • Database backups are configured
  • You know how to access phpMyAdmin
  • Database size limits meet your needs
  • You understand basic database maintenance
  • Remote database access is configured if needed

Recommended Hosts for MySQL

SiteGround

Optimised MySQL with automatic backups

Read Review

Kinsta

High-performance MariaDB (MySQL compatible)

Read Review
View All Provider Reviews

Frequently Asked Questions

How many MySQL databases do I need?
Most websites need one database. WordPress uses one database regardless of content volume. Multiple databases are typically for multiple websites or applications on the same hosting account.
What is phpMyAdmin?
phpMyAdmin is a web-based interface for managing MySQL databases. It lets you view tables, run queries, import/export data, and perform maintenance without command-line knowledge. Most hosts include it in cPanel.
How do I backup my MySQL database?
Use phpMyAdmin's Export feature, your host's backup tools, or WordPress plugins like UpdraftPlus. For large databases, command-line mysqldump is faster. Schedule regular automatic backups.
Why is my database slow?
Common causes: unoptimised queries, missing indexes, bloated tables (revisions, spam), inadequate server resources, or too many simultaneous connections. Use caching, optimise tables, and clean unnecessary data.
What is the difference between MySQL and MariaDB?
MariaDB is a community fork of MySQL, created by MySQL's original developers. They're largely compatible—most MySQL applications work with MariaDB unchanged. MariaDB often offers better performance.
Can I access MySQL remotely?
Some hosts allow remote MySQL connections (useful for local development). Enable it in cPanel under "Remote MySQL" by adding your IP address. Many hosts restrict this for security.
What database size do I need?
Most websites need under 1GB. A typical WordPress blog uses 50-200MB. E-commerce sites with thousands of products might need 1-5GB. Check your current usage in phpMyAdmin or cPanel.

Need Help Choosing?

Use our calculator to find the perfect hosting plan for your needs.

Try Calculator
Back to Glossary