Editing MySQL (section)

==User interfaces==
===Graphical user interfaces===
A [[graphical user interface]] (GUI) is a type of interface that allows users to interact with electronic devices or programs through graphical icons and visual indicators such as secondary notation, as opposed to text-based interfaces, typed command labels or text navigation.

Third-party proprietary and free graphical administration applications (or "front ends") are available that integrate with MySQL and enable users to work with database structure and data visually.

[[File:The MySQL Workbench startup screen.png|thumb|right|[[MySQL Workbench]] running on macOS]]

====MySQL Workbench====
{{main|MySQL Workbench}}
[[MySQL Workbench]] is the integrated environment for MySQL. It was developed by MySQL AB, and enables users to graphically administer MySQL databases and visually design database structures.

MySQL Workbench is available in three editions, the regular [[Free and open source software|free and open source]] ''Community Edition'' which may be downloaded from the MySQL website, and the proprietary ''Standard Edition'' which extends and improves the feature set of the Community Edition, and the MySQL Cluster CGE.<ref>{{Cite web|url=https://www.mysql.com/products/|title = MySQL :: MySQL Products}}</ref><ref>{{Cite web|url=https://www.mysql.com/products/community/|title = MySQL :: MySQL Community Edition}}</ref>

====Other GUI tools====
* [[Adminer]]
* [[Database Workbench]]
* [[DBeaver]]
* [[DBEdit]]
* [[DbForge]]
* [[HeidiSQL]]
* [[LibreOffice Base]]
* [[Navicat]]
* [[OpenOffice.org]] Base
* [[phpMyAdmin]]
* [[SQLBuddy]]
* [[SQLyog]]
* [[Toad (software)|Toad for MySQL]]
* [[Webmin]]

===Command-line interfaces===
A [[command-line interface]] is a means of interacting with a computer program where the user issues commands to the program by typing in successive lines of text (command lines). MySQL ships with many [[command line]] tools, from which the main interface is the {{Mono|mysql}} client.<ref name="mysql – The MySQL Command-Line Tool">{{Cite web |url=http://dev.mysql.com/doc/refman/5.6/en/mysql.html |title=mysql — The MySQL Command-Line Tool, MySQL Reference Manual |access-date=17 June 2015 |archive-date=17 June 2015 |archive-url=https://web.archive.org/web/20150617191142/http://dev.mysql.com/doc/refman/5.6/en/mysql.html |url-status=dead }}</ref><ref name="mysqladmin - the MySQL command-line tool">{{Cite web |url=http://dev.mysql.com/doc/refman/5.5/en/mysqladmin.html |title=mysqladmin – the MySQL command-line tool, MySQL Reference Manual |access-date=18 January 2013 |archive-date=12 January 2013 |archive-url=https://web.archive.org/web/20130112203324/http://dev.mysql.com/doc/refman/5.5/en/mysqladmin.html |url-status=dead }}</ref>

MySQL Utilities is a set of utilities designed to perform common maintenance and administrative tasks. Originally included as part of the MySQL Workbench, the utilities are a stand-alone download available from Oracle.

Percona Toolkit is a cross-platform toolkit for MySQL, developed in [[Perl]].<ref>{{cite web|url=http://www.percona.com/software/percona-toolkit |title=Percona Toolkit|publisher=Percona |access-date=26 March 2014}}</ref> Percona Toolkit can be used to prove replication is working correctly, fix corrupted data, automate repetitive tasks, and speed up servers. Percona Toolkit is included with several [[Linux]] distributions such as [[CentOS]] and [[Debian]], and packages are available for [[Fedora Linux|Fedora]] and [[Ubuntu]] as well. Percona Toolkit was originally developed as Maatkit, but as of late 2011, Maatkit is no longer developed.

MySQL shell is a tool for interactive use and administration of the MySQL database. It supports JavaScript, Python or SQL modes and it can be used for administration and access purposes.<ref>{{Cite web|url=https://dev.mysql.com/downloads/shell/|title=MySQL :: Download MySQL Shell|website=dev.mysql.com|access-date=2019-03-09}}</ref>