Skip to content
Runbook

MySQL

Popular open source SQL relational database.

Databasesqlrdbmsrelationaldatabaseacid

Choose a platform

Overview

MySQL is one of the most widely deployed open source relational databases, central to the classic LAMP stack and to countless web applications. It speaks SQL, supports ACID transactions through the InnoDB engine, and listens on port 3306 by default. Clients connect with the mysql command-line tool or a library.

Arch Linux: MariaDB instead of MySQL

Arch Linux's official repositories do not ship Oracle's MySQL: the mysql package is MariaDB, a drop-in fork. Native MySQL is only available through the AUR (yay -S mysql). That is why this guide has no Arch page — on Arch, install MariaDB (sudo pacman -S mariadb), which is compatible with the same mysql client, port 3306, and SQL dialect for the vast majority of use cases.

Command-line tools

The suite includes mysql (interactive client), mysqladmin (administration), mysqldump (logical backups), and mysql_secure_installation (hardening: set the root password, remove anonymous accounts and the test database).