Centos7 环境下安装 Mysql 5.7

1.1、选择版本（本文安装方为RPM包安装方式）

下载链接：https://dev.mysql.com/downloads/mysql/

 

 

1.2、MySQL版本选择完成后，选择操作系统的版本

 

 

 

1.3、操作系统选择完成后，往下可看到可供下载的资源

 

1.4、跳过登录或注册，直接下载

 

下载完成后，打开查看确认

 

 

2、解压到指定的文件夹

[root@localhost /]# tar -xvf mysql-5.7.22-1.el7.x86_64.rpm-bundle.tar -C /usr/local/mysql

结果如下：

mysql-community-libs-5.7.22-1.el7.x86_64.rpm

mysql-community-libs-compat-5.7.22-1.el7.x86_64.rpm

mysql-community-embedded-5.7.22-1.el7.x86_64.rpm

mysql-community-test-5.7.22-1.el7.x86_64.rpm

mysql-community-server-5.7.22-1.el7.x86_64.rpm

mysql-community-client-5.7.22-1.el7.x86_64.rpm

mysql-community-server-minimal-5.7.22-1.el7.x86_64.rpm

mysql-community-devel-5.7.22-1.el7.x86_64.rpm

mysql-community-common-5.7.22-1.el7.x86_64.rpm

mysql-community-minimal-debuginfo-5.7.22-1.el7.x86_64.rpm

mysql-community-embedded-devel-5.7.22-1.el7.x86_64.rpm

mysql-community-embedded-compat-5.7.22-1.el7.x86_64.rpm

 

3、依次安装

先查询Centos 是否安装mysql

[root@localhost ~]# rpm -qa|grep mysql
[root@localhost ~]# rpm -qa|grep maria
mariadb-libs-5.5.65-1.el7.x86_64

有就卸载自带的mysql

[root@localhost ~]# yum remove maria-libs
Loaded plugins: fastestmirror
No Match for argument: maria-libs
No Packages marked for removal
[root@localhost ~]# yum remove mysql-libs
Loaded plugins: fastestmirror
Resolving Dependencies
--> Running transaction check
---> Package mariadb-libs.x86_64 1:5.5.65-1.el7 will be erased
--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: 2:postfix-2.10.1-9.el7.x86_64
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: 2:postfix-2.10.1-9.el7.x86_64
--> Running transaction check
---> Package postfix.x86_64 2:2.10.1-9.el7 will be erased
--> Finished Dependency Resolution

Dependencies Resolved

=========================================================================================================================================
 Package                           Arch                        Version                              Repository                      Size
=========================================================================================================================================
Removing:
 mariadb-libs                      x86_64                      1:5.5.65-1.el7                       @anaconda                      4.4 M
Removing for dependencies:
 postfix                           x86_64                      2:2.10.1-9.el7                       @anaconda                       12 M

Transaction Summary
=========================================================================================================================================
Remove  1 Package (+1 Dependent package)

