centos7中安装mysql5.7

Dear 丶 2023-05-28 06:49 7阅读 0赞

##### 1.删除之前的环境包 #####

查看是否已经安装过mysql：`rpm -qa | grep -i mysql`  
![在这里插入图片描述][20200328153303599.png]  
删除yum相关的内容：

yum remove mysql mysql-server mysql-libs compat-mysql51
    yum remove mysql-community-release

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dpdGh1Yl8zODkyNDY5NQ_size_16_color_FFFFFF_t_70]  
![在这里插入图片描述][20200328153613744.png]  
再次查看rpm -qa | grep -i mysql，发现还剩一个内容，删除即可。  
![在这里插入图片描述][20200328153747130.png]  
使用whereis mysql及find / -name mysql查看mysql安装位置并删除所有的文件及位置。  
![在这里插入图片描述][20200328154102845.png]  
删除配置文件：

rm -rf /usr/my.cnf
    rm -rf /root/.mysql_sercret

##### 2.下载rpm #####

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

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dpdGh1Yl8zODkyNDY5NQ_size_16_color_FFFFFF_t_70 1]

##### 3.安装rpm文件 #####

rpm -ivh mysql57-community-release-el7-11.noarch.rpm
    yum install mysql-community-server

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dpdGh1Yl8zODkyNDY5NQ_size_16_color_FFFFFF_t_70 2]

##### 4.启动mysql #####

service mysqld start

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dpdGh1Yl8zODkyNDY5NQ_size_16_color_FFFFFF_t_70 3]

##### 5.进入mysql并重置密码 #####

第一次进入时候，没有密码，直接回车即可。如果不行，关闭mysql后，直接编辑/etc/my.cnf文件，加入skip-grant-tables这一句，再重启mysql。  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dpdGh1Yl8zODkyNDY5NQ_size_16_color_FFFFFF_t_70 4]  
执行mysql -u root -p，直接回车，进入mysql。

[root@iZhp344kyu0xy66fvi6m8tZ mysql]# mysql -u root -p
    Enter password: 
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 2
    Server version: 5.7.29 MySQL Community Server (GPL)
    
    Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.
    
    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.
    
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
    mysql> use mysql
    Reading table information for completion of table and column names
    You can turn off this feature to get a quicker startup with -A
    Database changed
    
    mysql> UPDATE mysql.user SET authentication_string=PASSWORD('密码') where USER='root'; //修改密码
    Query OK, 1 row affected, 1 warning (0.00 sec)
    Rows matched: 1  Changed: 1  Warnings: 1
    mysql> flush privileges; //设置生效
    Query OK, 0 rows affected (0.01 sec)

退出后，删除/etc/my.cnf中加的skip-grant-tables，并重启mysql，使用新密码进入mysql  
设置可以远程访问：

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '密码';
    Query OK, 0 rows affected (0.00 sec)
    
    mysql> grant all privileges on *.* to root@"%" identified by "密码";
    Query OK, 0 rows affected, 1 warning (0.00 sec)
    mysql> flush privileges; //设置生效
    Query OK, 0 rows affected (0.01 sec)

##### 6.设置开机启动 #####

systemctl enable mysqld
    systemctl daemon-reload

[20200328153303599.png]: /images/20230528/e9c911ae20e44113bd8871fbe645c8cf.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dpdGh1Yl8zODkyNDY5NQ_size_16_color_FFFFFF_t_70]: /images/20230528/8edebd05c3ac4d41bc6785188186eff8.png
[20200328153613744.png]: /images/20230528/9ac4c3c1ed2e4955b33c634048479632.png
[20200328153747130.png]: /images/20230528/b8d1755242c14227be7a80d948a03770.png
[20200328154102845.png]: /images/20230528/41c9c62032e34f659c570ad6d52384aa.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dpdGh1Yl8zODkyNDY5NQ_size_16_color_FFFFFF_t_70 1]: /images/20230528/53cf3eb7ec674d10b3d8174ea30c15e5.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dpdGh1Yl8zODkyNDY5NQ_size_16_color_FFFFFF_t_70 2]: /images/20230528/dbb2d6152c364192b73b33de0c0bf93c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dpdGh1Yl8zODkyNDY5NQ_size_16_color_FFFFFF_t_70 3]: /images/20230528/6518ccc9f4b44bc9984bacf7d5cee588.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2dpdGh1Yl8zODkyNDY5NQ_size_16_color_FFFFFF_t_70 4]: /images/20230528/248c2cf238264f169d47d7b413b2de3c.png