CentOS-7安装MySQL

最新推荐文章于 2023-03-26 00:56:15 发布
原创 最新推荐文章于 2023-03-26 00:56:15 发布 · 379 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#MySQL #CentOS #RPM #历史

本文介绍如何从MySQL官网获取指定版本的下载链接，并提供详细的下载、解压及安装步骤。此外，还介绍了如何解决安装过程中遇到的依赖冲突问题，以及如何修改root用户的默认密码。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

网易镜像

http://ftp.ntu.edu.tw/MySQL/Downloads/MySQLInstaller/

一、MySQL官网获取下载地址

当我们需要安装MySQL的某一个版本的时候，访问MySQL的官网：https://www.mysql.com/->DOWNLOADS->Archives->MySQL Community Server，选择版本，操作系统，操作系统版本，下载RPM Bundle。这个时候获取到 下载 地址：https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.20-1.el7.x86_64.rpm-bundle.tar

二、下载和解压

wget -c https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.20-1.el7.x86_64.rpm-bundle.tar

tar vxf mysql-5.7.20-1.el7.x86_64.rpm-bundle.tar

解压后的文件RPM文件列表：

mysql-community-libs-5.7.20-1.el7.x86_64.rpm
mysql-community-client-5.7.20-1.el7.x86_64.rpm
mysql-community-libs-compat-5.7.20-1.el7.x86_64.rpm
mysql-community-common-5.7.20-1.el7.x86_64.rpm
mysql-community-minimal-debuginfo-5.7.20-1.el7.x86_64.rpm
mysql-community-devel-5.7.20-1.el7.x86_64.rpm
mysql-community-server-5.7.20-1.el7.x86_64.rpm
mysql-community-embedded-5.7.20-1.el7.x86_64.rpm
mysql-community-server-minimal-5.7.20-1.el7.x86_64.rpm
mysql-community-embedded-compat-5.7.20-1.el7.x86_64.rpm
mysql-community-test-5.7.20-1.el7.x86_64.rpm

mysql-community-embedded-devel-5.7.20-1.el7.x86_64.rpm

三、安装

yum localinstall mysql-community-common-5.7.20-1.el7.x86_64.rpm

yum localinstall mysql-community-libs-5.7.20-1.el7.x86_64.rpm

yum localinstall mysql-community-client-5.7.20-1.el7.x86_64.rpm

yum localinstall mysql-community-server-5.7.20-1.el7.x86_64.rpm

当安装common的时候，遇到冲突的时候用yum remove mariadb-libs-1:5.5.56-2.el7.x86_64或者rpm -e mariadb-libs-1:5.5.56-2.el7.x86_64卸载冲突包。

[x@localhost ~]$ sudo yum localinstall mysql-community-common-5.7.20-1.el7.x86_64.rpm 
[sudo] password for x: 
Loaded plugins: fastestmirror
Examining mysql-community-common-5.7.20-1.el7.x86_64.rpm: mysql-community-common-5.7.20-1.el7.x86_64
Marking mysql-community-common-5.7.20-1.el7.x86_64.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-common.x86_64 0:5.7.20-1.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

=========================================================================================================================================
 Package                          Arch             Version                   Repository                                             Size
=========================================================================================================================================
Installing:
 mysql-community-common           x86_64           5.7.20-1.el7              /mysql-community-common-5.7.20-1.el7.x86_64           2.5 M

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

Total size: 2.5 M
Installed size: 2.5 M
Is this ok [y/d/N]: y
Downloading packages:
Running transaction check
Running transaction test


