MySQL Installation

Client installation

By default, dybinst installs client libraries automatically. However, if you want to run a local copy of the database server, read on.

Typically, each institution will run it's own server. Laptop users may also want to install a server.

Server installation

It is more efficient, but not neccessary, to install the MySQL server before running dybinst.

MySQL is freely available [here]. We currently require a sever version 4.2 or higher. The current recommend version is [5.0], but if possible you should use the version best comptaible with your operating system:

Recommended install methods:

MacOSX

Use the package installer from the MySQL web site.

SLC or FermiLinux

Use 'yum install mysql-devel mysql-server'

Debian

"apt-get install mysql-server"

If you wish to build the server from source, follow the instructions on the MySQL website. It is recommended that you build with the following options:

$ ./configure --prefix=<your_install_path> 
              --without-bench \
              --enable-thread-safe-client \
              --enable-shared \
              --disable-static \
              --enable-local-infile

Before running dybinst, ensure that the command

mysql_config

is in your $PATH, so that the installation scripts can find it.

Post-installation

After installation, ensure the server is running.

Linux

Deb/Ubu will start the server automatically, others may need /usr/sbin/service mysql start

MacOSX

Use the Control Panel

Remember to set the root password if you are not queried for it during installation:

$ mysqladmin --user=root password <root_pw>

Population

To populate your server with tables, it should become a slave to one of the masters. See [MySQL_Replication_for_Offline_DB].

User Configuration

See manual, eg: [1]