mysql 5.7 centos7 编译安装 记录

安装必要的依赖

yum -y install gcc gcc-c++ ncurses ncurses-devel cmake

创建目录并下载

mkdir -p /data/soft

cd /data/soft/

wget http://cdn.mysql.com//Downloads/MySQL-5.7/mysql-boost-5.7.13.tar.gz

wget http://downloads.sourceforge.Net/project/boost/boost/1.59.0/boost_1_59_0.tar.gz

创建mysql用户

groupadd mysql
useradd -r -g mysql mysql 

解压缩

ls -lh

tar xzf boost_1_59_0.tar.gz
tar xzf mysql-5.7.9.tar.gz

mv boost_1_59_0 /usr/local/boost

编译

cd mysql-5.7.9/
mkdir /usr/local/mysql
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data -DDEFAULT_CHARSET=utf8 -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 -DDOWNLOAD_BOOST=1 -DWITH_BOOST=/usr/local/boost
/usr/local/mysql/bin/mysqld  --initialize --user=mysql --basedir=/usr/local/mysql 


 /usr/local/mysql/bin/mysql -uroot -p
 ps -ef|grep mysql
 /usr/local/mysql/bin/mysqld stop

初始化库
/usr/local/mysql/bin/mysqld  --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

mv /etc/my.cnf /etc/my.cnf.bak

配置文件

 cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf
/usr/local/mysql/bin/mysqld_safe 
ln -s /usr/local/mysql/lib/libmysqlclient.so.20 /usr/lib/libmysqlclient.so.20
mysql -uroot -p
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
 chmod 755 /etc/init.d/mysqld   
 chkconfig --add mysqld  
 chkconfig --level 345 mysqld on  
 chkconfig --list mysqld
 service mysqld restart
 chown -R mysql.mysql /usr/local/mysql
 mysql -u root -p
 ln -s /usr/local/mysql/bin/mysql /usr/bin
 mysql -u root -p
 service mysqld start
 mysql -u root -p