MySQL: Difference between revisions

Latest revision as of 09:22, 9 September 2023

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: mysql^AUR.

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 || mycli^AUR

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.

@@ Line 2: / Line 2: @@
 [[Category:Oracle]]
 [[es:MySQL]]
-[[it:MySQL]]
+[[fr:MySQL]]
 [[ja:MySQL]]
-[[ru:MySQL]]
 [[zh-hans:MySQL]]
 [[Wikipedia:MySQL|MySQL]] is a widely spread, multi-threaded, multi-user SQL database, developed by Oracle.
-Arch Linux favors [[MariaDB]], a community-developed fork of MySQL, aiming for drop-in compatibility. Oracle's MySQL was [https://www.archlinux.org/news/mariadb-replaces-mysql-in-repositories/ dropped] to the [[AUR]]: {{AUR|mysql}}. Another fork aiming to be fully compatible is [[Wikipedia:Percona Server for MySQL|Percona Server]], available as {{Pkg|percona-server}}.
+== Installation ==
+Arch Linux favors [[MariaDB]], a community-developed fork of MySQL, aiming for drop-in compatibility.
+Oracle's MySQL was [https://archlinux.org/news/mariadb-replaces-mysql-in-repositories/ dropped] to the [[AUR]]: {{AUR|mysql}}.
+Another fork aiming to be fully compatible is [[Wikipedia:Percona Server for MySQL|Percona Server]], available as {{Pkg|percona-server}}.
 The [[Wikipedia:InnoDB|InnoDB]] storage engine by Oracle was also forked by Percona as [[Wikipedia:XtraDB|XtraDB]]. The fork is used by both [[MariaDB]] and Percona Server.
-== Graphical tools ==
+=== Graphical tools ===
 * {{App|[[phpMyAdmin]]|MySQL web interface, written in PHP.|https://www.phpmyadmin.net|{{Pkg|phpmyadmin}}}}
@@ Line 19: / Line 24: @@
 For tools supporting multiple DBMSs, see [[List of applications/Documents#Database tools]].
-== Console tools ==
+=== Console tools ===
 * {{App|MyCLI|A terminal client for MySQL with autocompletion and syntax highlighting.|https://www.mycli.net|{{AUR|mycli}}}}
-== Programmatic access ==
+=== Programmatic access ===
 * [[JDBC and MySQL]]
 * [[PHP#MySQL/MariaDB]]
 * [[Python]]
-** {{Pkg|mysql-python}}
 ** {{Pkg|python-mysqlclient}}
 ** {{Pkg|python-mysql-connector}}
@@ Line 35: / Line 39: @@
 * [[Perl]]
 ** {{Pkg|perl-dbd-mysql}}
+* [[Ruby]]
+** {{AUR|ruby-mysql2}}
+=== 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 [https://docs.docker.com/engine/reference/commandline/run/#ulimit ulimit]. See [https://github.com/docker-library/mysql/issues/579 GitHub issue] for more information.