Dowload Source File :
#cd /tmp
#wget http://dev.mysql.com/get/Downloads/MySQL-5.1/mysql-5.1.25-rc.tar.gz/from/http://mysql.llarian.net/

Extract Source File :
#tar zxvf /tmp/mysql-5.1.25-rc.tar.gz
#cd /tmp/mysql-5.1.25-rc

Install Pacakge & Development Libralie :
#apt-get install build-essential libncurses5 libncurses5-dev

Add User & Group :
#groupadd mysql
#useradd -g mysql mysql

Configuration :
#./configure \
–prefix=/usr/local/mysql \
–with-mysqld-user=mysql \
–without-debug \
–with-client-ldflags=-all-static \
–with-mysqld-ldflags=-all-static \
–disable-shared \
–localstatedir=/usr/local/mysql/data \
–with-extra-charsets=none \
–enable-assembler \
–with-unix-socket-path=/tmp/mysql.socket

#make
#make install

 Copy my.cnf
#cd /tmp/mysql-5.1.25-rc
#cp support-files/my-medium.cnf /etc/my.cnf

Create GRANT tables :
#/usr/local/mysql/bin/mysql_install_db –user=mysql

Changing Owners :
#chown -R root  /usr/local/mysql
#chown -R mysql /usr/local/mysql/var
#chgrp -R mysql /usr/local/mysql

Testing:
#/usr/local/mysql/bin/mysqld_safe -user=mysql&

Set a root password for MySQL (does not affect system root’s password) :

#/usr/local/mysql/bin/mysqladmin -u root password new_password

Try to log in!:

#/usr/local/mysql/bin/mysql

You should add /usr/local/mysql/bin to your path so you can always use mysql, mysqldump, mysqladmin and some others right from the shell.

Starting Mysql at boot time :

#cp support-files/mysql.server /etc/init.d/mysql
#chmod +x /etc/init.d/mysql
#update-rc.d mysql defaults

ref : https://help.ubuntu.com/community/MYSQL5FromSource

Filed under: Ubuntu |
You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Related Posts