Installing MySQL from Source

Get the source code

tar -xzf mysql-5.0.XX.tar.gz
% cd mysql-5.0*
% ./configure 
--enable-thread-safe-client 
--with-big-tables 
--with-fast-mutexes 
--with-extra-charsets=all 
--with-innodb 

and if you want some more engines

--with-archive-storage-engine 
--with-blackhole-storage-engine 
--with-csv-storage-engine 
--with-example-storage-engine 
--with-federated-storage-engine

% make
% make install

Then:

chown -R mysql /usr/local/mysql/var
chmod -R 755 /usr/local/mysql/var

path could also be:

chown -R mysql /usr/local/var/
chmod -R 755 /usr/local/var

Also run :

/usr/local/bin/mysql_install_db /usr/local/bin/mysqld_safe &

Dont forget to change the admin password :

mysqladmin -u root -p password 'new-password'

On Linux/CentOS/RedHat :

1. Copy mysql.server.sh from the src directory /support-files to /etc/init.d and rename it to mysqld 2. Enter it into the startup scripts :

chkconfig –add mysqld chkconfig mysqld on

3. Edit the /etc/init.d/mysqld script so that the correct parameters (basedir , datadir, etc) are filled in and run the script to test it

4. Start and stop the service with : service mysqld stop service mysqld start