What is MySQL?

What is MySQL?

MySQL is an open source relational database management system that uses the SQL language to store, organize, and query information in a structured way. Put simply, it is the digital warehouse where a website or application keeps its data —users, products, orders, posts— and then retrieves it in fractions of a second whenever it is needed.

MySQL was born in 1995, created by the Swedish founders David Axmark and Allan Larsson together with the Finnish developer Michael 'Monty' Widenius, who set up the company MySQL AB. The name combines 'My', after Monty's daughter My, with 'SQL', the standard language for relational databases. The company was acquired by Sun Microsystems in 2008 and by Oracle in 2010, which has kept developing it under a dual-license model: the Community edition, free and open source, and commercial editions with technical support and additional features.

Despite that corporate history, the Community edition is still free and is what the vast majority of projects use. According to many surveys, MySQL is the most widely used relational database management system in the world, and it is the 'M' in the famous LAMP stack (Linux, Apache, MySQL and PHP), the combination of technologies that has powered a huge share of the internet for more than two decades.

What is MySQL used for?

The main purpose of MySQL is to act as the central data store for websites and applications that need to keep information permanently and query it quickly. The most common uses are:

• Dynamic websites: blogs, digital newspapers, forums, and portals whose content lives in the database rather than in fixed pages. When a visitor opens an article, the site queries MySQL and receives the text stored in a table.
• Online stores: product catalogs, prices, stock levels, shopping carts, and orders are organized in tables that relate to one another.
• Business applications: invoicing, inventory, customer records, payroll, and school systems in which many users enter and read data at the same time.
• PHP-based platforms: content management systems such as WordPress, Joomla, or Drupal and frameworks such as Laravel or Symfony use MySQL as their default or main database. The PHP and MySQL pairing is probably the most widespread in the history of web development.

MySQL is also used to store event logs, application metrics, job queues, or data from connected devices, and as the database for information volumes that do not require massive Big Data tools.

Core concepts: databases, tables, records, and queries

To understand what MySQL is, it helps to master four concepts you will use every day:

• Database: a logical container that groups the tables of a project. A single MySQL server can host hundreds of independent databases.
• Table: a structure that organizes data into rows and columns. Each column represents a field (for example, name or email) and each row a complete item.
• Record: also called a row, it is one individual entry inside a table. If a table stores customers, each customer takes one record.
• Query: an instruction written in SQL that asks the server to create, read, update, or delete data.

A simple example makes it clear. Imagine a table called customers with the columns id, name, and email. To add a customer you run an insert query:

INSERT INTO customers (name, email) VALUES ('Ana Torres', 'ana@example.com');

To retrieve that customer later, you use a select query:

SELECT name, email FROM customers WHERE id = 1;

The server processes the instruction and returns the rows that match the condition. Inserting and querying are the basis of almost everything else: updating a price, deleting an account, or counting how many orders were placed today are variations of the same language.

How MySQL works: client-server architecture

Unlike embedded database engines, MySQL works on a client-server model. The server is a standalone program called mysqld that keeps running and listens for requests, by default, on port 3306. Clients —the mysql command-line tool, a PHP script, a desktop application, or a remote system— connect to that server with a username and password, send SQL statements, and receive the results.

That design brings several important advantages:

• Multi-user concurrency: many clients can connect and work at the same time, even on the same tables.
• Granular permissions: each user can have limited rights, for example read-only access or access to certain tables only.
• Network access: the database does not have to live on the same machine as the website; it can sit on a separate server.
• Reliability: with the InnoDB storage engine, the default since version 5.5, MySQL complies with ACID properties (atomicity, consistency, isolation, and durability), which prevents transactions from being left half-finished after a crash.

When a website receives a visit, the typical sequence is this: the PHP code opens a connection to MySQL, sends an SQL query, waits for the server's answer, and turns the returned rows into the HTML content the user sees. All that exchange happens in milliseconds and, when properly configured, it handles thousands of queries per second.

MySQL vs SQLite: which one should you choose?

SQLite is the other engine that usually comes up in the same conversations, and the essential difference is that it does not work as a server: it is an embedded library that stores the whole database in a single file. The table below summarizes the key differences:

The practical rule is simple: if the project needs several users or several machines writing data at the same time, or if it will be deployed on a host and grow over the years, MySQL is the natural choice. If it is a desktop application, a prototype, a mobile app, or a single-user system, SQLite is enough and simplifies everything, because there is no server to manage.

How to get started with MySQL

The quickest way to try MySQL on a personal computer is to install a package that brings it pre-configured:

• On Windows: XAMPP, WAMP, or Laragon install Apache, MySQL, and PHP together, with a control panel that starts and stops the database server with one click.
• On macOS: MAMP offers the same, or MySQL can be installed with Homebrew.
• On Linux: on Debian- or Ubuntu-based distributions you just run sudo apt install mysql-server and then sudo systemctl start mysql.

XAMPP is the favorite choice for beginners, because it also includes phpMyAdmin, a web interface for administering databases without typing commands. Once the server is running, the next step is connecting from the terminal:

mysql -u root -p

After entering the password, you can run your first statements. Creating a database and a table, and inserting one record, takes just a few lines:

CREATE DATABASE my_store;

USE my_store;

CREATE TABLE products (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(100), price DECIMAL(10,2));

INSERT INTO products (name, price) VALUES ('Keyboard', 45.00);

SELECT * FROM products;

One piece of advice from day one: change the root user's password, create users with limited permissions for each application, and never expose port 3306 to the internet. On a production site, the database usually lives on a separate server from the website, with automatic backups.

Why is MySQL so popular?

Several reasons explain its dominance for almost three decades:

• It is free and open source: anyone can download it, use it in production, and study it without paying licenses.
• Maturity: it has been developed since 1995, which means stability, constant bug fixing, and predictable behavior in production.
• Standard SQL: whoever learns MySQL learns SQL, a language that also works with other engines such as PostgreSQL or MariaDB.
• Universal compatibility: official connectors exist for PHP, Python, Java, Node.js, C#, and practically any language.
• Web ecosystem: every budget host includes it, and tools such as phpMyAdmin or WordPress have made it the default engine of millions of sites.
• Room to grow: the same engine that powers a small blog can scale, with good configuration, to enormous volumes; companies such as Facebook, Twitter, or YouTube used it for years at large scale.

MySQL is not the right tool for every case —some projects prefer PostgreSQL for its advanced features, or NoSQL databases for unstructured data—, but for traditional web development, business applications, and e-commerce it remains the most sensible starting point: free, well documented, predictable, and backed by an enormous community. Understanding what MySQL is and how to use it puts the most common database on the internet in your hands.