编译安装mysql5.7

安装mysql前需要清理环境，如果是新机器就不需要清理

[root@localhost ~]# yum erase mariadb mariadb-server mariadb-libs mariadb-devel -y
[root@localhost ~]# userdel -r mysql
[root@localhost ~]# rm -rf /var/lib/mysql
[root@localhost ~]# rm -rf /etc/my*

下载tar包

[root@localhost ~]# wget https://downloads.mysql.com/archives/get/p/23/file/mysql-boost-5.7.40.tar.gz

解压到/usr/local目录下

[root@localhost ~]# tar xzvf mysql-boost-5.7.40.tar.gz -C /usr/local/

创建目录

[root@localhost ~]# mkdir -p /usr/local/{data,mysql,log}

安装编译所需要的工具

[root@localhost ~]# yum -y install ncurses ncurses-devel openssl-devel bison gcc gcc-c++ make glibc automake autoconf
[root@localhost ~]# yum -y install cmake

进入到mysql的解压目录进行编译安装

编译安装时间较长，需要半个小时左右

[root@localhost ~]# cd /usr/local/mysql-5.7.40/
[root@localhost mysql-5.7.40]# cmake . -DWITH_BOOST=boost/boost_1_59_0/ -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DSYSCONFDIR=/etc -DMYSQL_DATADIR=/usr/local/mysql/data -DINSTALL_MANDIR=/usr/share/man -DMYSQL_TCP_PORT=3306 -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DDEFAULT_CHARSET=utf8 -DEXTRA_CHARSETS=all -DDEFAULT_COLLATION=utf8_general_ci -DWITH_READLINE=1 -DWITH_SSL=system -DWITH_EMBEDDED_SERVER=1 -DENABLED_LOCAL_INFILE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1
[root@mysql-server mysql-5.7.27]# make && make install

初始化

初始化之后需要记住密码方便后续登录和修改

[root@localhost mysql-5.7.40]#  cd /usr/local/mysql
[root@localhost mysql]# useradd -r mysql -M -s /bin/nologin
[root@localhost mysql]# chown -R mysql.mysql .
[root@localhost mysql]# ./bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

启动mysql服务

[root@localhost mysql]# ./bin/mysqld_safe --user=mysql &

查看mysql服务是否启动

修改密码并登录mysql

[root@localhost mysql]# /usr/local/mysql/bin/mysqladmin -uroot -p'QDyg_h-#r6&y' password 'Jake@666'
[root@localhost mysql]# /usr/local/mysql/bin/mysql -uroot -p'Jake@666'