2、MySQL5.6 安装

1、卸载已安装的 MySQL 数据库

rpm -qa | grep mysql | xargs rpm -e --nodeps
rpm -qa | grep mariadb | xargs rpm -e --nodeps

---

2、下载安装包文件

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

---

3、安装mysql-community-release-el7-5.noarch.rpm包

rpm -ivh mysql-community-release-el7-5.noarch.rpm
#删除文件
rm -rf mysql-community-release-el7-5.noarch.rpm

---

4、安装MySQL

yum -y install mysql-server

---

5、启动 MySQL 服务

#设置 mysql 开机启动
systemctl enable mysqld.service
#启动 mysql
systemctl start mysqld.service

---

6、设置密码和远程主机登录

mysql -uroot -e "SET PASSWORD FOR 'root'@'%' = PASSWORD('admin');"
mysql -uroot -padmin -e "GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'admin';"
mysql -uroot -padmin -e "FLUSH PRIVILEGES;"

---

Shell 脚本

#!/bin/bash
rpm -qa | grep mysql | xargs rpm -e --nodeps
rpm -qa | grep mariadb | xargs rpm -e --nodeps
wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
rpm -ivh mysql-community-release-el7-5.noarch.rpm
rm -rf mysql-community-release-el7-5.noarch.rpm
yum -y install mysql-server
if [ $(rpm -qa | grep mysql |wc -l) -ne 0 ];
then
	systemctl enable mysqld.service
	systemctl start mysqld.service
	mysql -uroot -e "SET PASSWORD FOR 'root'@'%' = PASSWORD('admin');"
	mysql -uroot -padmin -e "GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'admin';"
	mysql -uroot -padmin -e "FLUSH PRIVILEGES;"
	echo "安装成功"
else
	echo "安装失败!"
fi