mysql-shell-安装脚本

#!/bin/bash ######################################### # Mysql intall shell # ######################################### #1.init param mysql_file=mysql-8.0.29-linux-glibc2.12-x86_64.tar.xz mysql_files=mysql-8.0.29-linux-glibc2.12-x86_64 install_path=/usr/local/mysql THIS_PATH=$(pwd) CK_COMMAND="libaio" #2.isntall libaio* command=`rpm -qa | grep "$CK_COMMAND"` CK_COMMAND="libaio" install_comm="libaio" ck_install=1; for comm in $command do if [ $(echo $comm | grep $CK_COMMAND) != "" ] then ck_install=2 break fi done echo $ck_install if [ $ck_install == 1 ] then yum install -y $install_comm fi #3.Decompress mysql MYSQL_TMP_PATH=$THIS_PATH/soft MYSQL_PK_PATH=$THIS_PATH/soft/$mysql_files if [ -d $MYSQL_PK_PATH ];then rm -rf $MYSQL_PK_PATH fi chmod 755 $MYSQL_TMP_PATH/$mysql_file tar -xvf $MYSQL_TMP_PATH/$mysql_file if [ -d $install_path ] then rm -rf $install_path fi mv $THIS_PATH/$mysql_files $install_path #4.Copy config file cp $THIS_PATH/my.cnf /etc/ #5.Create mysql group and user user=$(cat /etc/passwd |grep "mysql") if [[ -z $user ]];then groupadd mysql -g 27 useradd mysql -u 27 -c "Mysql Server" -d /var/lib/mysql -s /sbin/nologin -g mysql fi #6.Change owner to mysql chown mysql:mysql $install_path -R #7.Initialization data if [ ! -x $install_path/data/ ];then mkdir $install_path/data/ fi chmod +x $install_path/bin/mysql_ssl_rsa_setup $install_path/bin/mysqld --initialize --user=mysql --datadir=$install_path/data/ --basedir=$install_path $install_path/bin/mysql_ssl_rsa_setup --datadir=$install_path/data/ #8.Add mysql server chmod +x $install_path/support-files/mysql.server cp $install_path/support-files/mysql.server /etc/rc.d/init.d/mysql sed -i "s/conf=/&\/usr\/local\/mysql/" /etc/rc.d/init.d/mysql #9.Start mysql $install_path/support-files/mysql.server start sleep 1s $install_path/support-files/mysql.server stop sleep 1s $install_path/support-files/mysql.server start echo "------init---mysql---password--" #10.init passowrd sleep 1s $install_path/bin/mysql -uroot -pt << EOF flush privileges; ALTER USER 'root'@'localhost' IDENTIFIED BY 'root123'; CREATE USER 'wangqk'@'%' IDENTIFIED BY 'root123'; GRANT ALL PRIVILEGES ON *.* to 'wangqk'@'%'; EOF $install_path/support-files/mysql.server stop sleep 1s sed -e'/skip-grant-tables/d' /etc/my.cnf > /etc/my-tmp-2391521232443689.cnf rm -rf /etc/my.cnf mv /etc/my-tmp-2391521232443689.cnf /etc/my.cnf sleep 1s #10 init linux star server cat>>/etc/rc.d/rc.local<<EOF # mysql start $install_path/support-files/mysql.server start EOF $install_path/support-files/mysql.server start #$install_path/bin/mysql -uroot -proot123 #$install_path/bin/mysql -uroot -proot123 << EOF # source $THIS_PATH/sql/importmysqlinit.sql; #EOF echo "---------end------> 初始化：成功 账号/密码:wangqk/root123 <-end-----"