1.卸载系统自带的mariadb
sudo rpm -qa | grep mariadb | xargs sudo rpm -e --nodeps
2.安装MySQL依赖
sudo rpm -ivh mysql-community-common-5.7.28-1.el7.x86_64.rpm
sudo rpm -ivh mysql-community-libs-5.7.28-1.el7.x86_64.rpm
sudo rpm -ivh mysql-community-libs-compat-5.7.28-1.el7.x86_64.rpm
3.安装mysql-client
sudo rpm -ivh mysql-community-client-5.7.28-1.el7.x86_64.rpm
4.安装mysql-server
sudo rpm -ivh mysql-community-server-5.7.28-1.el7.x86_64.rpm
注意：若出现以下错误
warning: 05_mysql-community-server-5.7.16-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
error: Failed dependencies:
libaio.so.1()(64bit) is needed by mysql-community-server-5.7.16-1.el7.x86_64
解决办法：
sudo yum -y install libaio
5.启动MySQL
sudo systemctl start mysqld
6.启动MySQL密码
sudo cat /var/log/mysqld.log | grep password
7.修改密码与修改密码策略
用刚刚查到的密码进入MySQL（如果报错，给密码加单引号）
mysql -uroot -p'password'
设置复杂密码（由于MySQL密码策略，此密码必须足够复杂）
mysql> set password=password("Qs23=zs32");
更改MySQL密码策略
mysql> set global validate_password_policy=0;
mysql> set global validate_password_length=4;
设置密码
mysql> set password=password("123456");
8.设置开发阶段远程登陆密码
CREATE USER 'root'@'%' IDENTIFIED BY 'cpc!23#@';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
9.安装错误如何进行卸载
若因为安装失败或者其他原因，MySQL需要卸载重装，可参考以下内容。
清空原有数据
通过/etc/my.cnf查看MySQL数据的存储位置
sudo cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
去往/var/lib/mysql路径需要root权限
su - root
cd /var/lib/mysql
rm -rf * （注意敲击命令的位置）
卸载MySQL相关包
查看安装过的MySQL相关包
[atguigu@hadoop102 software]$ sudo rpm -qa | grep -i -E mysql
mysql-community-libs-5.7.16-1.el7.x86_64
mysql-community-client-5.7.16-1.el7.x86_64
mysql-community-common-5.7.16-1.el7.x86_64
mysql-community-libs-compat-5.7.16-1.el7.x86_64
mysql-community-server-5.7.16-1.el7.x86_64
一键卸载命令
rpm -qa | grep -i -E mysql\|mariadb | xargs -n1 sudo rpm -e --nodeps
10.安装离线包名称
mysql-5.7.28-1.el7.x86_64.rpm-bundle.tar
下载地址:https:
