Skip to content
BENIBIX Learn

MySQL

Development🗃️ DatabasesRelational Databases

Also known as My SQL

A popular, free SQL database. A huge share of websites run on it.

Think of it like

Think of it like the most common shelf in a shop. You see it in all shops, since it is simple and it works.

Example

Jack's WordPress blog stores every post and comment in MySQL. Oracle has owned MySQL since 2010.

Why it matters

If you work on websites, you will meet MySQL. It is behind a great many of them.

Definition

MySQL is a popular open-source relational database, first released in 1995. It powers a huge share of websites, including most WordPress sites. It is fast for simple reads and easy to set up. A close copy called MariaDB was started by its first author and works almost the same. Its server listens on port 3306 by default.

Common mistake

Assuming SQL written for MySQL runs the same on PostgreSQL. Small differences in syntax and rules can break it.

Key takeaways

  1. 1
    Everywhere. Behind a huge share of sites.
  2. 2
    Simple to start. Easy to set up and run.
  3. 3
    MariaDB twin. A close copy with the same roots.

Compare