centos 7中 Mysql的在线安装

最新推荐文章于 2025-04-06 11:23:30 发布
最新推荐文章于 2025-04-06 11:23:30 发布
阅读量927 收藏 3
点赞数 1
分类专栏： hadoop
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/qq_41028958/article/details/80820397
版权

一：

正确的安装mysql5姿势是要先安装带有可用的mysql5系列社区版资源的rpm包


[root@slave1 ~]# rpm -Uvh http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm

[root@slave1 ~]# yum repolist enabled | grep "mysql.*-community.*"

一般来说，只要安装mysql-server跟mysql-client 

这个时候我们可以直接使用yum的方式安装MySQL了

[root@slave1 ~]#  yum -y install mysql-community-server
已加载插件：fastestmirror, langpacks
Loading mirror speeds from cached hostfile
 * base: mirrors.neusoft.edu.cn
 * extras: mirrors.njupt.edu.cn
 * updates: mirrors.njupt.edu.cn
正在解决依赖关系
--> 正在检查事务
---> 软件包 mysql-community-server.x86_64.0.5.6.40-2.el7 将被 安装
--> 正在处理依赖关系 mysql-community-common(x86-64) = 5.6.40-2.el7，它被软件包 mysql-community-server-5.6.40-2.el7.x86_64 需要
--> 正在处理依赖关系 mysql-community-client(x86-64) >= 5.6.10，它被软件包 mysql-community-server-5.6.40-2.el7.x86_64 需要
--> 正在处理依赖关系 perl(DBI)，它被软件包 mysql-community-server-5.6.40-2.el7.x86_64 需要
--> 正在检查事务
---> 软件包 mysql-community-client.x86_64.0.5.6.40-2.el7 将被 安装
--> 正在处理依赖关系 mysql-community-libs(x86-64) >= 5.6.10，它被软件包 mysql-community-client-5.6.40-2.el7.x86_64 需要
---> 软件包 mysql-community-common.x86_64.0.5.6.40-2.el7 将被 安装
---> 软件包 perl-DBI.x86_64.0.1.627-4.el7 将被 安装
--> 正在处理依赖关系 perl(RPC::PlServer) >= 0.2001，它被软件包 perl-DBI-1.627-4.el7.x86_64 需要
--> 正在处理依赖关系 perl(RPC::PlClient) >= 0.2000，它被软件包 perl-DBI-1.627-4.el7.x86_64 需要
--> 正在检查事务
---> 软件包 mariadb-libs.x86_64.1.5.5.44-2.el7.centos 将被 取代
---> 软件包 mysql-community-libs.x86_64.0.5.6.40-2.el7 将被 舍弃
---> 软件包 perl-PlRPC.noarch.0.0.2020-14.el7 将被 安装
--> 正在处理依赖关系 perl(Net::Daemon) >= 0.13，它被软件包 perl-PlRPC-0.2020-14.el7.noarch 需要
--> 正在处理依赖关系 perl(Net::Daemon::Test)，它被软件包 perl-PlRPC-0.2020-14.el7.noarch 需要
--> 正在处理依赖关系 perl(Net::Daemon::Log)，它被软件包 perl-PlRPC-0.2020-14.el7.noarch 需要
--> 正在处理依赖关系 perl(Compress::Zlib)，它被软件包 perl-PlRPC-0.2020-14.el7.noarch 需要
--> 正在检查事务
---> 软件包 perl-IO-Compress.noarch.0.2.061-2.el7 将被 安装
--> 正在处理依赖关系 perl(Compress::Raw::Zlib) >= 2.061，它被软件包 perl-IO-Compress-2.061-2.el7.noarch 需要
--> 正在处理依赖关系 perl(Compress::Raw::Bzip2) >= 2.061，它被软件包 perl-IO-Compress-2.061-2.el7.noarch 需要
---> 软件包 perl-Net-Daemon.noarch.0.0.48-5.el7 将被 安装
--> 正在检查事务
---> 软件包 perl-Compress-Raw-Bzip2.x86_64.0.2.061-3.el7 将被 安装
---> 软件包 perl-Compress-Raw-Zlib.x86_64.1.2.061-4.el7 将被 安装
--> 解决依赖关系完成

依赖关系解决

===================================================================================================================
 Package                            架构              版本                      源                            大小
