Oracle中的mysql，使用脚本安装

1. Mysql 脚本安装

setup_mysql(){

#收索 mariadb

marlst=`rpm -qa | grep mariadb`

#循环卸载mariadb文件

for fl in $marlst

do

rpm -e --nodeps $fl

done

#下载msqpl种子

wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm

#安装mysql种子

rpm -ivh mysql-community-release-el7-5.noarch.rpm

#安装mysql

yum install mysql-server -y

#给mysql文件授权

chown -R root:root /var/lib/mysql

chown root /var/lib/mysql/

#开启mysql数据库密码和远程登录权限

mysql -uroot -e "use mysql;update user set password=password('ok') where user='root';GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFIED BY 'ok';flush privileges;"

#修改my.cnf在【mysql】下面添加character-set-server=utf-8

sed -i '/[mysqld]/a character-set-server=utf8' /etc/my.cnf

#重新启动服务器

service mysqld restart

}

#机器初始化

#@Param

# :$1 机器名

#   ：$2  机器内网静态ip

#   ：$3 机器网关ip

mac_init(){

#修改机器名

hostnamectl set-hostname $1

#修改hosts

echo '$2 $1' >> /etc/hosts

#修改静态ip地址

sed -i 's/dhcp/static/' /etc/sysconfig/network-scripts/ifcfg-ens33

echo 'IPADDR="$2"' >> /etc/sysconfig/network-scripts/ifcfg-ens33

echo 'NETMASK="255.255.255.0"' >> /etc/sysconfig/network-scripts/ifcfg-ens33

echo 'GATEWAY="$3"' >> /etc/sysconfig/network-scripts/ifcfg-ens33

echo 'DNS1="114.114.114.114"' >> /etc/sysconfig/network-scripts/ifcfg-ens33

echo 'DNS2="8.8.8.8"' >> /etc/sysconfig/network-scripts/ifcfg-ens33

#重启网络

systemctl restart network

#下载常用软件

yum install -y wget vim gcc

#修改yum国内源

cd /etc/yum.repos.d/

mv CentOS-Base.repo CentOS-Base.repo_bak

wget -O /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-7.repo

#清理缓存

yum clean all

#重新生缓存

yum makecache

#关闭防火墙

systemctl stop firewallf

systemctl disable firewallf

}