centos7安装mysql

于 2024-05-26 16:24:03 发布
阅读量214 收藏
点赞数 2
分类专栏： linux 运维 文章标签： mysql 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/aihua002/article/details/139215985
版权

安装

1.下载rpm包

[root@server soft]# wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
--2024-05-26 00:47:10--  http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
Resolving repo.mysql.com (repo.mysql.com)... 92.122.81.156, 2a02:26f0:61:183::1d68, 2a02:26f0:61:18d::1d68
Connecting to repo.mysql.com (repo.mysql.com)|92.122.81.156|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 6140 (6.0K) [application/x-redhat-package-manager]
Saving to: ‘mysql-community-release-el7-5.noarch.rpm’

100%[==================>] 6,140       --.-K/s   in 0s      

2024-05-26 00:47:10 (662 MB/s) - ‘mysql-community-release-el7-5.noarch.rpm’ saved [6140/6140]

[root@server soft]# ls
mysql-community-release-el7-5.noarch.rpm

2.安装MySQL

[root@server soft]# yum install  -y  mysql-community-release-el7-5.noarch.rpm
Loaded plugins: fastestmirror, langpacks
Examining mysql-community-release-el7-5.noarch.rpm: mysql-community-release-el7-5.noarch
Marking mysql-community-release-el7-5.noarch.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-release.noarch 0:el7-5 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

============================================================
 Package
   Arch   Version
                Repository                             Size
============================================================
Installing:
 mysql-community-release
   noarch el7-5 /mysql-community-release-el7-5.noarch 4.3 k

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

Total size: 4.3 k
Installed size: 4.3 k
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : mysql-community-release-el7-5.noarch     1/1 
  Verifying  : mysql-community-release-el7-5.noarch     1/1 

Installed:
  mysql-community-release.noarch 0:el7-5                    

Complete!

3.安装MySQL服务端

[root@server soft]# yum install -y mysql-community-server
Loaded plugins: fastestmirror, langpacks
Loading mirror speeds from cached hostfile
mysql-connectors-community           | 2.6 kB     00:00     
mysql-tools-community                | 2.6 kB     00:00     
mysql56-community                    | 2.6 kB     00:00     
(1/3): mysql-connectors-community/x86_ | 114 kB   00:01     
(2/3): mysql-tools-community/x86_64/pr |  98 kB   00:01     
(3/3): mysql56-community/x86_64/primar | 297 kB   00:01     
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-server.x86_64 0:5.6.51-2.el7 will be installed
--> Processing Dependency: mysql-community-common(x86-64) = 5.6.51-2.el7 for package: mysql-community-server-5.6.51-2.el7.x86_64
--> Processing Dependency: mysql-community-client(x86-64) >= 5.6.10 for package: mysql-community-server-5.6.51-2.el7.x86_64
--> Processing Dependency: perl(DBI) for package: mysql-community-server-5.6.51-2.el7.x86_64
--> Processing Dependency: perl(Data::Dumper) for package: mysql-community-server-5.6.51-2.el7.x86_64
--> Running transaction check
---> Package mysql-community-client.x86_64 0:5.6.51-2.el7 will be installed
--> Processing Dependency: mysql-community-libs(x86-64) >= 5.6.10 for package: mysql-community-client-5.6.51-2.el7.x86_64
---> Package mysql-community-common.x86_64 0:5.6.51-2.el7 will be installed
---> Package perl-DBI.x86_64 0:1.627-4.el7 will be installed
--> Processing Dependency: perl(RPC::PlServer) >= 0.2001 for package: perl-DBI-1.627-4.el7.x86_64
--> Processing Dependency: perl(RPC::PlClient) >= 0.2000 for package: perl-DBI-1.627-4.el7.x86_64
---> Package perl-Data-Dumper.x86_64 0:2.145-3.el7 will be installed
--> Running transaction check
---> Package mariadb-libs.x86_64 1:5.5.68-1.el7 will be obsoleted
---> Package mysql-community-libs.x86_64 0:5.6.51-2.el7 will be obsoleting
---> Package perl-PlRPC.noarch 0:0.2020-14.el7 will be installed
--> Processing Dependency: perl(Net::Daemon) >= 0.13 for package: perl-PlRPC-0.2020-14.el7.noarch
--> Processing Dependency: perl(Net::Daemon::Test) for package: perl-PlRPC-0.2020-14.el7.noarch
--> Processing Dependency: perl(Net::Daemon::Log) for package: perl-PlRPC-0.2020-14.el7.noarch
--> Processing Dependency: perl(Compress::Zlib) for package: perl-PlRPC-0.2020-14.el7.noarch
--> Running transaction check
---> Package perl-IO-Compress.noarch 0:2.061-2.el7 will be installed
--> Processing Dependency: perl(Compress::Raw::Zlib) >= 2.061 for package: perl-IO-Compress-2.061-2.el7.noarch
--> Processing Dependency: perl(Compress::Raw::Bzip2) >= 2.061 for package: perl-IO-Compress-2.061-2.el7.noarch
---> Package perl-Net-Daemon.noarch 0:0.48-5.el7 will be installed
--> Running transaction check
---> Package perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7 will be installed
---> Package perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

