20.21 MySQL

mysql-client, mysql-client mysql-server, mysql-server, mysql-server mysql-navigator mytop

MySQL is a common database system used in GNU/Linux. It is extensively used as the backend database server for the Apache web server. To quote the Debian information about mysql-server:

Under Debian install the package mysql-client, mysql-client for connecting to a mysql database server (possibly remote). To run a database server on your local machine you will need to install mysql-server, mysql-server, mysql-server. Install mysql-doc for the full documentation for MySQL.

The package mysql-navigator provides a very effective (but non-GNOME) GUI to MySQL. You can manage the MySQL database server using this. When started, open a connection to the MySQL server on the local host with user root. Most (but not all) admin operations can be performed through the navigator.

A GNOME-based interface, and somewhat easier to use interface, is provided by the gmyclient. This is not yet packaged for Debian but using the alien package creates a Debian package that installs just fine.

A beginner’s tutorial on using MySQL is available from http://www.devshed.com/Server_Side/MySQL/Intro/. Also see the full user manual in /usr/share/doc/mysql-doc/index.html.

---

Your donation will support ongoing availability and give you access to the PDF version of this book. Desktop Survival Guides include Data Science, GNU/Linux, and MLHub. Books available on Amazon include Data Mining with Rattle and Essentials of Data Science. Popular open source software includes rattle, wajig, and mlhub. Hosted by Togaware, a pioneer of free and open source software since 1984. Copyright © 1995-2022 Graham.Williams@togaware.com Creative Commons Attribution-ShareAlike 4.0