-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathinstall_mysql.sh
47 lines (35 loc) · 1.3 KB
/
install_mysql.sh
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
#!/bin/bash
#判断是否安装了MySQL
result=`rpm -qa | grep -i mysql`
if [ "$result" != "" ]; then
echo "Mysql 已安装,即将移除..."
yum -y remove mysql-community*
echo "Mysql 移除成功"
fi
#download rpm package
#下载MySQL源安装包
curl -OL https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
yum -y localinstall mysql57-community-release-el7-11.noarch.rpm
result=`yum repolist enabled | grep "mysql.*-community.*"`
if [ "$result" = "" ]; then
echo "MySQL源安装失败,本次安装取消"
exit 0
else
echo "MySQL源已启用"
fi
#echo "即将下载安装包..."
#curl -OL https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-community-server-5.7.20-1.el7.x86_64.rpm
#echo "安装包下载完毕"
#yum -y localinstall mysql-community-server-5.7.20-1.el7.x86_64.rpm
yum -y install mysql-community-server
#开机启动
systemctl enable mysqld
systemctl daemon-reload
#启动MySQL服务
service mysqld start
echo "密码:`cat /var/log/mysqld.log | grep -oE 'localhost: (.*?)' | awk -F ':' '{print($2)}'`,MySQL服务状态:`mysqld status`"
#mysql 添加新用户,设置密码策略,root默认不支持远程连接
#mysql -u root -password
#set global validate_password_policy=0;
#set global validate_password_length=1;
#create user 'admin'@'%' identified by '123456a';