#!/bin/bash
#此脚本编译安装mysql5.7.31
#邮箱：liubinbin0215@163.com
echo "清理环境"
systemctl stop mysqld mariadb &>/dev/null
yum erase -y `rpm -qa |grep mariadb` 2>/dev/null
yum erase -y `rpm -qa |grep mysql`  2>/dev/null
rm -rvf /etc/my.cnf /var/lib/mysql
userdel -rf mysql &>/dev/nullping -w3 -c3 www.baidu.com
if [[ $? -ne 0 ]];thenecho "网络不通畅，请检查网络通畅性"exit
elseecho "网络通畅，正在进行wget软件下载"
fiwhile :
do
yum -y install ncurses ncurses-devel openssl-devel bison gcc gcc-c++ make cmake wget && wget -P /usr/local/src/ -nc https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-boost-5.7.31.tar.gz
if [[ $? -eq 0 ]];thenbreak
elseyum -y install ncurses ncurses-devel openssl-devel bison gcc gcc-c++ make cmake wget && wget -P /usr/local/src/ -nc https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-boost-5.7.31.tar.gzfi
done
tar -zxvf /usr/local/src/mysql-boost-5.7.31.tar.gz -C /usr/local/src/
cd /usr/local/src/mysql-5.7.31
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
groupadd mysql
echo "
[mysqld]
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
">/etc/my.cnfmake && make install  if [[ $? -eq 0 ]];then
useradd -r -g mysql -s /bin/nolgin mysql
cd /usr/local/mysql
mkdir /usr/local/mysql/mysql-files
chown -R mysql.mysql /usr/local/mysql
/usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data &>/root/mysql
else
echo "make && make install失败"
exit
fi
if [[ $? -eq 0 ]];then
echo "export PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile
source /etc/profile
cp  /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
chkconfig mysqld  on
echo "可以使用systemctl管理mysql"
else
exit
fi
systemctl start mysql
mysql_passwd=`cat /root/mysql |awk 'NR==7''{print $11}'`
/usr/local/mysql/bin/mysqladmin -u root -p${mysql_passwd} password LiuLiuBin@123
if [[ $? -eq 0 ]];thenecho “密码已经修改完成,密码为LiuLiuBin@123”
elseexit
fi