MySQL

MySQL is a widely spread, multi-threaded, multi-user SQL database, developed by Oracle.

Installation

Arch Linux favors MariaDB, a community-developed fork of MySQL, aiming for drop-in compatibility.

Oracle's MySQL was dropped to the AUR: mysqlAUR.

Another fork aiming to be fully compatible is Percona Server, available as percona-server.

The InnoDB storage engine by Oracle was also forked by Percona as XtraDB. The fork is used by both MariaDB and Percona Server.

Graphical tools

  • phpMyAdmin — MySQL web interface, written in PHP.
https://www.phpmyadmin.net || phpmyadmin
  • MySQL Workbench — Unified visual tool for database architects, developers, and DBAs. Developed by Oracle and not guaranteed to work with MariaDB.
https://www.mysql.com/products/workbench/ || mysql-workbench

For tools supporting multiple DBMSs, see List of applications/Documents#Database tools.

Console tools

  • MyCLI — A terminal client for MySQL with autocompletion and syntax highlighting.
https://www.mycli.net || mycliAUR

Programmatic access

Docker

A docker image is available: https://hub.docker.com/_/mysql

Troubleshooting

Cannot connect to local MySQL server through socket

If running a new container fails to start, you may need to increase the ulimit. See GitHub issue for more information.

This article is issued from Archlinux. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.