===================================================================================================================
正在安装:
 mysql-community-libs               x86_64            5.6.40-2.el7              mysql56-community            2.0 M
      替换  mariadb-libs.x86_64 1:5.5.44-2.el7.centos
 mysql-community-server             x86_64            5.6.40-2.el7              mysql56-community             59 M
为依赖而安装:
 mysql-community-client             x86_64            5.6.40-2.el7              mysql56-community             19 M
 mysql-community-common             x86_64            5.6.40-2.el7              mysql56-community            257 k
 perl-Compress-Raw-Bzip2            x86_64            2.061-3.el7               base                          32 k
 perl-Compress-Raw-Zlib             x86_64            1:2.061-4.el7             base                          57 k
 perl-DBI                           x86_64            1.627-4.el7               base                         802 k
 perl-IO-Compress                   noarch            2.061-2.el7               base                         260 k
 perl-Net-Daemon                    noarch            0.48-5.el7                base                          51 k
 perl-PlRPC                         noarch            0.2020-14.el7             base                          36 k

事务概要
===================================================================================================================
安装  2 软件包 (+8 依赖软件包)

总下载量：82 M
Downloading packages:
警告：/var/cache/yum/x86_64/7/mysql56-community/packages/mysql-community-common-5.6.40-2.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY
mysql-community-common-5.6.40-2.el7.x86_64.rpm 的公钥尚未安装
(1/10): mysql-community-common-5.6.40-2.el7.x86_64.rpm                                      | 257 kB  00:00:01     
(2/10): mysql-community-libs-5.6.40-2.el7.x86_64.rpm                                        | 2.0 MB  00:00:01     
警告：/var/cache/yum/x86_64/7/base/packages/perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64.rpm: 头V3 RSA/SHA256 Signature, 密钥 ID f4a80eb5: NOKEY
perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64.rpm 的公钥尚未安装
(3/10): perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64.rpm                                      |  32 kB  00:00:00     
(4/10): perl-Compress-Raw-Zlib-2.061-4.el7.x86_64.rpm                                       |  57 kB  00:00:00     
(5/10): perl-DBI-1.627-4.el7.x86_64.rpm                                                     | 802 kB  00:00:01     
(6/10): perl-PlRPC-0.2020-14.el7.noarch.rpm                                                 |  36 kB  00:00:00     
(7/10): perl-Net-Daemon-0.48-5.el7.noarch.rpm                                               |  51 kB  00:00:00     
(8/10): perl-IO-Compress-2.061-2.el7.noarch.rpm                                             | 260 kB  00:00:00     
(9/10): mysql-community-client-5.6.40-2.el7.x86_64.rpm                                      |  19 MB  00:00:06     
(10/10): mysql-community-server-5.6.40-2.el7.x86_64.rpm                                     |  59 MB  00:00:15     
-------------------------------------------------------------------------------------------------------------------
总计                                                                               4.5 MB/s |  82 MB  00:00:18     
从 file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7 检索密钥
导入 GPG key 0xF4A80EB5:
 用户ID     : "CentOS-7 Key (CentOS 7 Official Signing Key) <security@centos.org>"
 指纹       : 6341 ab27 53d7 8a78 a7c2 7bb1 24c6 a8a7 f4a8 0eb5
 软件包     : centos-release-7-2.1511.el7.centos.2.10.x86_64 (@anaconda)
 来自       : /etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7
从 file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql 检索密钥
导入 GPG key 0x5072E1F5:
 用户ID     : "MySQL Release Engineering <mysql-build@oss.oracle.com>"
 指纹       : a4a9 4068 76fc bd3c 4567 70c8 8c71 8d3b 5072 e1f5
 软件包     : mysql-community-release-el7-5.noarch (installed)
 来自       : file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
