MySQL Installation

From Daya Bay
Jump to navigation Jump to search

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:

Use the package installer from the MySQL web site.
SLC or FermiLinux
Use 'yum install mysql-devel mysql-server'
"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 \

Before running dybinst, ensure that the command


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


After installation, ensure the server is running.

Deb/Ubu will start the server automatically, others may need /usr/sbin/service mysql start
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>


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]