Centos6.5 Source Installation MySql5.6.33

Uninstall older versions of MySQL that have already been installed

RPM-E mysqlrpm-e--nodeps mysqlyum remove MySQL

Install MySQL

Install MySQL Dependency package

Yum-y install make gcc-c++ cmake bison-devel ncurses-devel

Download mysql5.6.33

URL http://ftp.ntu.edu.tw/MySQL/Downloads/MySQL-5.6/

wget HTTP://FTP.NTU.EDU.TW/MYSQL/DOWNLOADS/MYSQL-5.6/MYSQL-5.6.33.TAR.GZTAR-ZXVF MYSQL-5.6.33.TAR.GZCD mysql-5.6.33

Compiling the installation

Cmake-dcmake_install_prefix=/usr/local/mysql-dmysql_datadir=/data/mysqldb-dsysconfdir=/etc-dwith_myisam_ Storage_engine=1-dwith_innobase_storage_engine=1-dwith_memory_storage_engine=1-dwith_readline=1-dmysql_unix_ Addr=/var/lib/mysql/mysql.sock-dmysql_tcp_port=3306-denabled_local_infile=1-dwith_partition_storage_engine=1- Dextra_charsets=all-ddefault_charset=utf8-ddefault_collation=utf8_general_cimake && make Install

Configure MySQL

Chown-r mysql:mysql/usr/local/mysqlmkdir-p/data/mysqldbchown-r Mysql:mysql/datamv/etc/my.cnf/etc/my.bak

Initialize MySQL

cd/usr/local/mysqlscripts/mysql_install_db--basedir=/usr/local/mysql--datadir=/data/mysqldb--user=mysql

Start MySQL

CP support-files/mysql.server/etc/init.d/mysqldchkconfig MySQL onservice mysql start

MySQL environment variable configuration

Path=/usr/local/mysql/bin: $PATHexport pathsource/etc/profile

Set the root login password

Mysql-uroot mysql> SET PASSWORD = PASSWORD (' 123456 ');

Centos6.5 Source Installation MySql5.6.33