MySQL Configuration

Configure Options:
The configure script gives a great deal of control over how to configure 
MySQL distribution. To see list the options supported by configure: 
               shell> ./configure --help

Some important options for "configure" command we use in our case: 

1. Changing location: 
        Change the installation prefix so that everything is installed under 
        the desired directory rather than the default of `/usr/local/mysql':

        %configure --prefix=/Path-To-Mysql/mysql

2. To load data from any outside files into mysql database:
       --enable-local-infile

3. Set mysql default user name as mysql: 
     --with-mysqld-user=mysql

4. Options file my.cnf:  
        Different levels of my.cnf files as my-small.cnf,my-medium.cnf, my-large.cnf 
        and my-huge.cnf depending on how big machine user is using are located in 
        $MYSQL_DIR/share/mysql directory. 
        My.cnf file holds any server-specific default options for the MySQL server. 
        It can be edited by user to set any options for the server.


Installing many servers on the same machine 

        Assume an existing server is configured for the default port number and socket file. 
        Two possible options to use another mysql server on the same machine:

        1. Configure the new server with a configure command something like this:
        %configure  --with-tcp-port=port_number \
                      --with-unix-socket-path=file_name --prefix=/.../.../mysqlXXX

        Here port_number and file_name should be different from the default port number and 
        socket name and the --prefix value should specify an installation directory different 
        from the one under which the existing MySQL installation is located.
        Ups tailor mysql takes care of configuring multiple instances mysql server on the 
        same machine with user-defined data directory.  
 

Mail comments to:css-dgs@fnal.gov
Last Modified  December 19, 2002