Centos6.5 源码安装MySql5.6.33

卸载已经安装过的旧版本mysql

rpm-emysql
rpm-e--nodepsmysql
yumremovemysql

安装MySql

安装mysql依赖包

yum-yinstallmakegcc-c++cmakebison-develncurses-devel

下载mysql5.6.33

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

wgethttp://ftp.ntu.edu.tw/MySQL/Downloads/MySQL-5.6/mysql-5.6.33.tar.gz
tar-zxvfmysql-5.6.33.tar.gz
cdmysql-5.6.33

编译安装

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_ci

make&&makeinstall

配置mysql

chown-Rmysql:mysql/usr/local/mysql
mkdir-p/data/mysqldb
chown-Rmysql:mysql/data
mv/etc/my.cnf/etc/my.bak

初始化mysql

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

启动mysql

cpsupport-files/mysql.server/etc/init.d/mysqld
chkconfigmysqldon
servicemysqldstart

mysql环境变量配置

PATH=/usr/local/mysql/bin:$PATH
exportPATH
source/etc/profile

设置root登录口令

mysql-uroot
mysql>SETPASSWORD=PASSWORD('123456');