CentOS环境搭建 - 在CentOS7.5中安装Mysql8.0

曾经终败给现在 2022-04-22 06:02 253阅读 0赞

下载地址：[https://pan.baidu.com/s/1gTugDhCeaQdf6LQ0EjTsUw][https_pan.baidu.com_s_1gTugDhCeaQdf6LQ0EjTsUw]  
提取码：1kdi

用到的工具和软件：  
   
    PUTTY.EXE

1、在上一篇《[VMware Workstation 15 Pro 建立CetnOS7.5虚拟机][VMware Workstation 15 Pro _CetnOS7.5]》中，登录进入虚拟机，新建终端，输入ifconfig查询出本机IP。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tpbmd5dW1hbw_size_16_color_FFFFFF_t_70][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tpbmd5dW1hbw_size_16_color_FFFFFF_t_70 1][]

2、打开PUTTY.EXE,在Session中输入刚查询到的IP地址，并给本会话设置一个名称“CentOS MySql Server”，点击"Save"。然后“Open”。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tpbmd5dW1hbw_size_16_color_FFFFFF_t_70 2][]  
3、用root用户登录

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tpbmd5dW1hbw_size_16_color_FFFFFF_t_70 3][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tpbmd5dW1hbw_size_16_color_FFFFFF_t_70 4][]  
3、检查centos系统

3.1检查cetos版本  
cat /etc/centos-release

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tpbmd5dW1hbw_size_16_color_FFFFFF_t_70 5][]

3.2检查centos7中自带的mariadb  
rpm -qa|grep mariadb

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tpbmd5dW1hbw_size_16_color_FFFFFF_t_70 6][]

3.3删除centos7中自带的mariadb  
rpm -e --nodeps 文件名 //卸载mariadb,文件名为上述命令查询出来的文件  
rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86\_64

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tpbmd5dW1hbw_size_16_color_FFFFFF_t_70 7][]

4.安装mysql8.0  
4.1 yum仓库下载MySQL：sudo yum localinstall https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tpbmd5dW1hbw_size_16_color_FFFFFF_t_70 8][]

4.2 yum安装MySQL：sudo yum install mysql-community-server

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tpbmd5dW1hbw_size_16_color_FFFFFF_t_70 9][]

4.3启动MySQL服务：sudo service mysqld start

![20181108163503432.png][]

4.4检查MySQL服务状态：sudo service mysqld status

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tpbmd5dW1hbw_size_16_color_FFFFFF_t_70 10][]

4.5查看初始密码：sudo grep 'temporary password' /var/log/mysqld.log

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tpbmd5dW1hbw_size_16_color_FFFFFF_t_70 11][]

4.6本地MySQL客户端登录：mysql -u root -p  
这里输入的密码为上一步查询出的密码.O?juKNj&6+K

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tpbmd5dW1hbw_size_16_color_FFFFFF_t_70 12][]

4.7修改root登录密码，密码不能设置简单，比如设置为：123456，会报错，提示你密码不符合要求。  
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tpbmd5dW1hbw_size_16_color_FFFFFF_t_70 13][]

此处我们按照MySql8的密钥要求来进行设置，比如设置为：Abcd@1234  
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Abcd@1234';

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tpbmd5dW1hbw_size_16_color_FFFFFF_t_70 14][]

查看密码策略：  
show variables like 'validate\_password%';

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tpbmd5dW1hbw_size_16_color_FFFFFF_t_70 15][]

validate\_password.length    8                密码最小长度为8  
validate\_password.policy     MEDIUM   为长度约束加上大小写字母、数字、特殊字符的要求。(必须至少包含一个大写字母、一个小写字母、一个特殊符号、一个数字，至少 8 个字符)

4.8设置密码永不过期：alter user 'root'@'localhost' identified by '你的密码' password expire never;  
alter user 'root'@'localhost' identified by 'Abcd@1234' password expire never;

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tpbmd5dW1hbw_size_16_color_FFFFFF_t_70 16][]

2.9刷新  
flush privileges;  
![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tpbmd5dW1hbw_size_16_color_FFFFFF_t_70 17][]

[https_pan.baidu.com_s_1gTugDhCeaQdf6LQ0EjTsUw]: https://pan.baidu.com/s/1gTugDhCeaQdf6LQ0EjTsUw
[VMware Workstation 15 Pro _CetnOS7.5]: https://blog.csdn.net/kingyumao/article/details/83655939
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tpbmd5dW1hbw_size_16_color_FFFFFF_t_70]: /images/20220422/70d68a21961c43c1b24763c3ceecb00d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tpbmd5dW1hbw_size_16_color_FFFFFF_t_70 1]: /images/20220422/7191767eb4f8494198166f68294d1bd7.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tpbmd5dW1hbw_size_16_color_FFFFFF_t_70 2]: /images/20220422/b0a11d708b8644e1b8dbd9e9c48d8131.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tpbmd5dW1hbw_size_16_color_FFFFFF_t_70 3]: /images/20220422/f88f591f9959454193f5fe2f1d518326.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tpbmd5dW1hbw_size_16_color_FFFFFF_t_70 4]: /images/20220422/093c29af51bf41bb90b5218dadfe4d93.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tpbmd5dW1hbw_size_16_color_FFFFFF_t_70 5]: /images/20220422/62dfa424eb434acf87b2e3ccfca7db85.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tpbmd5dW1hbw_size_16_color_FFFFFF_t_70 6]: /images/20220422/b94fd1772297492f95ef2ccf03841896.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tpbmd5dW1hbw_size_16_color_FFFFFF_t_70 7]: /images/20220422/4baf1d04c75a4b8ebd305ae1a0f2d3af.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tpbmd5dW1hbw_size_16_color_FFFFFF_t_70 8]: /images/20220422/8f35e07a336a4bf9b755823fbd928e6b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tpbmd5dW1hbw_size_16_color_FFFFFF_t_70 9]: /images/20220422/3c8a2c57acfd468195b24bd778442eb3.png
[20181108163503432.png]: /images/20220422/72d6c514c140452a93461d6af4941258.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tpbmd5dW1hbw_size_16_color_FFFFFF_t_70 10]: /images/20220422/7ad3031f93824d81844972ac8fd96f83.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tpbmd5dW1hbw_size_16_color_FFFFFF_t_70 11]: /images/20220422/9fdf93d1393c468c9ab0e9c190f752cd.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tpbmd5dW1hbw_size_16_color_FFFFFF_t_70 12]: /images/20220422/ae1d2ca0979f422c8f6bd64b3411ccd0.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tpbmd5dW1hbw_size_16_color_FFFFFF_t_70 13]: /images/20220422/05b705fcc6794a09aa188089343ee050.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tpbmd5dW1hbw_size_16_color_FFFFFF_t_70 14]: /images/20220422/ba659fa4f63f407392e85ba1b0727397.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tpbmd5dW1hbw_size_16_color_FFFFFF_t_70 15]: /images/20220422/6aa96653f3044c7494a8488deec17a19.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tpbmd5dW1hbw_size_16_color_FFFFFF_t_70 16]: /images/20220422/447eb71ad6f148b0b61f8848eb1778ff.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2tpbmd5dW1hbw_size_16_color_FFFFFF_t_70 17]: /images/20220422/51ee0c3958a44d43a0d8ef78adc7c181.png