centos修改mysql密码_linux rpm安装Mysql的shell脚本包括修改密码，建和导库

echo "----------------------------------YUM insall packing -----------------------------"

yum -y install gcc gcc-c++ pcre pcre-devel zlib zlib-devel openssl openssl-devel pam pam-devel libacl-devel openldap-devel libcap libcap-devel tcp_wrappers tcp_wrappers-devel tcp_wrappers_devel policycoreutils-python vim lrzsz ntpdate sysstat net-tools unzip zip bzip2 wget redhat_lsb

echo "-----------------------------------set config ---------------------------------"

cd /javadev/src

echo "-----------------------------------RPM file ---------------------------------"

tar -xvf mysql-5.7.28-1.el7.x86_64.rpm-bundle.tar

echo "-----------------------------------check mysql ---------------------------------"

rpm -e `rpm -qa |grep mysql` --nodeps

rpm -e `rpm -qa |grep mariadb` --nodeps

rm -rf /etc/my.cnf

rm -rf /var/lib/mysql

rm -rf /var/log/mysql.log

rm -rf /var/log/mysqld.log

rm -rf mysql-community-test-5.7.28-1.el7.x86_64.rpm

rm -rf mysql-community-embedded-5.7.28-1.el7.x86_64.rpm

rm -rf mysql-community-embedded-compat-5.7.28-1.el7.x86_64.rpm

rm -rf mysql-community-embedded-devel-5.7.28-1.el7.x86_64.rpm

echo "-----------------------------------RPM install ---------------------------------"

yum -y install mysql-*.rpm

echo "-----------------------------------mysql initialize ---------------------------------"

service mysqld start

sleep 10s

netstat -ntlp

temppasswd=$(grep 'temporary password' /var/log/mysqld.log | awk '{print $NF}')

echo "----------登录MySQL数据库设置密码并授权登录用户,新建和导入数据库--------"

mysql -uroot -p${temppasswd} --connect-expired-password <

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('ABCabc*123456#');

flush privileges;

use mysql;

grant all on *.* to 'root'@'localhost' identified by 'ABCabc*123456#';

grant all on *.* to 'root'@'127.0.0.1' identified by 'ABCabc*123456#';

grant all on *.* to 'javadev'@'localhost' identified by 'ABCabc*123456';

grant all on *.* to 'javadev'@'127.0.0.1' identified by 'ABCabc*123456';

grant all on *.* to 'javadev'@'192.168.0.%' identified by 'ABCabc*123456';

CREATE DATABASE db1 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE DATABASE db2 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

use db1;

source /javadev/temp/db1.sql;

use db2;

source /javadev/temp/db2.sql;

flush privileges;

EOF

echo "---------------------firewall config-----------------------------"

systemctl restart firewalld

systemctl enable firewalld

firewall-cmd --permanent --zone=public --add-port=3306/tcp

firewall-cmd --permanent --zone=public --add-port=3336/tcp

firewall-cmd --reload

sed -i 's/SELINUX=enforcing/SELINUX=Permissive/g' /etc/selinux/config

sed -i 's/SELINUX=enforcing/SELINUX=Permissive/g' /etc/sysconfig/selinux

setenforce 0

getenforce

echo "-----------------------------------mysql config file ---------------------------------"

service mysqld stop

sleep 10s

cp -rf /javadev/temp/my.cnf /etc/

service mysqld start

netstat -ntlp

echo "-----------------------------mysql install OK Ok OK----------------------------------"