MySQL5.6安装脚本之最佳实践-亲试ok-20200618

#########################################################################

# File Name: init_mysql.sh                                                                                                                  #

# Author: hui                                                                                                                                       #

# mail: unknown                                                                                                                                  #

# Created Time: Wed Jun 17 23:23:26 EDT 2020                                                                                #

#########################################################################

#!/bin/bash

export host_ip=192.168.1.155

echo '#1.取master主机ip的后三位作为master的server_id'

export host_server_id=`echo $host_ip |awk -F . '{print $4}'`

echo '1.屏蔽当前的MySQL环境'

service mysql stop

rm -f /etc/my.cnf

echo '2.检查并卸载系统中低版本的mysql'

#rpm -e mariadb-libs --nodeps

echo '3.添加用户和组'

rm -rf /home/mysql/

userdel mysql

#groupdel mysql

groupadd  mysql

useradd -g mysql mysql

echo '4.创建目录及授权'

cd /data

rm -rf *

#此为Mysql软件的安装目录

mkdir -p /data/mysql

#此为3306实例的安装目录

mkdir -p /data/my3306/data

mkdir -p /data/my3306/log/iblog

mkdir -p /data/my3306/log/binlog

mkdir -p /data/my3306/log/relaylog

mkdir -p /data/my3306/run

mkdir -p /data/my3306/tmp

chown -R mysql:mysql /data/my3306

chown -R mysql:mysql /data

chmod -R 755 /data/my3306

echo '5.上传解压软件包'

cd /home/softwares

tar zxf mysql-5.6.27-linux-glibc2.5-x86_64.tar.gz

cd mysql-5.6.27-linux-glibc2.5-x86_64

cp -R * /data/mysql/

chown -R mysql:mysql /data/

echo '6.修改配置文件my.cnf参数'

cp /scripts/my.cnf /etc/

##cp /data/mysql/support-files/my-default.cnf  /data/mysql/my.cnf

#chown -R mysql:mysql /data/my3306

#cd /data/my3306/data

#rm -rf *

#cd /data/my3306/log

#rm -f binlog/*

#rm -f iblog/*

#rm -rf relaylog/

#rm -rf slow.log

echo '7.执行MySQL安装脚本'

cd /data/mysql/

./scripts/mysql_install_db  --defaults-file=/data/mysql/my.cnf  --user=mysql --datadir=/data/my3306/data

echo '#1.取master主机ip的后三位作为master的server_id'

export host_server_id=`echo $host_ip |awk -F . '{print $4}'`

echo $host_server_id

eval sed -i 's/server_id=128/server_id=${host_server_id}/g' /etc/my.cnf

cat /etc/my.cnf |grep server_id

echo '8.修改系统环境变量'

echo "PATH=/data/mysql/bin:\$PATH:/sbin" >> /etc/profile

source /etc/profile

echo '9.自启动脚本'

#cp /data/mysql/my.cnf /etc/my.cnf

cp /data/mysql/support-files/mysql.server /etc/init.d/mysql

sed -i 's#^basedir=#basedir=/data/mysql#g' /etc/init.d/mysql

sed -i 's#^datadir=#datadir=/data/mysql/data#g' /etc/init.d/mysql

sed -i 's#^mysqld_pid_file_path=#mysqld_pid_file_path=/data/my3306/run/mysqld.pid#g' /etc/init.d/mysql

chkconfig --add mysql

/etc/init.d/mysql start

/etc/init.d/mysql stop

service mysql start

echo '10.删除默认匿名账户'

#mysql -h127.0.0.1 -uroot -P3306 -e "flush privileges;"

mysql  -uroot -P3306 <<EOF

flush privileges;

update mysql.user set authentication_string='password(123456)' where user='root';

delete from mysql.user where user='';

set old_passwords=0;

create user 'replusr'@'%' identified by '123456';

create user 'root'@'192.168.7.206' identified by '123456';

create user 'root'@'192.168.7.207' identified by '123456';

grant replication slave on *.* to 'replusr'@'%';

grant super on *.* to 'replusr'@'%';

grant all privileges on *.* to 'root'@'%' identified by '&password' with grant option;

update mysql.user set authentication_string='password(123456)' where user='root';

flush privileges;

EOF

service mysql restart

exit