Installed size: 17 M
Is this ok [y/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Erasing    : 2:postfix-2.10.1-9.el7.x86_64                                                                                         1/2 
  Erasing    : 1:mariadb-libs-5.5.65-1.el7.x86_64                                                                                    2/2 
  Verifying  : 1:mariadb-libs-5.5.65-1.el7.x86_64                                                                                    1/2 
  Verifying  : 2:postfix-2.10.1-9.el7.x86_64                                                                                         2/2 

Removed:
  mariadb-libs.x86_64 1:5.5.65-1.el7                                                                                                     

Dependency Removed:
  postfix.x86_64 2:2.10.1-9.el7                                                                                                          

Complete!

1、mysql-community-common-5.7.22-1.el7.x86_64.rpm

rpm -ivh mysql-community-common-5.7.22-1.el7.x86_64.rpm

[root@hadoop1 mysql]# rpm -ivh mysql-community-common-5.7.22-1.el7.x86_64.rpm
warning: mysql-community-common-5.7.22-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:mysql-community-common-5.7.22-1.e################################# [100%]

 

2、mysql-community-libs-5.7.22-1.el7.x86_64.rpm

rpm -ivh mysql-community-libs-5.7.22-1.el7.x86_64.rpm

[root@hadoop1 mysql]# rpm -ivh mysql-community-libs-5.7.22-1.el7.x86_64.rpm
warning: mysql-community-libs-5.7.22-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:mysql-community-libs-5.7.22-1.el7################################# [100%]

 

3、mysql-community-client-5.7.22-1.el7.x86_64.rpm

rpm -ivh mysql-community-client-5.7.22-1.el7.x86_64.rpm

[root@hadoop1 mysql]# rpm -ivh mysql-community-client-5.7.22-1.el7.x86_64.rpm
warning: mysql-community-client-5.7.22-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:mysql-community-client-5.7.22-1.e################################# [100%]

 

4、mysql-community-server-5.7.22-1.el7.x86_64.rpm

rpm -ivh mysql-community-server-5.7.22-1.el7.x86_64.rpm

[root@hadoop1 mysql]# rpm -ivh mysql-community-server-5.7.22-1.el7.x86_64.rpm
warning: mysql-community-server-5.7.22-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:mysql-community-server-5.7.22-1.e################################# [100%]

 

如果出现如下错误，说明缺少net-tools。

warning: mysql-community-server-5.7.22-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
error: Failed dependencies:
	net-tools is needed by mysql-community-server-5.7.22-1.el7.x86_64

 解决方法：有网络的情况下安装即可 yum install net-tools ，没有网络就强制安装

rpm -ivh mysql-community-server-5.7.22-1.el7.x86_64.rpm --force --nodeps （--nodeps就是安装时不检查依赖关系，比如你这个rpm需要A，但是你没装A，这样你的包就装不上，用了--nodeps你就能装上了。--force就是强制安装，比如你装过这个rpm的版本1，如果你想装这个rpm的版本2，就需要用--force强制安装）

 

备注：如果安装时遇到有安装冲突，例如

 

原因：已存在mariadb-libs-1:5.5.56-2.el7.x86_64的库（系统自带或者之前装错）所以需要先删除以前的库才能安装！
解决方法：执行以下命令，强制卸载
[root@localhost mysql]# rpm -e mariadb-libs-1:5.5.56-2.el7.x86_64 --nodeps

 

4、查询是否安装成功

 

 

 

5、启动数据库服务

[root@kevin ~]# systemctl start mysqld.service

[root@kevin ~]# systemctl enable mysqld.service

 

6、查询临时密码，登录MySQL

[root@kevin ~]# cat /var/log/mysqld.log

 

[root@localhost mysql]# grep 'temporary password' /var/log/mysqld.log

7、修改密码（先输入临时密码，再输入新密码）

[root@localhost mysql]# mysqladmin -u root -p password

 

如果修改密码报错

 

原因：

 

解决方法：

1、先用临时密码登录进去

[root@localhost mysql]# mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.7.22

Copyright (c) 2000, 2018, 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.

2、mysql> set global validate_password_policy=0; //把密码策略改位等级0

3、mysql> set global validate_password_length=1;//把密码长度限制改为不小于1

4、mysql> set password=password('123456'); //设置新的密码

修改成功：

 

 

8、Navicat远程连接数据库 

a、首先开放端口（有些端口是默认开放的）：

iptables -I INPUT -p tcp --dport 3306 -j ACCEPT

  查看端口的情况 ：netstat -an | grep 3306

[root@localhost ~]# netstat -an | grep 3306
tcp6       0      0 :::3306                 :::*                    LISTEN     
tcp6       0      0 192.168.6.55:3306       192.168.6.71:64127      ESTABLISHED
tcp6       0      0 192.168.6.55:3306       192.168.6.71:64126      ESTABLISHED

b、从任何主机上使用root用户，密码：youpassword（你的root密码）连接到mysql服务器：

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

   刷新权限：

 FLUSH PRIVILEGES

c、Navicat 设置并连接

 

 

以上本人实测安装成功，也可参考以下链接：

https://www.cnblogs.com/kevingrace/p/8340690.html

https://blog.csdn.net/a1173537204/article/details/88377518

https://blog.csdn.net/qq_24994547/article/details/100096785