centos中怎么安装mysql5.7

本篇文章为大家展示了centos中怎么安装mysql5.7，内容简明扼要并且容易理解，绝对能使你眼前一亮，通过这篇文章的详细介绍希望你能有所收获。[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 /]#[root@43-c58481263-0048-1225006 /]# rpm -qa|grep mariadb
mariadb-libs-5.5.56-2.el7.x86_64
[root@43-c58481263-0048-1225006 /]#[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 /]#去官网找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.05s2019-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
Prepar 香港云主机ing… ################################# [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启用了。执行如下安装命令，如果遇到依赖，选择y就行
[root@43-c58481263-0048-1225006 java]# yum install mysql-community-server Loaded plugins: fastestmirror, langpacks Loading mirror speeds from cached hostfilebase: 100.125.0.40extras: 100.125.0.40updates: 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 ResolutionDependencies 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.el7Complete!
[root@43-c58481263-0048-1225006 java]#[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.pidJul 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启动起来了。第一次需要设置下mysql 免密登录
[root@43-c58481263-0048-1225006 /]# vi /etc/my.cnfdatadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.socksymbolic-links=0log-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 rootWelcome 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
接着就可以使用新密码登录了。mysql> grant all on . to root@’%’ identified by ‘123456’;
Query OK, 0 rows affected, 1 warning (0.00 sec)mysql>上述内容就是centos中怎么安装mysql5.7，你们学到知识或技能了吗？如果还想学到更多技能或者丰富自己的知识储备，欢迎关注开发云行业资讯频道。

相关推荐: Nacos Committer 张龙：Nacos Sync 的设计原理和规划

与你同行，抬头便是星空。 本文整理自Nacos Committer 张龙的现场分享，阿里巴巴中间件受权发布。 随着 Nacos 1.0.0 稳定版的发布，越来越多的企业开始在测试/预演/生产环境中逐步部署 Nacos。目前，除了部分企业已处于转型分布式架构 香…