NAME

mysql - An LCFG component for the MySQL database

DESCRIPTION

This component starts, stops and manages the MySQL database system.

The first time it is a run on a given host, it generates an empty database, and sets up a password protected root account. It is recommended that tools which need root access to the database issue their commands using 'om mysql runcommand sql command'

METHODS

Dump file

This dumps a complete copy of the database to the file given in file

RunCommand < sql-commands

This runs the commands given on STDIN as the root user, against the 'mysql' database

RESOURCES

datadir

The directory that the databases will be stored in (mysql's datadir directive)

socket

The location of the Unix socket the server will listen on (the socket directive)

user

The user that the server will run as

serverbase

The path of the mysql installation directory (the basedir option)

nonetwork

Set this to a non-zero value to disable network access to the database (the skip-networking directive)

skipinnodb

A boolean, ie yes|no true|false. The default is false. If it is true it starts the daemon with the --skip-innodb option.

variables

A space seperated list of program variables to set

variable_var

Set variable var to the given value.

varname_

A list of variables names which can't be on the LHS of an LCFG statement, e.g

   !mysql.variables mSET(havessl)
   mysql.varname_havessl     have_ssl
   mysql.variable_havessl    yes
 

AUTHORS

Simon Wilkinson <simon@sxw.org.uk>
Neil Brown <Neil.Brown@ed.ac.uk>