MySQL Installation

From Daya Bay

Jump to: navigation, 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:

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]

Personal tools