/ansible/roles/mysql/files/mysql_install.sh
#!/bin/bash
####定义mysql数据库路径,和mysql登录密码
DBDIR='/application/mysql/data'PASSWD='bingoclo123'####判断数据目录是否存在如果不存在递归创建目录
[-d $DBDIR ] || mkdir $DBDIR -p
####安装mysql组件
yum install cmake make gcc-c++ bison-devel ncurses-devel -y
id mysql&> /dev/null####如果执行id mysql输出为0 那么就是执行正确创建mysql用户if [ $? -ne 0];then
useradd mysql-s /sbin/nologin -M
fi
####赋予数据目录权限
chown-R mysql.mysql $DBDIR
####切换到tmp目录,解压mysql,编译安装mysql到/application/mysql
cd/tmp/tar xf mysql-5.6.35.tar.gz
cd mysql-5.6.35cmake .-DCMAKE_INSTALL_PREFIX=/application/mysql-DMYSQL_DATADIR=$DBDIR-DMYSQL_UNIX_ADDR=$DBDIR/mysql.sock-DDEFAULT_CHARSET=utf8-DEXTRA_CHARSETS=all-DENABLED_LOCAL_INFILE=1-DWITH_READLINE=1-DDEFAULT_COLLATION=utf8_general_ci-DWI