============================================================
 Package                 Arch   Version       Repository
                                                       Size
============================================================
Installing:
 mysql-community-libs    x86_64 5.6.51-2.el7  mysql56-community
                                                      2.2 M
     replacing  mariadb-libs.x86_64 1:5.5.68-1.el7
 mysql-community-server  x86_64 5.6.51-2.el7  mysql56-community
                                                       67 M
Installing for dependencies:
 mysql-community-client  x86_64 5.6.51-2.el7  mysql56-community
                                                       21 M
 mysql-community-common  x86_64 5.6.51-2.el7  mysql56-community
                                                      287 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-Data-Dumper        x86_64 2.145-3.el7   base     47 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

Transaction Summary
============================================================
Install  2 Packages (+9 Dependent packages)

Total download size: 91 M
Downloading packages:
warning: /var/cache/yum/x86_64/7/mysql56-community/packages/mysql-community-common-5.6.51-2.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Public key for mysql-community-common-5.6.51-2.el7.x86_64.rpm is not installed
(1/11): mysql-community-common-5.6.51- | 287 kB   00:01     
(2/11): mysql-community-libs-5.6.51-2. | 2.2 MB   00:01     
(3/11): perl-Compress-Raw-Zlib-2.061-4 |  57 kB   00:00     
(4/11): perl-Compress-Raw-Bzip2-2.061- |  32 kB   00:00     
(5/11): perl-Data-Dumper-2.145-3.el7.x |  47 kB   00:00     
(6/11): perl-DBI-1.627-4.el7.x86_64.rp | 802 kB   00:01     
(7/11): perl-Net-Daemon-0.48-5.el7.noa |  51 kB   00:00     
(8/11): perl-PlRPC-0.2020-14.el7.noarc |  36 kB   00:00     
(9/11): perl-IO-Compress-2.061-2.el7.n | 260 kB   00:01     
(10/11): mysql-community-server-5.6.51 |  67 MB   00:31     
(11/11): mysql-community-client-5.6.51 |  21 MB   00:47     
------------------------------------------------------------
Total                          1.9 MB/s |  91 MB  00:47     
Retrieving key from file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Importing GPG key 0x5072E1F5:
 Userid     : "MySQL Release Engineering <mysql-build@oss.oracle.com>"
 Fingerprint: a4a9 4068 76fc bd3c 4567 70c8 8c71 8d3b 5072 e1f5
 Package    : mysql-community-release-el7-5.noarch (@/mysql-community-release-el7-5.noarch)
 From       : file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : mysql-community-common-5.6.51-2.el7.    1/12 
  Installing : perl-Data-Dumper-2.145-3.el7.x86_64     2/12 
  Installing : mysql-community-libs-5.6.51-2.el7.x8    3/12 
  Installing : mysql-community-client-5.6.51-2.el7.    4/12 
  Installing : perl-Compress-Raw-Bzip2-2.061-3.el7.    5/12 
  Installing : 1:perl-Compress-Raw-Zlib-2.061-4.el7    6/12 
  Installing : perl-IO-Compress-2.061-2.el7.noarch     7/12 
  Installing : perl-Net-Daemon-0.48-5.el7.noarch       8/12 
  Installing : perl-PlRPC-0.2020-14.el7.noarch         9/12 
  Installing : perl-DBI-1.627-4.el7.x86_64            10/12 
  Installing : mysql-community-server-5.6.51-2.el7.   11/12 
  Erasing    : 1:mariadb-libs-5.5.68-1.el7.x86_64     12/12 
  Verifying  : perl-Net-Daemon-0.48-5.el7.noarch       1/12 
  Verifying  : perl-Data-Dumper-2.145-3.el7.x86_64     2/12 
  Verifying  : mysql-community-libs-5.6.51-2.el7.x8    3/12 
  Verifying  : perl-IO-Compress-2.061-2.el7.noarch     4/12 
  Verifying  : mysql-community-server-5.6.51-2.el7.    5/12 
  Verifying  : 1:perl-Compress-Raw-Zlib-2.061-4.el7    6/12 
  Verifying  : mysql-community-common-5.6.51-2.el7.    7/12 
  Verifying  : perl-DBI-1.627-4.el7.x86_64             8/12 
  Verifying  : perl-Compress-Raw-Bzip2-2.061-3.el7.    9/12 
  Verifying  : perl-PlRPC-0.2020-14.el7.noarch        10/12 
  Verifying  : mysql-community-client-5.6.51-2.el7.   11/12 
  Verifying  : 1:mariadb-libs-5.5.68-1.el7.x86_64     12/12 

