Compiling and installing mysql5.6

compiling and installing mysql5.6

Mysqlwget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.33.tar.gz

TAR-ZXVF mysql-5.6.33.tar.gz

download compiler tool   wget http://www.cmake.org/files/v2.8/cmake-2.8.5.tar.gz

TAR-ZXVF cmake-2.8.5.tar.gz

cd cmake-2.8.5

Install the compilation tool   ./bootstrap--prefix=/usr/local/cmake

sudo gmake && sudo gmake install

ln-s/usr/local/cmake/bin/cmake/usr/bin

download boost library   wget Http://downloads.sourceforge.net/project/boost/boost/1.59.0/boost_ 1_59_0.tar.gz

TAR-ZXVF boost_1_59_0.tar.gz

mkdir/usr/local/boost

mv boost_1_59_0/*/usr/local/boost

sudo groupadd MySQL

sudo useradd-g mysql mysql

cd mysql-5.6.33

install necessary tools   yum-y install ncurses-devel

compile and install mysql  cmake-dcmake_install_prefix=/usr/local/mysql-dmysql_datadir=/usr/local /mysql/data-dextra_charsets=all-ddefault_charset=utf8-ddefault_collation=utf8_general_ci-ddefault_collation= Utf8_general_ci-dmysql_tcp_port=3306-dmysql_user=mysql-dwith_myisam_storage_engine=1-dwith_innobase_storage_ Engine=1-dwith_archive_storage_engine=1-dwith_blackhole_storage_engine=1-dwith_memory_storage_engine=1-dwith_ Boost=/usr/local/boost

compilation error requires deleting RM CMakeCache.txt recompile

sudo make && sudo make install  mysql installation completed  
cd/usr/local/mysql/scripts/

sudo ./mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

Modify Configuration sudo vi/usr/local/mysql/my.conf

basedir =/usr/local/mysqldatadir =/usr/local/mysql/data
Socket =/tmp/ Mysql.sock

cd/usr/local/mysql/support-files

sudo CP mysql.server/etc/rc.d/init.d/mysqld

chkconfig--add mysqld

Start completesudo service mysqld start

Compiling and installing mysql5.6