CentOS7 安装mysql（YUM源方式）

妖狐艹你老母 2024-03-31 13:58 75阅读 0赞

**目录**

1.安装wget

2.下载mysql源安装包

3.安装mysql源

4.检查mysql源是否安装成功

5.修改yum源

6.安装MySQL

7.启动MySQL服务并设置开机启动

8.修改root本地登录密码

8.1 查看mysql密码

8.2 连接mysql

8.3 修改密码

8.3.1 修改validate\_password\_policy参数的值

8.3.2 设置validate\_password\_length密码长度

8.3.4 重新设置密码

9.设置远程登录

10.测试远程登录

--------------------

## 1.安装wget ##

> \[root@localhost ~\]\# yum install -y wget

![8c4e17fd60a940909783bb484f345476.png][]

我已经安装，没安装的话就安装一下

## 2.**下载mysql源安装包** ##

> \[root@localhost ~\]\# wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm

![777be233941044a6a29d8ef1da58a753.png][]

## 3.**安装mysql源** ##

> \[root@localhost ~\]\# yum localinstall mysql57-community-release-el7-8.noarch.rpm

![8da1544d38f54fcaa2905c4ba3d2158c.png][]

## **4.检查mysql源是否安装成功** ##

> \[root@localhost ~\]\# yum repolist enabled | grep "mysql.\*-community.\*"

![a66ed3dd61da416792cc79f07eae2cee.png][]

## **5.修改yum源** ##

**（可跳过）**

> \[root@localhost ~\]\# vim /etc/yum.repos.d/mysql-community.repo

备注：enabled=1表示即将要安装的mysql版本，这个文件也可以不修改，默认安装mysql最高版本

![75ebd2c43c704e90be1e0b83b94e5c3d.png][]

> TIP：
> 
> 安装途中如果出现下图的情况则需要先把密钥匙更新一下
> 
> ![59a981c7cfb24b69b5a1bb9b3009e754.png][]
> 
> 更新命令：https://repo.mysql.com/RPM-GPG-KEY-mysql-2022

![bd164c7ea818438aa63869dc8ea44b31.png][]

## 6.安装MySQL ##

> \[root@localhost ~\]\# yum install mysql-community-server

![988e4c3716894885bcb8b8778c3dc43c.png][]

## **7.启动MySQL服务并设置开机启动** ##

> \[root@localhost ~\]\# systemctl start mysqld  
> \[root@localhost ~\]\# systemctl enable mysqld  
> \[root@localhost ~\]\# systemctl daemon-reload

![e46400d13f304107a582a32f7673ea7d.png][]

此步骤没有反馈

## **8.修改root本地登录密码** ##

### 8.1 查看mysql密码 ###

> \[root@localhost ~\]\# grep 'temporary password' /var/log/mysqld.log

![9faf0c86c02b486ead63f2ffca90f105.png][]

### 8.2 连接mysql ###

输入上面的密码建议直接Ctrl+c/Ctrl+v

![28f36b563b434c428f092e723fa16d88.png][]

### 8.3 修改密码 ###

**（注意：后面的分号一定要跟上）**

> mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';
> 
> 或者：
> 
> mysql> set password for 'root'@'localhost'=password('MyNewPass4!');

![19afc97945f34f1d8dd5b9246133a5eb.png][]

**报错：Your password does not satisfy the current policy requirements**

**这时就要设置validate\_password\_policy和validate\_password\_length的值**

#### 8.3.1 修改validate\_password\_policy参数的值 ####

（密码等级设为0）

> mysql> set global validate\_password\_policy=0;

![8819b27832814758a8f3ee8d6ec44d34.png][]

#### 8.3.2 设置validate\_password\_length密码长度 ####

（参数默认为8，把他修改为4）

> mysql> set global validate\_password\_length=4;

![c2b2c050a7ed434cb8e69c2be9689a92.png][]

#### 8.3.4 重新设置密码 ####

上面修改密码的两种方法

![f5b89fdf2ffb444eb938db668301b853.png][]

## 9.设置远程登录 ##

> mysql> GRANT ALL PRIVILEGES ON \*.\* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

![e67bb8eb1d094effa376957903356201.png][]

## 10.测试远程登录 ##

在DataGrip上面测试远程登录情况，出现下面界面则为设置成功

![8e1b3bb19e4e42939dff28fddf6491a7.png][]

[8c4e17fd60a940909783bb484f345476.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/5cbbf89058564853aad4990d752682a2.png
[777be233941044a6a29d8ef1da58a753.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/807ac6742849480e9f8560fdce771b6e.png
[8da1544d38f54fcaa2905c4ba3d2158c.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/f9d1fa35209648aaacdc1ed8e315b39a.png
[a66ed3dd61da416792cc79f07eae2cee.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/a279d0f19441465fb9aeaa64efdb4d4d.png
[75ebd2c43c704e90be1e0b83b94e5c3d.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/6c971438d91b4123b5a5f7ac2ad26994.png
[59a981c7cfb24b69b5a1bb9b3009e754.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/cbc5f4652a61462b8e767c8c1f070734.png
[bd164c7ea818438aa63869dc8ea44b31.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/e57791fd1b9444ffba50ece13d985031.png
[988e4c3716894885bcb8b8778c3dc43c.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/2f1fdf252b734ef8b840aa838fc95a43.png
[e46400d13f304107a582a32f7673ea7d.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/79d94b34ff6f4b7e8e103c402f52cde7.png
[9faf0c86c02b486ead63f2ffca90f105.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/fbf929fc357543ea835ceff1ab1812c0.png
[28f36b563b434c428f092e723fa16d88.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/048f65454aed41688896a9d97a6180aa.png
[19afc97945f34f1d8dd5b9246133a5eb.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/0bebefd48518486ebc613d96b948c716.png
[8819b27832814758a8f3ee8d6ec44d34.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/1dcf681f9ca3464092f267cb0f6662b9.png
[c2b2c050a7ed434cb8e69c2be9689a92.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/641e0d7552bd42f6a1c5ec130bb01fc1.png
[f5b89fdf2ffb444eb938db668301b853.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/67d4ed5959934fc5be0233562c1096bc.png
[e67bb8eb1d094effa376957903356201.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/18856a36bb0e42bcb4772d5483ded7ac.png
[8e1b3bb19e4e42939dff28fddf6491a7.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/dc762ed7b3f54ce98b33703919abd76b.png