Installed:
  mysql-community-libs.x86_64 0:5.6.51-2.el7                
  mysql-community-server.x86_64 0:5.6.51-2.el7              

Dependency Installed:
  mysql-community-client.x86_64 0:5.6.51-2.el7              
  mysql-community-common.x86_64 0:5.6.51-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-Data-Dumper.x86_64 0:2.145-3.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                         

Replaced:
  mariadb-libs.x86_64 1:5.5.68-1.el7                        

Complete!

4.启动MySQL服务

[root@server soft]# systemctl start mysqld.service
[root@server soft]# systemctl status mysqld.service 
● mysqld.service - MySQL Community Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: active (running) since Sun 2024-05-26 00:50:36 PDT; 36s ago
  Process: 7276 ExecStartPost=/usr/bin/mysql-systemd-start post (code=exited, status=0/SUCCESS)
  Process: 7211 ExecStartPre=/usr/bin/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
 Main PID: 7275 (mysqld_safe)
    Tasks: 23
   CGroup: /system.slice/mysqld.service
           ├─7275 /bin/sh /usr/bin/mysqld_safe --basedir=...
           └─7441 /usr/sbin/mysqld --basedir=/usr --datad...

May 26 00:50:33 server mysql-systemd-start[7211]: 2024-05...
May 26 00:50:33 server mysql-systemd-start[7211]: 2024-05...
May 26 00:50:33 server mysql-systemd-start[7211]: 2024-05...
May 26 00:50:35 server mysql-systemd-start[7211]: 2024-05...
May 26 00:50:35 server mysql-systemd-start[7211]: PLEASE ...
May 26 00:50:35 server mysql-systemd-start[7211]: To do s...
May 26 00:50:35 server mysql-systemd-start[7211]: /usr/bi...
May 26 00:50:35 server mysqld_safe[7275]: 240526 00:50:35...
May 26 00:50:35 server mysqld_safe[7275]: 240526 00:50:35...
May 26 00:50:36 server systemd[1]: Started MySQL Communit...
Hint: Some lines were ellipsized, use -l to show in full.

5.查看端口

[root@server soft]# netstat -na | grep 3306
tcp6       0      0 :::3306                 :::*                    LISTEN

6.查看MySQL进程

[root@server soft]# ps -ef | grep mysql
mysql      7275      1  0 00:50 ?        00:00:00 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
mysql      7441   7275  0 00:50 ?        00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock
root       7634   1540  0 00:59 pts/0    00:00:00 grep --color=auto mysql

