脚本安装MySQL

脚本安装mysql服务并配置

1.编写mysqlInstall.sh脚本文件

#!/bin/bash
yum -y install mariadb mariadb-server python2-PyMySQL expect
cat > /etc/my.cnf.d/openstack.cnf << EOF
[mysqld]
bind-address = 192.168.100.10
default-storage-engine = innodb
innodb_file_per_table = on
max_connections = 4096
collation-server = utf8_general_ci
character-set-server = utf8
EOF
systemctl enable mariadb.service
systemctl start mariadb.service
expect -c "
spawn /usr/bin/mysql_secure_installation
expect \"Enter current password for root (enter for none) : \"
send \"\r\"
expect \"Set root password?\"
send \"y\r\"
expect \"New password: \"
send \"000000\r\"
expect \"Re-enter new password: \"
send \"000000\r\"
expect \"Remove anonymous users?\"
send \"y\r\"
expect \"Disallow root login remotely?\"
send \"n\r\"
expect \"Remove test datebase and access to it?\"
send \"y\r\"
expect \"Reload privilege tables now?\"
send \"y\r\"
expect eof
"

2.给予执行文件权限

3.执行脚本文件