Centos7 + MySQL5.7安装

已于 2022-03-03 14:59:29 修改
阅读量335 收藏
点赞数
分类专栏： MySQL 文章标签： mysql centos yum
于 2021-01-31 10:31:17 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/a_r00kie/article/details/113458255
版权

1、wget下载MySQL5.7rpm安装包

[root@localhost ~/Project]#wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
--2021-01-31 10:08:46--  https://dev.mysql.com/get/mysql57-community-release-el7-11.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//mysql57-community-release-el7-11.noarch.rpm [following]
--2021-01-31 10:08:47--  https://repo.mysql.com//mysql57-community-release-el7-11.noarch.rpm
Resolving repo.mysql.com (repo.mysql.com)... 104.86.185.42
Connecting to repo.mysql.com (repo.mysql.com)|104.86.185.42|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 25680 (25K) [application/x-redhat-package-manager]
Saving to: ‘mysql57-community-release-el7-11.noarch.rpm’

100%[====================================================================================================================================================================================================================================>] 25,680       157KB/s   in 0.2s   

2021-01-31 10:08:48 (157 KB/s) - ‘mysql57-community-release-el7-11.noarch.rpm’ saved [25680/25680]

[root@localhost ~/Project]#

在这里插入图片描述

2、安装MySQL安装源

[root@localhost ~/Project]#yum -y localinstall mysql57-community-release-el7-11.noarch.rpm 
Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager
This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.
Examining mysql57-community-release-el7-11.noarch.rpm: mysql57-community-release-el7-11.noarch
Marking mysql57-community-release-el7-11.noarch.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package mysql57-community-release.noarch 0:el7-11 will be installed
--> Finished Dependency Resolution
base/x86_64                                                                                                                                                                                                                                            | 3.6 kB  00:00:00     
epel/x86_64                                                                                                                                                                                                                                            | 4.7 kB  00:00:00     
epel/x86_64/updateinfo                                                                                                                                                                                                                                 | 1.0 MB  00:00:00     
epel/x86_64/primary_db                                                                                                                                                                                                                                 | 6.9 MB  00:00:00     
extras/x86_64                                                                                                                                                                                                                                          | 2.9 kB  00:00:00     
updates/x86_64                                                                                                                                                                                                                                         | 2.9 kB  00:00:00     

Dependencies Resolved

==============================================================================================================================================================================================================================================================================
 Package                                                                Arch                                                Version                                               Repository                                                                             Size
==============================================================================================================================================================================================================================================================================
Installing:
 mysql57-community-release                                              noarch                                              el7-11                                                /mysql57-community-release-el7-11.noarch                                               31 k

Transaction Summary
==============================================================================================================================================================================================================================================================================
Install  1 Package

Total size: 31 k
Installed size: 31 k
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : mysql57-community-release-el7-11.noarch                                                                                                                                                                                                                    1/1 
  Verifying  : mysql57-community-release-el7-11.noarch                                                                                                                                                                                                                    1/1 

Installed:
  mysql57-community-release.noarch 0:el7-11                                                                                                                                                                                                                                   

Complete!

在这里插入图片描述

3、在线安装MySQL

