centos7.3 shell安装mysql5.7.28

最新推荐文章于 2024-10-02 06:14:43 发布

L白眸

最新推荐文章于 2024-10-02 06:14:43 发布

阅读量109

点赞数

分类专栏： linux 数据库文章标签： mysql 数据库 sql shell

本文链接：https://blog.csdn.net/lx_1314/article/details/120224195

版权

linux 同时被 2 个专栏收录

25 篇文章 0 订阅

订阅专栏

数据库

13 篇文章 0 订阅

订阅专栏

1.mysql源码包官网下载地址：

https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.28-1.el7.x86_64.rpm-bundle.tar

2.看具体shell如下：

#!/bin/bash
install_mysql()
{
mkdir /usr/local/mysql
tar -xvf /root/mysql-5.7.28-1.el7.x86_64.rpm-bundle.tar -C /usr/local/mysql/
cd /usr/local/mysql/
yum -y install mysql-community-*
sed -i '/^\[mysqld\]/a\log-bin=mysql-bin\nbinlog-format=ROW\nserver_id=1\nskip-grant-tables' /etc/my.cnf
systemctl enable mysqld
systemctl start mysqld
mysql -uroot -p"\n" -e "update mysql.user set authentication_string=password('$mysql_password') where user='root';"
sed -i '/^skip-grant-tables/d' /etc/my.cnf
systemctl restart mysqld

mysql --connect-expired-password -uroot -p${mysql_password} -e "alter user user() identified by '$mysql_password';"

}

mysql_ip="10.10.10.20"
mysql_password="Kz@163.com"
install_mysql