梦中北山
关注
  • 2
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Centos7 远程无法连接mysql数据库
兜兜的博客
09-19 2777
以下方法就是我在碰到远程连接不到Mysql数据库后试过的方法，最终也是解决掉了问题。所以总结一下。有两种原因 数据库没有授权 服务器防火墙没有开放3306端口 数据库没有授权对于mysql数据库没有授权，只需要用一条命令就可以了。mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPT
【MySQL】MySQL在Centos7环境下安装
须知少日拏云志，曾许人间第一流。
07-16 1万+
关于配置mysql环境以及如何登录。
CentOS7 --- 安装MySQL
qq_57151931的博客
11-30 8216
CentOS7 --- 安装MySQL
Linux王者CentOS7极简入门：7小时让你从凡人进阶筑基强者！
03-02
本套课程设计为零基础快速入门Linux操作系统系列课程，课程以讲解CentOS7版本为蓝本，讲解Linux常用的知识点。主打帮助同学快速上手Linux，能在工作中快速使用。课程内容包括:1>linux历史2>linux系统安装3>linux常用命令4>linux中vi编辑器5>linux权限管理6>linux系统服务管理7>linux网路管理8>linux软件安装9>war类型项目部署10>SpringBoot项目部署
【MySQL系列】在Centos7环境安装MySQL
枫叶先生的博客
07-05 1万+
文章内容大致是在Centos7环境安装MySQL，演示安装的版本为5.7。
CentOS 7 安装 MySQL
06-27
CentOS 7 安装 MySQL
centos7 安装 Mysql 5
08-23
CentOS 7 安装 MySQL 5.7.27 详细教程 本文档详细讲解了在 CentOS 7 操作系统上安装 MySQL 5.7.27 的步骤，包括下载 MySQL yum 包、安装 MySQL 源、安装 MySQL 服务端、启动 MySQL 服务、检查 MySQL 服务状态、获取...
CentOS7安装MySQL8.0图文教程
11-30
CentOS7 安装 MySQL8.0 图文教程 本文将指导读者在 CentOS7 系统中安装 MySQL 8.0，以下是安装过程中需要注意的知识点： 1. 下载 MySQL 安装包：在 MySQL 官方网站下载 MySQL 8.0 安装包，选择 Red Hat 作为操作...
CentOS7安装MySQL教程
08-25
### CentOS7安装MySQL教程 #### 一、简介 在Linux环境下安装MySQL数据库是常见的系统管理任务之一。本文将详细介绍如何在CentOS 7系统上安装MySQL，并提供一系列实用的命令来帮助用户完成整个过程。 #### 二、...
Centos7安装mysql8.0压缩包.docx
12-01
"Centos7安装mysql8.0压缩包" 本文档详细介绍了在Centos7系统上安装mysql8.0的步骤，包括卸载系统自带的mariadb，安装mysql依赖项，上传和解压mysql压缩包，创建安装目录、mysql用户和组，创建数据目录和配置文件，...
CentOS7安装MySQL（完整版）
热门推荐
Bejpse的博客
08-14 3万+
在CentOS中默认安装有MariaDB，这个是MySQL的分支，但为了需要，还是要在系统中安装MySQL，而且安装完成之后可以直接覆盖掉MariaDB。
Centos7安装MySql（超详细）
ptlipeng的博客
05-27 6699
Centos7安装MySql（压缩包解压）,
【MySQL】在 Centos7 环境安装 MySQL -- 详细完整教程
Elena's Blog
02-05 1万+
mariadb 其实就是 mysql，只不过是 mysql 的另一种拉出来的开源分支，也可以正常使用，如果不想卸载也是可以的。一开始的时候我们安装的 yum，在安装完之后是可以选择删除的，因为每次 yum 操作都会更新一次，耗费时间。使用临时密码登录后，不能进行其他的操作，否则会报错，这时候我们进行修改密码操作。这时候我们就可以自己设置想要的密码了。
MySQL如何在Centos7环境安装：简易指南
这是一个非常有意思的博主
06-25 3816
掌握数据之道，从MySQL开始！解锁CentOS 7上安装MySQL的秘诀，让你的数据管理飞速升级！快来探索如何轻松搭建高效、可靠的数据库环境，驾驭数据的无限潜力！立即迈向MySQL的世界，开启数据之旅！
【MYSQL】—— MySQL 在 Centos 7环境安装
m0_56069910的博客
06-25 5725
mysql 的安装操作
手把手教你CentOS7安装MySql（超详细）
m0_67391120的博客
04-28 2万+
目录 前言 软件准备 检查MySQL是否安装及版本信息 卸载 1、rpm格式安装的mysql卸载方式 2、二进制包格式安装的mysql卸载 安装 1、安装客户端 2、安装服务端 目录结构 数据库基本操作 1、查看状态 2、启动 3、重启 4、停止 5、自启动 密码修改（CentOS 7版） 测试登录 数据库配置 1、基础设置 登录授权 前言 目前MySQL数据库按用户群分为社区版(Community Server)和企业版(Enterprise/commercial)。–commercial授权版本 社区
在CentOS7中安装MySQL
最新发布
Vinca@的博客
04-15 1374
RPM(Red-Hat Package Manager)RPM软件包管理器，是红帽Linux用于管理和安装软件的工具注意事项如果当前系统中已经安装有MVSOL数据库，安装将失败。Cent0s7自带mariadb，与MVSOL数据库冲突。
CentOS7 安装MySQL
jeikerxiao
05-16 2768
1. 创建安装目录1.进入到目录 /usr/ 中：$ cd /usr/2.创建目录 /usr/software，如果有则忽略： $ mkdir -p software3.创建 /usr/software/mysql 目录，如果已存在则忽略：$ mkdir -p mysql4.进入到目录 /usr/software/中：$ cd /usr/software2.查看是否已安装1.查看系统中是否已安装 M
CentOS7安装mysql
09-02
- *1* *2* *3* [Centos7安装MySQL详细步骤](https://blog.csdn.net/Bb15070047748/article/details/106245223)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值