GNU/Linux Desktop Survival Guide by Graham Williams
Desktop Survival Project Home Preface Advocacy History Distributions Installing GNU/Linux Basic Survival Wajig Applications AI, Machine Learning, Data Science Android - GNU/Linux Devices Audio Backup Booting CD Chinese ChRoot Clock Command Line Databases DIA Directories Disks EcoSysL Emacs Email Evolution Files File Systems Firewalls Floppy Disks FreedomBox Glade GNOME Graphics, Images, Photos Hardware Initialisations on Booting Installation Examples Internet IOT Java KDE Kernels Keyboard Konqueror KVM Switch LATEX Log System Login Magellan MATE Mathematics Memory Modems Mounting Devices MS/Windows Music MySQL Nautilus Networks Nextcloud Network File System NFS NT File System Oracle Packages Partitions Passwords PDF Power Management PPP Presentations Printing Python R Remote Desktops Rsync Samba Scanning Science Screens Security Spreadsheet SSH Swap Teradata Data Warehouse Themes TV Unity USB Version Control Video Virtualization Voice over IP WebCam WordPress Web Sites Word Processing and Printing X XML Troubleshooting Index

CLICK HERE TO VISIT THE UPDATED SURVIVAL GUIDE

MySQL

Debian Packages: mysql-client 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:

The main goals of MySQL are speed, robustness and easy to use. MySQL was originally developed because Tcx needed a SQL server that could handle very big databases with magnitude higher speed than what any database vendor could offer. They have now been using MySQL since 1996 in a environment with more than 40 databases, 10,000 tables, of which more than 500 have more than 7 million rows. This is about 50G of mission critical data.

Under Debian install the package 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. 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.