【VMware虚拟机安装mysql5.7教程】

首先到mysql官网下载MySQL：中文官网

www.mysql.com/cn

进入官网选择 下载  >MYSQL Community (GPL)Downloads > MYSQL Community Server > 

Archives  然后选择版本 ：

点击 RPM Bundle下载将下载地址链接复制：https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.36-1.el7.x86_64.rpm-bundle.tar

安装wget

yum -y install wget

新建一个目录存放

mkdir mysql

cd  mysql

下载rpm包  （安装包后缀注意是tar）

sudo wget ​​​​​​https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.36-1.el7.x86_64.rpm-bundle.tar

解压文件

tar -xvf mysql-5.7.36-1.el7.x86_64.rpm-bundle.tar

查询mariabd 包

rpm -qa | grep mariadb

卸载mariadb包

rpm -e --nodeps mariadb-libs-5.5.68-1.el7.x86_64

依赖包

yum -y install perl

yum -y install net-tools

安装Mysql

 rpm -ivh mysql-community-common-5.7.36-1.el7.x86_64.rpm

rpm -ivh mysql-community-libs-5.7.36-1.el7.x86_64.rpm

rpm -ivh mysql-community-client-5.7.36-1.el7.x86_64.rpm

rpm -ivh  mysql-community-server-5.7.36-1.el7.x86_64.rpm

启动Mysql服务

systemctl start mysqld

systemctl status mysqld

查看密码有效结果

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

2022-09-13T02:27:35.594258Z 1 [Note] A temporary password is generated for root@localhost: YDXM/DPia7N+

登录

mysql -u root -p

密码是刚查询的：YDXM/DPia7N+

设置密码策略

修改：密码最小长度

set global validate_password_length = 6;

修改：密码强度检查等级策略

set global validate_password_policy=0;

修改密码

set password for 'root'@'localhost'=password('188266');

开启mysql的root用户远程连接服务（%号即远程连接，IDENTIFIED BY后面跟的密码） 

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '188266' WITH GRANT OPTION;

最后一定要记得刷新：

flush privileges;

可以退出了

exit

到此安装完毕赶快部署项目！！