Installing Mysql from source in Ubuntu
I was doing a newsletter project for my company for that i need a Web server with PHP/Mysql support, so i selected lighttpd with PHP/Mysql. I got stuck at several points while installing Mysql. I am posting the error that i encountered while installing Mysql in my ubuntu machine.
I used the Mysql source for Database installation. Downloaded the source file from :
http://dev.mysql.com/get/Downloads/MySQL-5.0/mysql-5.0.51b.tar.gz/from/http://mysql.mirror.rafal.ca/
Then configured with following command :
./configure –prefix=/usr/unni/mysql5 –with-unix-socket-path=/tmp/mysql.sock
But it ended with an error :
checking for termcap functions library… configure: error: No curses/termcap library found
Google gave me a solution at :
http://darpanetwork.blogspot.com/2008/02/compiling-mysql-on-ubuntu-linux.html
So i installed libncurses5-dev and fixed that error :
#apt-get install libncurses5-dev
Then configuration went successfully, but the make command gave another error :
====================================
g++ -DDEFAULT_BASEDIR=\”/usr/unni/mysql5\” -DDATADIR=”\”/usr/unni/mysql5/var\”" -DDEFAULT_CHARSET_HOME=”\”/usr/unni/mysql5\”" -DSHAREDIR=”\”/usr/unni/mysql5/share/mysql\”" -DDEFAULT_HOME_ENV=MYSQL_HOME -DDEFAULT_GROUP_SUFFIX_ENV=MYSQL_GROUP_SUFFIX -DDEFAULT_SYSCONFDIR=”\”/usr/unni/mysql5/etc\”" -DHAVE_CONFIG_H -I. -I. -I../include -I../include -I../include -I. -O -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -c -o my_new.o my_new.cc
../depcomp: line 512: exec: g++: not found
make[2]: *** [my_new.o] Error 127
make[2]: Leaving directory `/usr/unni/mysql-5.0.51/mysys’
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/usr/unni/mysql-5.0.51′
make: *** [all] Error 2
==============================================
This time i figured out the error as the absence of basic compilers, so i installed Ubuntu build-essential, that fixed that error.
# apt-get install build-essential
But i got another error from make command :
==============================================
g++ -DDEFAULT_BASEDIR=\”/usr/unni/mysql5\” -DDATADIR=”\”/usr/unni/mysql5/var\”" -DDEFAULT_CHARSET_HOME=”\”/usr/unni/mysql5\”" -DSHAREDIR=”\”/usr/unni/mysql5/share/mysql\”" -DDEFAULT_HOME_ENV=MYSQL_HOME -DDEFAULT_GROUP_SUFFIX_ENV=MYSQL_GROUP_SUFFIX -DDEFAULT_SYSCONFDIR=”\”/usr/unni/mysql5/etc\”" -DHAVE_CONFIG_H -I. -I. -I../include -I../include -I../include -I. -O -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -c -o my_new.o my_new.cc
../include/my_global.h:987: error: redeclaration of C++ built-in type ‘bool’
make[2]: *** [my_new.o] Error 1
make[2]: Leaving directory `/usr/unni/mysql-5.0.51/mysys’
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/usr/unni/mysql-5.0.51′
make: *** [all] Error 2
===================================================
Mysql forum gave me the solution :
This happened because, first the make command used the native C compiler since there was no g++ compiler ( configuration command set the compiler as gcc, because that was the available compiler ). After that i installed the g++ compiler so the next make used the g++ to compile the C code as C++ .
Solution :
Run the configuration command again followed by make :
1. ./configure –prefix=/usr/unni/mysql5 –with-unix-socket-path=/tmp/mysql.sock
2. make
3. make install
Thats done 
Amarok is one my favorite audio player in Linux. It is stable and provides handful of features, it act as a audio player, podcast client, radio receiver and much more ………..