警告：RPM 数据库已被非 yum 程序修改。
  正在安装    : mysql-community-common-5.6.40-2.el7.x86_64                                                    1/11 
  正在安装    : mysql-community-libs-5.6.40-2.el7.x86_64                                                      2/11 
  正在安装    : mysql-community-client-5.6.40-2.el7.x86_64                                                    3/11 
  正在安装    : perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64                                                    4/11 
  正在安装    : 1:perl-Compress-Raw-Zlib-2.061-4.el7.x86_64                                                   5/11 
  正在安装    : perl-IO-Compress-2.061-2.el7.noarch                                                           6/11 
  正在安装    : perl-Net-Daemon-0.48-5.el7.noarch                                                             7/11 
  正在安装    : perl-PlRPC-0.2020-14.el7.noarch                                                               8/11 
  正在安装    : perl-DBI-1.627-4.el7.x86_64                                                                   9/11 
  正在安装    : mysql-community-server-5.6.40-2.el7.x86_64                                                   10/11 
  正在删除    : 1:mariadb-libs-5.5.44-2.el7.centos.x86_64                                                    11/11 
  验证中      : perl-Net-Daemon-0.48-5.el7.noarch                                                             1/11 
  验证中      : mysql-community-server-5.6.40-2.el7.x86_64                                                    2/11 
  验证中      : perl-PlRPC-0.2020-14.el7.noarch                                                               3/11 
  验证中      : mysql-community-client-5.6.40-2.el7.x86_64                                                    4/11 
  验证中      : 1:perl-Compress-Raw-Zlib-2.061-4.el7.x86_64                                                   5/11 
  验证中      : perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64                                                    6/11 
  验证中      : mysql-community-libs-5.6.40-2.el7.x86_64                                                      7/11 
  验证中      : mysql-community-common-5.6.40-2.el7.x86_64                                                    8/11 
  验证中      : perl-DBI-1.627-4.el7.x86_64                                                                   9/11 
  验证中      : perl-IO-Compress-2.061-2.el7.noarch                                                          10/11 
  验证中      : 1:mariadb-libs-5.5.44-2.el7.centos.x86_64                                                    11/11 

已安装:
  mysql-community-libs.x86_64 0:5.6.40-2.el7              mysql-community-server.x86_64 0:5.6.40-2.el7             

作为依赖被安装:
  mysql-community-client.x86_64 0:5.6.40-2.el7             mysql-community-common.x86_64 0:5.6.40-2.el7            
  perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7             perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7             
  perl-DBI.x86_64 0:1.627-4.el7                            perl-IO-Compress.noarch 0:2.061-2.el7                   
  perl-Net-Daemon.noarch 0:0.48-5.el7                      perl-PlRPC.noarch 0:0.2020-14.el7                       

替代:
  mariadb-libs.x86_64 1:5.5.44-2.el7.centos                                                                        

完毕！

安装完的配置

加入开机启动

[root@slave1 ~]# systemctl enable mysqld

启动mysql服务进程

[root@slave1 ~]#  systemctl start mysqld

重置密码

[root@slave1 ~]# mysql_secure_installation



NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!

In order to log into MySQL to secure it, we'll need the current
password for the root user.  If you've just installed MySQL, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none): 
OK, successfully used password, moving on...

Setting the root password ensures that nobody can log into the MySQL
root user without the proper authorisation.

Set root password? [Y/n] y
New password: 
Re-enter new password: 
Password updated successfully!
Reloading privilege tables..
 ... Success!


By default, a MySQL installation has an anonymous user, allowing anyone
to log into MySQL without having to have a user account created for
them.  This is intended only for testing, and to make the installation
go a bit smoother.  You should remove them before moving into a
production environment.

Remove anonymous users? [Y/n] y
 ... Success!

Normally, root should only be allowed to connect from 'localhost'.  This
ensures that someone cannot guess at the root password from the network.

Disallow root login remotely? [Y/n] n
 ... skipping.

By default, MySQL comes with a database named 'test' that anyone can
access.  This is also intended only for testing, and should be removed
before moving into a production environment.

Remove test database and access to it? [Y/n] y
 - Dropping test database...
ERROR 1008 (HY000) at line 1: Can't drop database 'test'; database doesn't exist
 ... Failed!  Not critical, keep moving...
 - Removing privileges on test database...
 ... Success!

Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.

Reload privilege tables now? [Y/n] y
 ... Success!




All done!  If you've completed all of the above steps, your MySQL
installation should now be secure.

Thanks for using MySQL!


Cleaning up..

验证Mysql安装成功

[root@slave1 ~]# mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 12
Server version: 5.6.40 MySQL Community Server (GPL)

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.

mysql>

改变MySQL的字符编码问题

[root@slave1 ~]# vi /etc/my.cnf 

[client]
default-character-set =utf8
[mysqld]
character-set-server=utf8
collation-server=utf8_general_ci


[root@slave1 ~]# systemctl restart mysqld            //重启mysql服务就生效

