mysql-5.7.29-el7-x86-64.tar.gz 自动化安装mysql5.7.29

# # Created by Zhu Huibiao on 2022/3/28. # Mysql_installer.sh # 关于Mysql5.7.29自动化安装脚本 #!/bin/sh echo " [+] welcome to use mysql automation install ..." echo " [+] I will create a file，in /root/mysqlinstall ..." mkdir /root/mysqlinstall echo " [+] I will put the MySQL installation package in the newly created MySQL install ..." mv mysql-5.7.29-el7-x86_64.tar.gz /root/mysqlinstall/ mv my.cnf /root/mysqlinstall/ cd /root/mysqlinstall echo " [+] create mysql user and group runing ..." groupadd mysql useradd -r -g mysql mysql echo " [+] create mysql user successful ..." echo " [+] I will tar mysql ..." echo " [+] unzip will be slow. Please wait patiently ..." tar -zxf mysql-5.7.29-el7-x86_64.tar.gz sleep 5 echo " [+] Unzip and I will create the directory and data storage path where MySQL is installed" mv mysql-5.7.29-el7-x86_64 /usr/local/mysql mkdir /usr/local/mysql/data chown -R mysql:mysql /usr/local/mysql/ mv /root/mysqlinstall/my.cnf /etc/my.cnf echo " [+] start init mysql" echo " [+] Start installing MySQL ..." /usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/ echo " [++++] Install success !!! ..." echo " [++++] [Note] A temporary password is generated for root@localhost: xxxxxxx" echo " [++++] 上面摘抄自日志输出内容其中标注“xxxxx”的位置将是你的初识密码，请复制保存，登录数据库请及时修改root的密码" echo " [++++] mysql5.7.29版本修改密码的命令： " echo " [++++] alter user 'root'@'localhost' identified by 'mysqlp@sswd';" echo " [++++] FLUSH PRIVILEGES;" echo " [++++] 远程登录授权命令" echo " [++++] GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;" echo " [++++] FLUSH PRIVILEGES;" cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld sleep 5 /etc/init.d/mysqld start echo " [++++] 启动数据库成功" sleep 3 /etc/init.d/mysqld restart echo " [++++] 重启数据库成功++++successful" echo " [++++] 请稍等，正在配置环境变量####################" sleep 5 echo "export PATH=\$PATH:/usr/local/mysql/bin" >> ~/.bashrc source ~/.bashrc echo " [++++] 您已经完成MySQL的全部安装工作，请及时设置root账号密码，同时给与远程登录授权，进行客户端连接数据库"