Quick install guide for MySQL from source on UNIX
-------------------------------------------------

(And more specifically, linux)
*hint* on FreeBSD, use ports !
-
(pviet@azuria:/usr/ports/databases/mysql323-server)$ cat pkg-descr 
MySQL is a very fast, multi-threaded, multi-user and robust SQL
(Structured Query Language) database server.
[...]
-



This was made on Linux (adapt for any other unix, mainly for the useradd part)

0/ get the source file
----------------------

I like http://mysql.widexs.nl/ because the 10MB download is quick from there

1/ setup user and group for running the server
----------------------------------------------

# groupadd mysql
# useradd -g mysql mysql

2/ compile
----------

% tar xzf mysql-VERSION.tar.gz
% cd mysql-VERSION
% ./configure --prefix=/usr/local/mysql
% make

3/ get super user, and install
------------------------------

% su
password:
# make install

4/ make some tuning. still as root
----------------------------------

# scripts/mysql_install_db
# chown -R root /usr/local/mysql
# chown -R mysql /usr/local/mysql/var
# chgrp -R mysql /usr/local/mysql
# cp support-files/my-medium.cnf /etc/my.cnf
# cp support-files/mysql.server /etc/whereeverarestartupscripts (eg. /etc/init.d/ on debian)
# /etc/whereever/mysql.server start

don't forget to change root password!
$ /usr/local/mysql/bin/mysqladmin -u root password 'thenewpass'

enjoy



--
Patrick Viet <pviet@delta6.net>
on the web, http://home.delta6.net/