Database Reference
In-Depth Information
You can enter this command on one line without the backslashes. Several other configura-
tion options are available. To get a complete and current listing of options permitted with
the installation package you downloaded, enter the following from the command line:
./configure --help
You may also want to look at the latest
online documentation for compiling MySQL
.
Once you've decided on any options that you want, run the
configure
script with those op-
tions. It will take quite a while to run, and it will display a great amount of information,
which you can ignore usually if it ends successfully. After the
configure
script finishes,
the binaries will need to be built and MySQL needs to be initialized. To do this, enter the
following:
make
make install
cd /usr/local/mysql
./scripts/mysql_install_db
The first line here builds the binary programs. There may be plenty of text displayed after
that line and the next one, but I omitted that output to save space. If the command is suc-
cessful, you need to enter the second line to install the binary programs and related files in
the appropriate directories. The third line changes to the directory where MySQL was in-
stalled. If you configured MySQL to be installed in a different directory, you'll have to
use that directory path instead. The last command uses a script provided with the distribu-
tion to generate the initial user privileges or grant tables.
All that remains is to change the ownership of the MySQL programs and directories. You
can do this by entering the following:
chown -R mysql /usr/local/mysql
chgrp -R mysql /usr/local/mysql
The first line here changes ownership of the MySQL directories and programs to the
filesystem user,
mysql
. The second line changes the group owner of the same directories
and files to the group
mysql
. These file paths may be different depending on the version of
MySQL you installed and whether you configured MySQL for different paths.
With the programs installed and their file ownerships set properly, you can start the dae-
mon. You can do this in several ways. To make sure that the daemon is restarted in the
event that it crashes, enter the following from the command line:
/usr/local/mysql/bin/mysqld_safe &
