centos中怎么安装mysql5.7

本篇文章为大家展示了centos中怎么安装mysql5.7，内容简明扼要并且容易理解，绝对能使你眼前一亮，通过这篇文章的详细介绍希望你能有所收获。

1.查看当前centos系统

[root@43-c58481263-0048-1225006 /]# cat /etc/redhat-release
CentOS Linux release 7.2.1511 (Core)
[root@43-c58481263-0048-1225006 /]# uname -a
Linux 43-c58481263-0048-1225006.novalocal 3.10.0-327.el7.x86_64 #1 SMP Thu Nov 19 22:10:57 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux
[root@43-c58481263-0048-1225006 /]#

2.查看centos7中默认安装的数据库MariaDB

[root@43-c58481263-0048-1225006 /]# rpm -qa|grep mariadb
mariadb-libs-5.5.56-2.el7.x86_64
[root@43-c58481263-0048-1225006 /]#

3.卸载centos安装的默认数据库

[root@43-c58481263-0048-1225006 /]# rpm -qa|grep mariadb
mariadb-libs-5.5.56-2.el7.x86_64
[root@43-c58481263-0048-1225006 /]# rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64
[root@43-c58481263-0048-1225006 /]# rpm -qa|grep mariadb
[root@43-c58481263-0048-1225006 /]#

4.下载mysql

去官网找mysql下载地址： https://dev.mysql.com/downloads/repo/yum/
对应的centos版本：
执行如下命令下载mysql
[root@43-c58481263-0048-1225006 java]# wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
--2019-07-24 14:14:46-- https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
Resolving dev.mysql.com (dev.mysql.com)... 137.254.60.11
Connecting to dev.mysql.com (dev.mysql.com)|137.254.60.11|:443... connected.
HTTP request sent, awaiting response... 302 Found
Location: https://repo.mysql.com//mysql80-community-release-el7-3.noarch.rpm [following]
--2019-07-24 14:14:49-- https://repo.mysql.com//mysql80-community-release-el7-3.noarch.rpm
Resolving repo.mysql.com (repo.mysql.com)... 96.16.173.94
Connecting to repo.mysql.com (repo.mysql.com)|96.16.173.94|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 26024 (25K) [application/x-redhat-package-manager]
Saving to: ‘mysql80-community-release-el7-3.noarch.rpm’

100%[===================================================================================================================>] 26,024 --.-K/s in 0.05s

2019-07-24 14:14:50 (515 KB/s) - ‘mysql80-community-release-el7-3.noarch.rpm’ saved [26024/26024]

[root@43-c58481263-0048-1225006 java]# ll
total 190744
-rw-r--r-- 1 root root 195094741 Jul 23 17:50 jdk-8u221-linux-x64.tar.gz
-rw-r--r-- 1 root root 26024 Apr 25 02:29 mysql80-community-release-el7-3.noarch.rpm
如上截图显示下载成功，接下来进行安装
[root@43-c58481263-0048-1225006 java]# rpm -ivh mysql80-community-release-el7-3.noarch.rpm
warning: mysql80-community-release-el7-3.noarch.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing... ################################# [100%]
Updating / installing...
1:mysql80-community-release-el7-3 ################################# [100%]
[root@43-c58481263-0048-1225006 java]#
接下来查看yum源中的mysql安装包
[root@43-c58481263-0048-1225006 java]# yum repolist all | grep mysql
mysql-cluster-7.5-community/x86_64 MySQL Cluster 7.5 Community disabled
mysql-cluster-7.5-community-source MySQL Cluster 7.5 Community - disabled
mysql-cluster-7.6-community/x86_64 MySQL Cluster 7.6 Community disabled
mysql-cluster-7.6-community-source MySQL Cluster 7.6 Community - disabled
mysql-cluster-8.0-community/x86_64 MySQL Cluster 8.0 Community disabled
mysql-cluster-8.0-community-source MySQL Cluster 8.0 Community - disabled
mysql-connectors-community/x86_64 MySQL Connectors Community enabled: 118
mysql-connectors-community-source MySQL Connectors Community - disabled
mysql-tools-community/x86_64 MySQL Tools Community enabled: 95
mysql-tools-community-source MySQL Tools Community - Sourc disabled
mysql-tools-preview/x86_64 MySQL Tools Preview disabled
mysql-tools-preview-source MySQL Tools Preview - Source disabled
mysql55-community/x86_64 MySQL 5.5 Community Server disabled
mysql55-community-source MySQL 5.5 Community Server - disabled
mysql56-community/x86_64 MySQL 5.6 Community Server disabled
mysql56-community-source MySQL 5.6 Community Server - disabled
mysql57-community/x86_64 MySQL 5.7 Community Server disabled
mysql57-community-source MySQL 5.7 Community Server - disabled
mysql80-community/x86_64 MySQL 8.0 Community Server enabled: 129
mysql80-community-source MySQL 8.0 Community Server - disabled
[root@43-c58481263-0048-1225006 java]#
如上图可以看出，yum源中默认启用的安装包版本为Mysql8.0，如果需要切换成5.7，则需要执行如下命令
[root@43-c58481263-0048-1225006 java]# sudo yum-config-manager --disable mysql80-community
[root@43-c58481263-0048-1225006 java]# sudo yum-config-manager --enable mysql57-community
如上两条命令是禁用mysql8，启用mysql5.7，接下来我们查询如上命令是否执行成功
[root@43-c58481263-0048-1225006 java]# yum repolist all |grep mysql
mysql-cluster-7.5-community/x86_64 MySQL Cluster 7.5 Community disabled
mysql-cluster-7.5-community-source MySQL Cluster 7.5 Community - disabled
mysql-cluster-7.6-community/x86_64 MySQL Cluster 7.6 Community disabled
mysql-cluster-7.6-community-source MySQL Cluster 7.6 Community - disabled
mysql-cluster-8.0-community/x86_64 MySQL Cluster 8.0 Community disabled
mysql-cluster-8.0-community-source MySQL Cluster 8.0 Community - disabled
mysql-connectors-community/x86_64 MySQL Connectors Community enabled: 118
mysql-connectors-community-source MySQL Connectors Community - disabled
mysql-tools-community/x86_64 MySQL Tools Community enabled: 95
mysql-tools-community-source MySQL Tools Community - Sourc disabled
mysql-tools-preview/x86_64 MySQL Tools Preview disabled
mysql-tools-preview-source MySQL Tools Preview - Source disabled
mysql55-community/x86_64 MySQL 5.5 Community Server disabled
mysql55-community-source MySQL 5.5 Community Server - disabled
mysql56-community/x86_64 MySQL 5.6 Community Server disabled
mysql56-community-source MySQL 5.6 Community Server - disabled
mysql57-community/x86_64 MySQL 5.7 Community Server enabled: 364
mysql57-community-source MySQL 5.7 Community Server - disabled
mysql80-community/x86_64 MySQL 8.0 Community Server disabled
mysql80-community-source MySQL 8.0 Community Server - disabled
由上可以看出，mysql80-community禁用了，mysql57-community启用了。