Transaction check error:
  file /usr/share/mysql/czech/errmsg.sys from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64
  file /usr/share/mysql/danish/errmsg.sys from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64
  file /usr/share/mysql/dutch/errmsg.sys from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64
  file /usr/share/mysql/english/errmsg.sys from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64
  file /usr/share/mysql/estonian/errmsg.sys from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64
  file /usr/share/mysql/french/errmsg.sys from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64
  file /usr/share/mysql/german/errmsg.sys from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64
  file /usr/share/mysql/greek/errmsg.sys from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64
  file /usr/share/mysql/hungarian/errmsg.sys from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64
  file /usr/share/mysql/italian/errmsg.sys from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64
  file /usr/share/mysql/japanese/errmsg.sys from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64
  file /usr/share/mysql/korean/errmsg.sys from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64
  file /usr/share/mysql/norwegian-ny/errmsg.sys from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64
  file /usr/share/mysql/norwegian/errmsg.sys from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64
  file /usr/share/mysql/polish/errmsg.sys from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64
  file /usr/share/mysql/portuguese/errmsg.sys from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64
  file /usr/share/mysql/romanian/errmsg.sys from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64
  file /usr/share/mysql/russian/errmsg.sys from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64
  file /usr/share/mysql/serbian/errmsg.sys from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64
  file /usr/share/mysql/slovak/errmsg.sys from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64
  file /usr/share/mysql/spanish/errmsg.sys from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64
  file /usr/share/mysql/swedish/errmsg.sys from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64
  file /usr/share/mysql/ukrainian/errmsg.sys from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64
  file /usr/share/mysql/charsets/Index.xml from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64
  file /usr/share/mysql/charsets/armscii8.xml from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64
  file /usr/share/mysql/charsets/ascii.xml from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64
  file /usr/share/mysql/charsets/cp1250.xml from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64
  file /usr/share/mysql/charsets/cp1256.xml from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64
  file /usr/share/mysql/charsets/cp1257.xml from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64
  file /usr/share/mysql/charsets/cp850.xml from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64
  file /usr/share/mysql/charsets/cp852.xml from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64
  file /usr/share/mysql/charsets/cp866.xml from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64
  file /usr/share/mysql/charsets/dec8.xml from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64
  file /usr/share/mysql/charsets/geostd8.xml from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64
  file /usr/share/mysql/charsets/greek.xml from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64
  file /usr/share/mysql/charsets/hebrew.xml from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64
  file /usr/share/mysql/charsets/hp8.xml from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64
  file /usr/share/mysql/charsets/keybcs2.xml from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64
  file /usr/share/mysql/charsets/koi8r.xml from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64
  file /usr/share/mysql/charsets/koi8u.xml from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64
  file /usr/share/mysql/charsets/latin1.xml from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64
  file /usr/share/mysql/charsets/latin2.xml from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64
  file /usr/share/mysql/charsets/latin5.xml from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64
  file /usr/share/mysql/charsets/latin7.xml from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64
  file /usr/share/mysql/charsets/macce.xml from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64
  file /usr/share/mysql/charsets/macroman.xml from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64
  file /usr/share/mysql/charsets/swe7.xml from install of mysql-community-common-5.7.20-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.56-2.el7.x86_64

Error Summary
-------------

 

[x@localhost ~]$ sudo yum remove mariadb-libs-1:5.5.56-2.el7.x86_64
Loaded plugins: fastestmirror
Resolving Dependencies
--> Running transaction check
---> Package mariadb-libs.x86_64 1:5.5.56-2.el7 will be erased
--> 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: 2:postfix-2.10.1-6.el7.x86_64
--> Running transaction check
---> Package postfix.x86_64 2:2.10.1-6.el7 will be erased
--> Finished Dependency Resolution

Dependencies Resolved

=========================================================================================================================================
 Package                           Arch                        Version                              Repository                      Size
=========================================================================================================================================
Removing:
 mariadb-libs                      x86_64                      1:5.5.56-2.el7                       @anaconda                      4.4 M
Removing for dependencies:
 postfix                           x86_64                      2:2.10.1-6.el7                       @anaconda                       12 M

Transaction Summary
=========================================================================================================================================
Remove  1 Package (+1 Dependent package)

