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)

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，你们学到知识或技能了吗？如果还想学到更多技能或者丰富自己的知识储备，欢迎关注创新互联行业资讯频道。

文章名称：centos中怎么安装mysql5.7
分享链接：http://chengdu.cdxwcx.cn/article/jdspic.html

甜橘子，专注成都网站制作网站设计与营销型网站建设与优化

首页

网站建设

网站制作案例

解决方案

网站设计报价

网站制作动态

关于我们

联系我们

成都网站建设设计将想法与焦点和您一起共享

centos中怎么安装mysql5.7

1.查看当前centos系统

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

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

4.下载mysql

5.安装mysql

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

7.登录mysql

8.设置外网访问

其他资讯

jquery冒泡事件,jquery冒泡事件和捕获事件

android顶部,android顶部悬浮窗

合力泰bpm系统登录,合力泰guan方网站

flutter渲染过程,flutter渲染流程

windows8系统好的简单介绍

甜橘子，专注成都网站制作网站设计与营销型网站建设与优化

成都网站建设设计 将想法与焦点和您一起共享

centos中怎么安装mysql5.7

1.查看当前centos系统

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

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

4.下载mysql

5.安装mysql

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

7.登录mysql

8.设置外网访问

其他资讯

jquery冒泡事件,jquery冒泡事件和捕获事件

android顶部,android顶部悬浮窗

合力泰bpm系统登录,合力泰guan方网站

flutter渲染过程,flutter渲染流程

windows8系统好的简单介绍

成都网站建设设计将想法与焦点和您一起共享