首先到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

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

Logo

华为开发者空间,是为全球开发者打造的专属开发空间,汇聚了华为优质开发资源及工具,致力于让每一位开发者拥有一台云主机,基于华为根生态开发、创新。

更多推荐