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 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

gollark: I'm not against them, I'm against what they're doing.
gollark: If it's something there's any interest in, of course.
gollark: At best, as Wojbie said, you can make it annoying for people, but then one person will do it and share how.
gollark: You just *cannot* give people access to a thing in one way and expect them to not be able to access it in some other way. Basically every DRM scheme - which this really sounds like - has *failed, inevitably*.
gollark: As Grim Reaper said: if there is *any* important data there or something, *people will get it out* eventually.
This article is issued from Archlinux. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.