centos7 MySQL5.7 源码安装

1、下载
https://downloads.mysql.com/archives/community/
2、安装开发工具和开发包
yum install make gcc gcc-c++ cmake bison-devel ncurses-devel -y
yum install libaio libaio-devel openssl-devel -y
yum install perl-Data-Dumper -y
yum install net-tools -y
3、压缩包解压
[root@localhost local]# tar xvf mysql-boost-5.7.14.tar.gz -C /usr/local/
4、纯净版需增加mysql用户及组
groupadd -r -g 306 mysql
useradd -g 306 -r -u 306 mysql
5、为数据库文件添加软链接
[root@localhost local]# ln -sv mysql-5.7.14 mysql
6、通过chown改变文件的拥有者和组
[root@localhost local]# chown -R mysql.mysql mysql/*
7、配置
如果未安装cmake编译器，先安装cmake
#下载
[root@localhost local]# wget https://cmake.org/files/v3.10/cmake-3.10.2.tar.gz
#解压
[root@localhost local]# tar -zxvf cmake-3.10.2.tar.gz
#切换目录
[root@localhost local]# cd ./cmake-3.10.2/
#编译模板预置
[root@localhost cmake-3.10.2]# ./bootstrap --prefix=/usr/local/cmake
#如果模板预置报错，安装C++依赖
[root@localhost cmake-3.10.2]# yum install gcc-c++ -y

cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql
-DMYSQL_DATADIR=/usr/local/mysql/data -DSYSCONFDIR=/etc
-DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1
-DWITH_READLINE=1 -DWITH_SSL=system -DWITH_ZLIB=system -DWITH_LIBWRAP=0
-DMYSQL_TCP_PORT=3306 -DMYSQL_UNIX_ADDR=/tmp/mysql.sock
-DENABLED_LOCAL_INFILE=1 -DEXTRA_CHARSETS=all
-DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci
–DWITH_BOOST=/usr/local/mysql-5.7.14/boost/boost_1_59_0
8、初始化
#初始化mysql /usr/local/mysql/bin/mysqld --initialize --user=mysql -datadir=/usr/local/mysql/data --basedir=/usr/local/mysql/
9、配置mysql主配置文件
[root@localhost local]# cd /usr/local/mysql/
[root@localhost mysql]# \cp support-files/my-default.cnf /etc/my.cnf
[root@localhost mysql]# vim /etc/my.cnf
#在配置文件中加入
datadir = /usr/local/mysql/data

10、为mysql提供sysv服务脚本
[root@localhost mysql]# cp support-files/mysql.server /etc/rc.d/init.d/mysqld
[root@localhost mysql]# chmod +x /etc/rc.d/init.d/mysqld
11、将mysql设置为系统服务,并开机自启
[root@localhost mysql]# chkconfig --add mysqld
[root@localhost mysql]# chkconfig mysqld on
12、启动服务
[root@localhost mysql]# systemctl start mysql
[root@localhost mysql]# systemctl status mysql
13、设置环境变量
[root@localhost mysql]# cd /etc/profile.d/
[root@localhost profile.d]# vim mysql.sh
将下面的语句加入配置文件
export PATH=$PATH:/usr/local/mysql/bin
14、刷新配置文件，使配置生效
[root@localhost profile.d]# source /etc/profile
15、登录MySQL后，修改密码即可
ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘root’;