Installed size: 17 M
Is this ok [y/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Erasing    : 2:postfix-2.10.1-6.el7.x86_64                                                                                         1/2 
  Erasing    : 1:mariadb-libs-5.5.56-2.el7.x86_64                                                                                    2/2 
  Verifying  : 1:mariadb-libs-5.5.56-2.el7.x86_64                                                                                    1/2 
  Verifying  : 2:postfix-2.10.1-6.el7.x86_64                                                                                         2/2 

Removed:
  mariadb-libs.x86_64 1:5.5.56-2.el7                                                                                                     

Dependency Removed:
  postfix.x86_64 2:2.10.1-6.el7                                                                                                          

Complete!

三、修改root本地密码

 

mysql安装完成之后，在/var/log/mysqld.log文件中给root生成了一个默认密码。通过下面的方式找到root默认密码，然后登录mysql进行修改：

grep 'temporary password' /var/log/mysqld.log

进入MySQL：

mysql -u root -p

查看密码策略

show variables like '%password%'

设置密码策略：

set global validate_password_policy=0;

查看密码策略：

select @@validate_password_policy;

设置密码长度：

set global validate_password_length=4;

查看密码长度：

select @@validate_password_length;

然后你就可以将你的密码改为简单的密码。

alter user 'root'@'localhost' identified by '123456';

或者

set password for 'root'@'localhost'='123456';

此set password for 'root'@'localhost'=password('123456');命令将被弃用。

允许远程访问

grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;

grant all on *.* to 'root'@'%';

其中123456为你的访问密码。

CentOS-7安装MySQL-8 本地tar包安装
u013526297的博客
03-03 1734
从MySQL官网下载安装bundle包MySQL :: Download MySQL Community Serverhttps://dev.mysql.com/downloads/mysql/ 2.检查centos 7 中的mariadb包,存在> 卸载该包,再检查可见已经卸载干 rpm -qa|grep mariadb rpm -e mariadb-libs-5.5.65-1.el7.x86_64 --nodeps rpm -qa| grep mariadb 3. 本地下载..
【MySQL】在 Centos7 环境安装 MySQL -- 详细完整教程
ADFVBM的博客
12-27 1489
mariadb 其实就是 mysql，只不过是 mysql 的另一种拉出来的开源分支，也可以正常使用，如果不想卸载也是可以的。安装 MySQL 源：rpm -Uvh mysql57-community-release-el7-10.noarch.rpm。安装 MySQL 服务端，需要等待一些时间：yum install -y mysql-community-server。通过临时密码登录 MySQL，进行修改密码操作：mysql -uroot -p。这时候我们就可以自己设置想要的密码了。
yum停留在Running Transaction Test不动的解决办法
weixin_33788244的博客
12-03 1519
# rm -f/var/lib/rpm/__db.*# yum clean all# rpm -v -v rebuilddb如果执行以上操作还出现同样问题，则执行# strace yum -yinstall ppp发现在读取/home/schoolba/public_html/file这目录就停止了于是知道了是nft挂载的目录出了问题，于是利用umount /home/sc...
CentOS8.2安装 Mysql5.7出现包冲突。file /etc/my.cnf from install of mysql-community-server conflicts with
你来当垫子的博客
01-21 4553
环境：CentOS8.2 安装Mysql 5.7 安装包来源:http://repo.mysql.com/yum/mysql-5.7-community/el/7/x86_64 参考 博客园：三度 优快云：不要再说了哇 依次安装mysql的common、lib、client的时候都没有问题。 安装server的时候出现一下问题 Downloading Packages: Running transaction check Transaction check succeeded. Running trans
RHCSA 08 - automount配置
IT基础架构
07-02 437
前言目录按需挂载，空闲时自动卸载，可以采用automount技术。尤其是在大型HPC环境，成千上万的用户家目录，使用automount降低seek time，提高dentry缓存命中率，可大大节省内存资源。环境RHEL 8实践安装nfs-utils，它提供nfs server， 创建目录并导出，启动nfs server， 在客户端，安装autofs， 参考/misc配置项，对家目录进行配置，并启动autofs服务， 检查/home/nfs目录，没有任何文件（夹）， 触发一下其中一个子目录
CentOS 7 源码安装Zabbix 5.0 LTS
UsamaBinLaden6976498的专栏
06-02 2994
Zabbix监控系统的Web采用PHP编写而成，需要安装PHP动态解析组件，并用PHP操作数据库。httpd与PHP的交互式通过php-fpm完成的，需要在httpd服务的配置文件中开启FastCGI。 Zabbix 5.0 LTS于2020年5月发布第一个更新，Zabbix 5.0的部署安装不同于之前的1、2、3、4大版本，改动比较大。目前发现的是Zabbix前端安装配置与之前的大版本有较大的区别，以下是源码编译安装的踩坑过程： 安装完毕CentOS71908后，先做OS环境初始化，执行脚本如下：
mysql记录下
weixin_37477226的博客
04-09 810
Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile Resolving Dependencies –> Running transaction check —> Package wget.x86_64 0:1.14-18.el7 will be installed –> Finished...
centos7安装mysql5.7
01-10
在本地虚拟机的场合，需要更换yum安装网络地址配置文件CentOS-Base.repo 从阿里云服务器下载一份CentOS-Base.repo文件存到本地
centos7离线安装mysql8.0.41 rpm所需依赖包
最新发布
03-21
centos7离线安装mysql8.0.41 rpm所需依赖包 ，其中由于mysql的一个test rpm包依赖较多，不进行安装，其他都可以。另外包含percona-toolkit-3.6.0 和xtrabackup 8.0.35所需的依赖包。
centos7 安装 Mysql 5.7.28，详细完整教程
08-10
CentOS 7 安装 MySQL 5.7.28 详细完整教程 MySQL 是一种关系型数据库管理系统，广泛应用于各种 Web 应用程序中。在本教程中，我们将详细介绍如何在 CentOS 7 中安装 MySQL 5.7.28。 知识点1：下载 MySQL 源 在...
yum卡在Running Transaction Testde
yang.zhou欢迎各位
10-28 2133
真是奇怪，yum今天出了怪问题。一直卡在Running Transaction Testde，然后就按啥都不好使了。有点类似这样： … Running rpm_check_debug  Running Transaction Test   #yum clean all 是没有用滴，谷歌一下，这个帖子给我启示： http://forums.fedora
记一次CentOS 8 部署packstack部署OpenStack失败案例，请直接看最后
啊酒弟弟的博客
03-26 2021
首先你需要一台安装好CentOS8 的虚拟机，相关参数如图。两块网卡，网卡1 NAT IP 192.168.100.100 GW=192.168.100.2 网卡2 可不做配置。能ping通百度。创建完成虚拟机记得打好快照。开机编辑基本配置环境变量连接已成功激活（D-Bus 活动路径：/org/freedesktop/NetworkManager/ActiveConnection/6）
yum remove 卡在Running Transaction Test
zhuxiaoliao的专栏
07-21 2903
在RHCS上搭建HA后，由于网路发生转换，在系统日志中不间断的提示fence XXX failed（节点的网段不一致，导致脑裂）； 由于HA已经弃用，但是强迫症明显，非要卸载！ yum remove luci ricci cman openais rgmanager lvm2-cluster gfs2-utils -y yum remove cluster-glue resource-a
php mysql 版本_安装php-mysql时遇到mysql版本兼容问题
weixin_39816062的博客
01-18 346
机子是centOS6.5，于是首先查看软件库中有没有扩展：yum search php-mysql既然有那就开始安装扩展吧：yum install php-mysqldang，出现了如下错误Transaction Check Error:file /usr/share/mysql/charsets/Index.xml from install of mysql-libs-5.1.73-8.el6_...
Transaction check error: file /usr/bin/kubectl from install of kubectl-1.23.4-0.x86_64 conflicts
qq_35916454的博客
03-17 2574
安装k8s时遇到的问题： # yum -y install kubectl 提示如下： 已加载插件：fastestmirror, langpacks, product-id, search-disabled-repos, subscription-manager This system is not registered with an entitlement server. You can use subscription-manager to register. Loading mirr
Transaction Check Error错误
用心做事
03-02 8259
ransaction Check Error: file /usr/share/man/man3/XML::SAX::Base.3pm.gz conflicts between attempted installs of perl-XML-SAX-0.96-7.el6.noarch and perl-XML-SAX-Base-1.04-1.el6.rf.noarch file /usr
第十二天学习linux
weixin_42296147的博客
01-31 2221
第十二天 9.1 配置网卡服务 9.1.1 配置网卡参数 截至目前，大家已经完全可以利用当前所学的知识来管理Linux系统了。当然，大家的水平完全可以更进一步，当有朝一日登顶技术巅峰时，您一定会感谢现在正在努力学习的您。 我们接下来将学习如何在Linux系统上配置服务。但是在此之前，必须先保证主机之间能够顺畅地通信。如果网络不通，即便服务部署得再正确用户也无法顺利访问，所以，配置网络并确保网络的连通性是学习部署Linux服务之前的最后一个重要知识点。 nmtui命令来配置网络 在RHEL 5、RHEL 6系
CentOS-6.6下MySQL-5.6编译安装与主从复制教程
在本篇中，我们将重点讨论如何在CentOS-6.6操作系统上编译安装MySQL-5.6版本，并配置MySQL的主从复制功能。这些操作是数据库管理员日常维护工作中的关键技能。 ### MySQL编译安装 首先，我们需要明白编译安装MySQL...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值