5.安装mysql

执行如下安装命令，如果遇到依赖，选择y就行
[root@43-c58481263-0048-1225006 java]# yum install mysql-community-server Loaded plugins: fastestmirror, langpacks Loading mirror speeds from cached hostfile

• base: 100.125.0.40

• extras: 100.125.0.40

• updates: 100.125.0.40 Resolving Dependencies --> Running transaction check ---> Package mysql-community-server.x86_64 0:5.7.27-1.el7 will be installed --> Processing Dependency: mysql-community-common(x86-64) = 5.7.27-1.el7 for package: mysql-community-server-5.7.27-1.el7.x86_64 --> Processing Dependency: mysql-community-client(x86-64) >= 5.7.9 for package: mysql-community-server-5.7.27-1.el7.x86_64 --> Running transaction check ---> Package mysql-community-client.x86_64 0:5.7.27-1.el7 will be installed --> Processing Dependency: mysql-community-libs(x86-64) >= 5.7.9 for package: mysql-community-client-5.7.27-1.el7.x86_64 ---> Package mysql-community-common.x86_64 0:5.7.27-1.el7 will be installed --> Running transaction check ---> Package mysql-community-libs.x86_64 0:5.7.27-1.el7 will be installed --> Finished Dependency Resolution

Dependencies Resolved ............ Installed: mysql-community-server.x86_64 0:5.7.27-1.el7 Dependency Installed: mysql-community-client.x86_64 0:5.7.27-1.el7 mysql-community-common.x86_64 0:5.7.27-1.el7 mysql-community-libs.x86_64 0:5.7.27-1.el7

Complete!
[root@43-c58481263-0048-1225006 java]#

6.启动mysql,查看mysql运行状态

[root@43-c58481263-0048-1225006 java]# systemctl start mysqld.service
[root@43-c58481263-0048-1225006 java]# systemctl status mysqld.service
● mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: active (running) since Wed 2019-07-24 16:14:18 CST; 26s ago
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
Process: 23775 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)
Process: 23697 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
Main PID: 23778 (mysqld)
CGroup: /system.slice/mysqld.service
└─23778 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid

Jul 24 16:14:11 43-c58481263-0048-1225006.novalocal systemd[1]: Starting MySQL Server...
Jul 24 16:14:18 43-c58481263-0048-1225006.novalocal systemd[1]: Started MySQL Server.
[root@43-c58481263-0048-1225006 java]#
如上查看Active: active (running) 与 Started MySQL Server.就可以知道mysql Server启动起来了。

7.登录mysql

第一次需要设置下mysql 免密登录
[root@43-c58481263-0048-1225006 /]# vi /etc/my.cnf

datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

symbolic-links=0

log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
skip-grant-tables
-- INSERT --
即在结尾处插入skip-grant-tables这一行，设置免密登录。
修改完配置文件，需要重启下mysql
[root@43-c59438365-0048-0727982 mysql]# systemctl restart mysqld.service
[root@43-c59438365-0048-0727982 mysql]# systemctl status mysqld.service
然后进入mysql，执行如下命令
[root@43-c58481263-0048-1225006 /]# mysql -u root

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.7.27 MySQL Community Server (GPL)

Copyright (c) 2000, 2019, 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>
下一步更新mysql密码
mysql> update mysql.user set authentication_string=password('123456') where user='root';
刷新一下权限
mysql> flush privileges;
然后退出
quit;
接着去更新my.cnf文件，去掉免密登录那一行，保存重新启动mysql
mysql> vi /etc/my.cnf
mysql> systemctl restart mysqld
接着就可以使用新密码登录了。

8.设置外网访问

mysql> grant all on . to root@'%' identified by '123456';
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql>

上述内容就是centos中怎么安装mysql5.7，你们学到知识或技能了吗？如果还想学到更多技能或者丰富自己的知识储备，欢迎关注亿速云行业资讯频道。