Install Mysql From Source

Install Mysql From Source ------------------------------------------------------------------------------------------------------------...

Install Mysql From Source

---------------------------------------------------------------------------------------------------------------------------------
1'st install dependencies for mysql
--------------------------------------------------------------------------------------------------------------------------------

# wget http://www.cmake.org/files/v2.8/cmake-2.8.4.tar.gz
# tar -zxvf cmake-2.8.4.tar.gz
# cd cmake-2.8.4
# ./bootstrap 
# gmake
# gmake install

# wget http://ftp.gnu.org/gnu/bison/bison-2.5.tar.gz
# tar -zxvf bison-2.5.tar.gz
# cd bison-2.5
# ./configure
# make && make install 

# yum install libncurses5-dev ncurses-devel 

---------------------------------------------------------------------------------------------------------------------------------
2'nd Install main package mysql
--------------------------------------------------------------------------------------------------------------------------------

 # wget http://www.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.10.tar.gz/from/http://cdn.mysql.com/
 # /usr/sbin/groupadd mysql
 # /usr/sbin/useradd -g mysql mysql
 # tar -zxvf mysql-5.6.10.tar.gz 
 # cd mysql-5.6.10
 # cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_EXTRA_CHARSETS:STRING=utf8,gbk -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DENABLED_LOCAL_INFILE=1 -DMYSQL_DATADIR=/usr/local/mysql/data/ -DMYSQL_USER=mysql -DMYSQL_TCP_PORT=3306 -DSYSCONFDIR=/etc -DINSTALL_SHAREDIR=share

---------------------------------------------------------------------------------------------------------------------------------
If any Error 
--------------------------------------------------------------------------------------------------------------------------------

 # rm CMakeCache.txt
 # make && make install

---------------------------------------------------------------------------------------------------------------------------------
3'rd change ownership 
--------------------------------------------------------------------------------------------------------------------------------

# chown -R root.mysql /usr/local/mysql
# chown -R mysql.mysql /usr/local/mysql/data/

 ---------------------------------------------------------------------------------------------------------------------------------
4'rd Edit bash rc & Configure Mysql
--------------------------------------------------------------------------------------------------------------------------------

 # vi ~/.bashrc
 --------------------------------------------
 export PATH=/usr/local/mysql/bin:$PATH
 --------------------------------------------

 # source ~/.bashrc
 # /usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/
 # cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
 # chmod 755 /etc/init.d/mysqld
 # cp /usr/local/mysql/my.cnf /etc/

# vi /etc/my.cnf
 -------------------------------------------
 basedir = /usr/local/mysql
 datadir = /usr/local/mysql/data
 port = 3306
 -------------------------------------------

# /etc/init.d/mysqld start
# chkconfig --level 3 mysqld on