[root@localhost ~/Project]#yum -y install mysql-community-server --nogpgcheck
Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager
This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.
mysql-connectors-community                                                                                                                                                                                                                             | 2.6 kB  00:00:00     
mysql-tools-community                                                                                                                                                                                                                                  | 2.6 kB  00:00:00     
mysql57-community                                                                                                                                                                                                                                      | 2.6 kB  00:00:00     
(1/3): mysql-connectors-community/x86_64/primary_db                                                                                                                                                                                                    |  72 kB  00:00:00     
(2/3): mysql-tools-community/x86_64/primary_db                                                                                                                                                                                                         |  85 kB  00:00:00     
(3/3): mysql57-community/x86_64/primary_db                                                                                                                                                                                                             | 258 kB  00:00:03     
Resolving Dependencies
--> Running transaction check
---> Package mariadb-server.x86_64 1:5.5.68-1.el7 will be obsoleted
---> Package mysql-community-server.x86_64 0:5.7.33-1.el7 will be obsoleting
--> Processing Dependency: mysql-community-common(x86-64) = 5.7.33-1.el7 for package: mysql-community-server-5.7.33-1.el7.x86_64
--> Processing Dependency: mysql-community-client(x86-64) >= 5.7.9 for package: mysql-community-server-5.7.33-1.el7.x86_64
--> Running transaction check
---> Package mariadb.x86_64 1:5.5.68-1.el7 will be obsoleted
---> Package mysql-community-client.x86_64 0:5.7.33-1.el7 will be obsoleting
--> Processing Dependency: mysql-community-libs(x86-64) >= 5.7.9 for package: mysql-community-client-5.7.33-1.el7.x86_64
---> Package mysql-community-common.x86_64 0:5.7.33-1.el7 will be installed
--> Running transaction check
---> Package mariadb-libs.x86_64 1:5.5.68-1.el7 will be obsoleted
--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: perl-DBD-MySQL-4.023-5.el7.x86_64
--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: 2:postfix-2.10.1-6.el7.x86_64
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: perl-DBD-MySQL-4.023-5.el7.x86_64
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: 2:postfix-2.10.1-6.el7.x86_64
---> Package mysql-community-libs.x86_64 0:5.7.33-1.el7 will be obsoleting
--> Running transaction check
---> Package mysql-community-libs-compat.x86_64 0:5.7.33-1.el7 will be obsoleting
---> Package perl-DBD-MySQL.x86_64 0:4.023-5.el7 will be updated
---> Package perl-DBD-MySQL.x86_64 0:4.023-6.el7 will be an update
---> Package postfix.x86_64 2:2.10.1-6.el7 will be updated
---> Package postfix.x86_64 2:2.10.1-9.el7 will be an update
--> Finished Dependency Resolution

Dependencies Resolved

在这里插入图片描述

4、设置开机自启动MySQL服务

[root@localhost ~/Project]#systemctl start mysqld
[root@localhost ~/Project]#systemctl enable mysqld
[root@localhost ~/Project]#systemctl daemon-reload

在这里插入图片描述

5、修改MySQL root登录密码

  1. 获取临时密码

    [root@localhost ~/Project]#cat /var/log/mysqld.log | grep root@localhost
2021-01-31T01:04:29.718686Z 1 [Note] A temporary password is generated for root@localhost: qY?uY6NuW?3-

在这里插入图片描述
2. 使用临时密码登录MySQL

[root@localhost ~/Project]#mysql -hlocalhost -uroot -P3306 -pqY?uY6NuW?3-
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.33

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

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>

在这里插入图片描述
3. 修改密码（要求密码至少为8位且必须为大小写字母数字特殊字母的组合）

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'Root1234@';
Query OK, 0 rows affected (0.00 sec)

在这里插入图片描述

6、设置允许远程登录

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'Root1234@' WITH GRANT OPTION;
Query OK, 0 rows affected, 1 warning (0.01 sec)

在这里插入图片描述

7、退出

mysql> exit;
Bye

在这里插入图片描述

8、配置MySQL默认编码为utf-8

修改/etc/my.cnf配置文件，在[mysqld]下添加编码配置：

character_set_server=utf8
init_connect='SET NAMES utf8'

在这里插入图片描述

9、重启MySQL服务并登录MySQL验证编码

[root@localhost ~/Project]#systemctl restart mysqld
[root@localhost ~/Project]#mysql -hlocalhost -uroot -P3306 -pRoot1234@
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.33 MySQL Community Server (GPL)

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

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> show variables like '%character%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | utf8                       |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | utf8                       |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.01 sec)

mysql>

在这里插入图片描述

10、测试Navicat远程连接

在这里插入图片描述

