一键安装mysql5.6.48

安装包在/opt下
[16:19:47 root@localhost ~]#cat mysql_install.sh 
#!/bin/bash
DIR=`pwd`
NAME="mysql-5.6.48-linux-glibc2.12-x86_64"
FULL_NAME=/opt/${NAME}.tar.gz
DATA_DIR="/data/mysql"
yum install libncurses*
if [ -f ${FULL_NAME} ];then
    echo "安装文件存在"
else
    echo "安装文件不存在"
    exit 3
fi
if [ -e /usr/local/mysql ];then
    echo "MySQL已经安装"
    exit 3
else
    tar xvf ${FULL_NAME} -C /usr/local/
    ln -sv /usr/local/${NAME} /usr/local/mysql
    if id mysql;then
        echo "MySQL 用户已存在，跳过创建过程"
    else
        useradd -r -s /sbin/nologin mysql
    fi
    if id mysql;then
        chown -R mysql:mysql /usr/local/mysql/
        if [ ! -d /data/mysql ];then
            mkdir -pv /data/mysql && chown -R mysql:mysql /data
            /usr/local/mysql/scripts/mysql_install_db --user=mysql --datadir=/data/mysql --basedir=/usr/local/mysql
            cp /usr/local/${NAME}/support-files/mysql.server /etc/init.d/mysqld
            chmod a+x /etc/init.d/mysqld
            cp ${DIR}/my.cnf /etc/my.cnf
            ln -sv /usr/local/mysql/bin/mysql /usr/bin/mysql
            /etc/init.d/mysqld start
            chkconfig --add mysqld
        else
            echo "MySQL数据目录已经存在"
            exit 3
        fi
    fi 
fi    

 运行完脚本后添加环境变量

[17:13:43 root@localhost ~]#echo 'PATH=/usr/local/mysql/bin:$PATH' > /etc/profile.d/mysql.sh
[17:15:24 root@localhost ~]#. /etc/profile.d/mysql.sh 

 设置密码

[17:18:36 root@localhost ~]#/usr/local/mysql/bin/mysqladmin -u root password 'centos'

登录

[17:18:36 root@localhost ~]#mysql -uroot -pcentos