CentOS7安装MySQL5.7或MySQL5.6

（一）彻底删除MySQL的脚本

touch remove_mysql.sh
chmod 777 remove_mysql.sh 
vim remove_mysql.sh 

#!/bin/bash
service mysql stop 2>/dev/null
service mysqld stop 2>/dev/null
rpm -qa | grep -i mysql | xargs -n1 rpm -e --nodeps 2>/dev/null
rpm -qa | grep -i mariadb | xargs -n1 rpm -e --nodeps 2>/dev/null
rm -rf /var/lib/mysql
rm -rf /usr/lib64/mysql
rm -rf /etc/my.cnf
rm -rf /usr/my.cnf

sudo ./remove_mysql.sh

（二）CentOS7安装MySQL5.7

0、本文环境

安装包	本文版本	下载地址
MySQL	5.7.32	https://dev.mysql.com/downloads/mysql/
JDBC	5.1.49	https://dev.mysql.com/downloads/connector/j/

可使用命令下载

wget https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.32-1.el7.x86_64.rpm-bundle.tar
wget https://downloads.mysql.com/archives/get/p/3/file/mysql-connector-java-5.1.49.tar.gz

1、按序执行

顺序	操作	名称前中缀	备注
0	卸载	mariadb和mysql
1	安装	common
2	安装	libs-5.7
3	安装	libs-compat
4	安装	client	客户端
5	安装	server	服务端

man rpm可查看命令
-i是install，-v是verbose，-h和-v一起可以打印安装信息

tar -xf mysql-5.7.32-1.el7.x86_64.rpm-bundle.tar
rpm -qa | grep -i -E mysql\|mariadb | xargs -n1 rpm -e --nodeps
rpm -ivh mysql-community-common-5.7.32-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.32-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-compat-5.7.32-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.32-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.32-1.el7.x86_64.rpm

2、启动mysql

systemctl start mysqld

3、查看密码

cat /var/log/mysqld.log | grep password

4、使用上述密码登录

mysql -uroot -p

5、修改密码规则，然后改一个好记的密码

set global validate_password_length=5;
set global validate_password_policy=0;
set password=password("123456");

6、修改root用户的host属性（可选）

修改root用户的host属性，使root账号可被远程登陆

use mysql
select `user`,`host` from user;
update user set host='%' where user='root';
flush privileges;
select `user`,`host` from user;
quit;

默认账号的host属性都是localhost，意思是该账号只能本地使用，改成%可被远程登陆

（三）CentOS7安装MySQL5.6

亲测阿里云服务器可行

1、下载，安装

wget -v http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm
sudo yum -y update
sudo yum -y install mysql-server

2、启停

sudo systemctl start mysqld

sudo systemctl stop mysqld

3、设置密码

/usr/bin/mysql_secure_installation

4、下载并解压JDBC

wget https://downloads.mysql.com/archives/get/p/3/file/mysql-connector-java-5.1.49.tar.gz
tar -xf mysql-connector-java-5.1.49.tar.gz

下载并解压JDBC，后续按需处理

（四）附录

en	🔉	cn
compat	kəmˈpæt	n. 兼容
compatibility	kəmˌpætəˈbɪləti	n. [计] 兼容性
validate	ˈvælɪdeɪt	vt. 证实，验证；确认；使生效
privilege	ˈprɪvəlɪdʒ	n. 特权；vt. 给予…特权；特免
.cnf	config	配置文件
anonymous	əˈnɑːnɪməs	匿名的

MySQL5.7报错GPG校验不正确解决方法

https://yellow520.blog.youkuaiyun.com/article/details/122963303