MySQL Configuration

Introduction

MySQL is a multithreaded, multi-user SQL database management system (DBMS) that see wide use in the Linux environment (amongst others). I initially installed it in order to support Zoneminder.

For a general definition see: http://en.wikipedia.org/wiki/MySQL, but more comprehensive information is available from the offical site at http://www.mysql.com/.

MySQL was required in order to support the ZoneMinder application so that remote management and control of a suite of WebCams from the Linux server could be carried out. For details about the installation and configuration of ZoneMinder to use this, and other Webcams, see: ZoneMinder on the Linux Web-server. In fact the ZoneMinder configuration procedure includes setting up MySQL as part of the Zoneminder process.

The following guidance might be useful in helping to configure MySQL on an Apache Web-server running on Linux.

My MySQL Server Configuration

After experimentation I arrived at the following /etc/httpd/httpd.conf configuration file, which allowed me to set-up a number of virtual servers on the same physical server.

===== httpd.conf fragment =====
#
# DETAILS TBA
# ...
#
...
=====

General Links

For general links to useful references when setting up MySQL see: Apache resources on the Internet.

The following general links are useful references when setting up MySQL: