Linux8yum安装mysql5.7版本流程

淩亂°似流年 2024-02-22 02:53 38阅读 0赞

### Linux8yum安装mysql ###

[Linux8yum安装报错解决][Linux8yum]

### yum安装流程 ###

#### 首先下载mysql的yum配置 ####

wget http://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm

#### 安装mysql源 ####

yum -y install mysql57-community-release-el7-11.noarch.rpm

#### 安装mysql ####

yum -y install mysql-server  --nogpgcheck --nogpgcheck

![7e6c3760d60146b597043ba43736f11c.png][]

启动mysql

systemctl start mysqld.service (注：启动)
    systemctl status mysql.service （注：查看状态）
    systemctl stop mysql.service （注：停止状态）

![8b50158e2e834fd599212a3fb8a9c953.png][]

#### 查看mysql临时密码 ####

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

[root@localhost mysql]# cat /var/log/mysqld.log| grep password
    2023-10-13T02:13:40.394646Z 1 [Note] A temporary password is generated for root@localhost: p3gihsXmnt?8

#### 进入mysql输入临时密码 ####

mysql -uroot -p

#### 进入后修改mysql密码 ####

ALTER USER USER() IDENTIFIED BY '123456Admin@123';

#### 给其他机器授权能够访问mysql服务 ####

grant all privileges on *.* to 'root'@'%' identified by '123456Admin@123' with grant option;
    
    flush privileges;（注：刷新配置）

![b1c38edfe2464cfa9fbf7b38d634d355.png][]

#### 修改密码策略 ####

set global validate_password_policy=0;
    set global validate_password_length=1;
    
    flush privileges;

#### 修改root用户的密码为root ####

alter user 'root'@'localhost' identified by 'root';

Query OK, 0 rows affected (0.00 sec)

#### 修改localhost以外，远程连接用户的密码为root ####

grant all privileges on *.* to 'root'@'%' identified by 'root' with grant option;

Query OK, 0 rows affected, 1 warning (0.00 sec)

完结❀

[Linux8yum]: https://blog.csdn.net/qq_55629923/article/details/133696895?spm=1001.2014.3001.5501
[7e6c3760d60146b597043ba43736f11c.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/22/b3c20da6b24b49b89b4e4d8d0bdffb15.png
[8b50158e2e834fd599212a3fb8a9c953.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/22/43cc7044a8e6469a81a1d9fbd29399ec.png
[b1c38edfe2464cfa9fbf7b38d634d355.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/22/6fc1171c4a14465d84a3d500dbb3147b.png