RedHat7安装mysql5.7数据库

- 日理万妓 2021-12-01 13:10 349阅读 0赞

原文链接：[https://www.cnblogs.com/wangbiubiu/p/9729515.html][https_www.cnblogs.com_wangbiubiu_p_9729515.html]

1.首先打开SSH登录到终端：`cd root`进入root目录  
进入到root目录下，运行`mkdir mysql57` 命令创建mysql57文件夹，cd mysql57 进入到mysql57文件夹下  
![在这里插入图片描述][20190720155119907.png]  
2.安装MySQL官方的Yum Repository：`wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm` *这里我输入命令失败，然后我复制网址下载之后将文件手动添加到mysql57文件夹下，效果是一样的。*  
3.下载rpm包：`yum -y install mysql57-community-release-el7-10.noarch.rpm`  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDQ3J1bm5lcg_size_16_color_FFFFFF_t_70]

4.安装MySQL服务：`yum -y install mysql-community-server`![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDQ3J1bm5lcg_size_16_color_FFFFFF_t_70 1]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDQ3J1bm5lcg_size_16_color_FFFFFF_t_70 2]  
4、启动mysql服务：`systemctl start mysqld.service`  
![在这里插入图片描述][20190720160159908.png]

5、查看mysql运行状态：`systemctl status mysqld.service`  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDQ3J1bm5lcg_size_16_color_FFFFFF_t_70 3]

6、重新启动服务：`service mysqld restart`  
![在这里插入图片描述][20190720160415549.png]

7、通过下面的命令查看初始密码，冒号后面的字符就是密码：grep ‘temporary password’ /var/log/mysqld.log  
![在这里插入图片描述][20190720160529804.png]  
8、登录root用户：mysql -u root -p  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDQ3J1bm5lcg_size_16_color_FFFFFF_t_70 4]  
9、validate\_password\_policy代表密码策略，默认是1：符合长度，且必须含有数字，小写或大写字母，特殊字符。设置为0判断密码的标准就基于密码的长度了。一定要先修改两个参数再修改密码：set global validate\_password\_policy=0;  
![在这里插入图片描述][20190720160746463.png]

10、validate\_password\_length代表密码长度，最小值为4：`set global validate_password_length=4;`  
![在这里插入图片描述][20190720160813345.png]

11、修改密码为root，之后就可以使用该密码登录了：ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘root’;  
![在这里插入图片描述][20190720160954339.png]

[https_www.cnblogs.com_wangbiubiu_p_9729515.html]: https://www.cnblogs.com/wangbiubiu/p/9729515.html
[20190720155119907.png]: /images/20211201/ffff28700ef64996b29dc564155c2ed3.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDQ3J1bm5lcg_size_16_color_FFFFFF_t_70]: /images/20211201/b84ba5c58323488a9e6a8e9e3660e85c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDQ3J1bm5lcg_size_16_color_FFFFFF_t_70 1]: /images/20211201/694b885c63734432b4e18931d8f7f03b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDQ3J1bm5lcg_size_16_color_FFFFFF_t_70 2]: /images/20211201/d75de82d610d4d259a2b57dc25f41e7d.png
[20190720160159908.png]: /images/20211201/c6e6e1cbd2e840b9a70239378426db41.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDQ3J1bm5lcg_size_16_color_FFFFFF_t_70 3]: /images/20211201/f3752bd2c229404cbc306a960334c105.png
[20190720160415549.png]: /images/20211201/91b1dcbb9e4c47a88f889551422bd832.png
[20190720160529804.png]: /images/20211201/133f0de7642a40069a0b4be67db64cc1.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NDQ3J1bm5lcg_size_16_color_FFFFFF_t_70 4]: /images/20211201/3cd6b1fc28164941a88b189ae615895c.png
[20190720160746463.png]: /images/20211201/f6711560fcd1456d92f0c7da05bff167.png
[20190720160813345.png]: /images/20211201/4e4ccfcea14c4a20b2833f6a25f91ac5.png
[20190720160954339.png]: /images/20211201/8931df30822d4ca29dfee4a115470e40.png