a_r00kie
关注
专栏目录
centos7安装mysql5.7
m0_67401417的博客
06-02 137
2、然后上传到服务器上面 解压命令 3、解压后得到以下的rpm包 4、依次安装所需要的rpm包 如果出现以下报错，则在上面命令最后加上 --force --nodeps 例如: 5、查看安装情况 就此安装成功了！！！启动指令 如果启动报错，可以执行journalctl -xe指令查看错误信息 我这里提示找不到这个libaio 查看是否安装了libaio，如下图: 空空如也，说明没有安装使用yum命令安装一下 然后再执行启动命令即可 .1、查看初始密码(要记住这个密码之后会用到) 2、用初始化的密
MySQL5.7版本在CentOS系统安装
weixin_74941202的博客
07-12 1020
注意：安装操作需要root权限MySQL的安装我们可以通过前面学习的yum命令进行。
centos 7 安装mysql5.7
w_hname的博客
04-02 1313
1、 选择MySQL Community (GPL) Downloads »。2、选择MySQL Community Server。安装过程中出现如下异常，将mysql的lib包移除。通过官网下载对应的mysql版本，mysql官网。2、切换账号信息，使用root账号进行安装。3、选择对应的操作系统和mysql版本。如果有安装请先卸载，卸载命令如下。1、上传mysql软件包。
在centos7上安装mysql5.7
最新发布
2203_75584759的博客
09-02 844
在centos7里面安装mysql数据库
CentOS7+apache+php7+mysql5.7配置教程详解
09-09
在本教程中，我们将深入探讨如何在CentOS7操作系统上配置一个完整的Web服务器环境，包括Apache Web服务器、PHP7和MySQL5.7数据库。这个环境是许多网站和应用程序的基础，对于开发者和系统管理员来说，了解如何正确...
centos nginx+mysql5.7+redis+postgresql12+postgis 安装包
06-28
首先，CentOS 7是一款流行的Linux发行版，以其稳定性和企业级特性而备受青睐，是搭建服务器的首选平台。安装时，需要确保系统是最新的，可以通过`yum update`命令进行更新。 接下来，我们安装Nginx，它是一个高性能...
CentOS 7.6+mysql5.7 设置mysql开机自启动。.pdf
12-16
以下是关于如何在CentOS 7.6上配置MySQL 5.7以实现开机自启动的详细步骤： 1. **开启MySQL服务**： 在root权限下，首先你需要启动MySQL服务。你可以通过以下命令来启动MySQL 5.7服务： ```bash systemctl ...
mysql5.7在centos上安装的完整教程以及相关的“坑”
weixin_30538029的博客
11-25 179
安装前的准备Step1: 如果你系统已经有mysql，如一般centos自带mysql5.1系列，那么你需要删除它，先检查一下系统是否自带mysqlyum list installed | grep mysqlStep2: 删除系统自带的mysql及其依赖命令yum -y remove mysql-libs.x86_64Step3: 给CentOS添加rpm源，并且选择较新的源命令wget d...
centos7安装MySQL5.7（附图文）
qq_29423323的博客
07-05 1082
centos安装MySQL5.7记录。
CentOS7 Mysql5.7 安装
Ivan_Lee8023的专栏
06-15 173
下载Mysqlyumrepo配置文件： wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm
centos7 Mysql 5.7安装
wangxuelei036的博客
12-02 352
很久没用直接使用mysql源码包在linux安装了，今天刚好因为项目环境需要在物理机上搭建一个mysql环境，刚好记录下 MySQL 5.7.32详细下载安装配置教程 前言 在安装MySQL的时候会遇到很多问题，博客上有很多解决问题的办法，在这里我附上一些链接，遇到问题的朋友们可以阅读参考哈~本文主要针对于刚接触数据库的小白，来安装MySQL数据库。目前官网上的MySQL版本有5.5，5.6，5.7和8，在开发的时候我们一般要选择比最新版低1到2个版本的，因此我选择了5.7作为要安装的数据库 1..
centos7 安装MySQL5.7
qq_60955660的博客
08-10 702
centos7 MySQL5.7部署安装详细过程
CentOS7安装MySQL5.7
邢富鹏
11-28 592
CentOS7安装MySQL5.7查看系统中是否已安装 MySQL 服务删除已安装的MySQL下载 mysql57-community-release-el7-8.noarch.rpm 的 YUM 源：安装 mysql57-community-release-el7-8.noarch.rpm安装MySQL服务MySQL服务管理 查看系统中是否已安装 MySQL 服务 以下两个命令（方式）都能查出是...
centos7 安装mysql5.7
weixin_44384641的博客
07-14 348
centos7下安装mysql5.7，配置公钥，修改初始密码，设置外部访问
Linux安装MySQL 并修改端口,密码
向着高亮的地方
08-14 1433
第一部分：安装MySQL 5.7 1.下载YUM库 shell > wget http://dev.mysql.com/get/mysql57-community-release-el7-7.noarch.rpm 2.安装YUM库 shell > yum localinstall -y mysql57-community-release-el7-7.noarch.rpm ...
CentOS7 安装 MySQL5.7
qq_38377190的博客
04-05 2816
CentOS7 安装 MySQL5.7
CentOS7安装MySQL5.7详细教程
"本教程详细介绍了在CentOS7系统上如何安装和配置MySQL5.7。包括使用wget下载安装包，通过yum安装MySQL服务器，启动和检查MySQL服务状态，获取和修改临时密码，以及允许远程访问MySQL数据库的步骤。" 在CentOS7环境...
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值