[root@slave1 ~]# mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.6.40 MySQL Community Server (GPL)

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.

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.00 sec)

mysql>

至此Mysql安装成功（字符编码问题也解决了）




mysql5.7在线安装
yeyiboy的博客
02-16 432
一、mysql5.7在线安装 1、下载并安装MySQL官方的Yum Repository wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm/ 2、下载yum源 yum -y install mysql57-community-release-el7-10.noar...
CentOS7使用rpm包安装mysql 5.7.18
12-16
CentOS7默认安装MariaDB而不是MySQL，而且yum服务器上也移除了MySQL相关的软件包。因为MariaDB和MySQL可能会冲突，故先卸载MariaDB。 1、查看已安装的MariaDB相关rpm包。 rpm -qa | grep mariadb 2、查看已安装的...
mysql在线安装
Enginner_Yang的博客
08-20 353
mysql
MySql安装配置教程（超级详细）
最新发布
s050106的博客
04-06 1706
2. 选择安装的产品和功能依次点开“MySQL Servers”、“MySQL Servers”、“MySQL Servers 5.7”、“MySQL Servers 5.7.31 -64”，然后点击绿色箭头将选中的版本移植到右边选中框中。9. 先选中“MySQL Server5.7.31”，若电脑中没有这个环境，会提示安装“Microsoft Visual C++ 2013”环境，点击“Execute”5. 点击“新建”，将MySQL的安装路径添加上去，之后点击“确定”
mysql的安装、启动和基础配置 —— linux版本
dhx36675的博客
09-17 208
环境和资源地址 *** centos 7 *** http://repo.mysql.com/yum/mysql-5.6-community/ 安装 安装方式一（在线安装）： # 查看和mysql有关的安装包yum search mysql # 安装mysql社区版本yum源 yum -y install http://repo.mysql.com/yum/mysql-...
Mysql在线安装
weixin_34208283的博客
08-24 234
一、 检查系统中是否已安装了mysql服务或开发包依赖等 [bigdata@bigdata-pro02 ~]$ rpm -qa | grep mysql mysql-libs-5.1.73-3.el6_5.x86_64 如果检查存在一些安装包，则使用 rpm -e --nodeps [安装包1] [安装包2] [...] 将已有的安装包卸...
centos 7 MySQL8 离线一键自动安装脚本
04-06
对于Linux系统，尤其是CentOS 7这样的企业级发行版，MySQL的安装和管理至关重要。本文将详细讲解如何在CentOS 7上离线进行MySQL8的一键自动安装。 首先，离线安装意味着我们需要提前下载MySQL8的安装包，并通过本地...
centos7安装mysql5.7
01-10
在本地虚拟机的场合，需要更换yum安装网络地址配置文件CentOS-Base.repo 从阿里云服务器下载一份CentOS-Base.repo文件存到本地
mysql的在线安装
健康平安的活着的专栏
03-21 2497
一 mysql的在线安装 1.1 在线安装 1.在线安装mysql相关的软件包 yum install mysql mysql-server mysql-devel 2.启动mysql的服务 /etc/init.d/mysqld start 3.通过mysql安装自带脚本进行设置 /usr/bin/mysql_secure_installation 4.进入mysql的客户端进行授权 1.grant all privileges on *.* to 'root'@'%' identifie
在线安装mysql
QWERTY55555的专栏
07-19 479
官网地址：http://rocketmq.apache.org/docs/quick-start/
在线安装MySQL5.7
Noci_的博客
10-08 579
yum安装mysqlhttp://www.linuxidc.com/Linux/2016-09/135288.htm 在MySQL官网中下载YUM源rpm安装包：http://dev.mysql.com/downloads/repo/yum/ MySQL YUM源下载地址 #下载mysql源安装包 shell>wgethttp://dev.mysql.com/ge...
Linux环境---在线安装MYSQL数据库
qq_42390993的博客
06-07 2125
Linux环境---在线安装MYSQL数据库
MySQL 在线一键安装
weixin_44770684的博客
04-22 704
在线一键安装MySQL 8.0 在线一键安装MySQL 8.0 在线一键安装MySQL mysql在线安装 mysql生产级别优化 mysql系统优化
MySQL——在Linux环境下安装（在线安装）
hssjsh的博客
06-01 1817
MySQL——在Linux环境下安装（在线安装）
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值