关于centos6.7上安装mysql出现的异常

最新推荐文章于 2023-09-19 17:26:51 发布
最新推荐文章于 2023-09-19 17:26:51 发布
阅读量601 收藏
点赞数
分类专栏： linux 文章标签： centos mysql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/hhj724/article/details/52672381
版权

1.下载以下安装包：


2.先安装perl*

rpm -ivh perl*

3.安装mysql服务

rpm -ivh  MySQL-server-5.5.48-1.linux2.6.x86_64.rpm


可能报下面异常：

第一种：

[root@mini04 apps]# rpm -ivh MySQL-server-5.5.48-1.linux2.6.x86_64.rpm 
warning: MySQL-server-5.5.48-1.linux2.6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
error: Failed dependencies:
        libaio.so.1()(64bit) is needed by MySQL-server-5.5.48-1.linux2.6.x86_64
        libaio.so.1(LIBAIO_0.1)(64bit) is needed by MySQL-server-5.5.48-1.linux2.6.x86_64
        libaio.so.1(LIBAIO_0.4)(64bit) is needed by MySQL-server-5.5.48-1.linux2.6.x86_64

处理方法：

a.联网： yum install libaio

b.离线：安装libaio-0.3.107-10.el6.x86_64.rpm

下载地址：
http://mirror.centos.org/centos/6/os/x86_64/Packages/libaio-0.3.107-10.el6.x86_64.rpm
安装完成后，即可成功安装MySQL-server-5.5.48-1.linux2.6.x86_64.rpm 

第二种：

[root@mini04 apps]# rpm -ivh MySQL-server-5.5.48-1.linux2.6.x86_64.rpm 
warning: MySQL-server-5.5.48-1.linux2.6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                ########################################### [100%]
        file /usr/share/mysql/charsets/README from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/charsets/Index.xml from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/charsets/armscii8.xml from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/charsets/ascii.xml from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/charsets/cp1250.xml from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/charsets/cp1251.xml from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/charsets/cp1256.xml from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/charsets/cp1257.xml from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/charsets/cp850.xml from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/charsets/cp852.xml from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/charsets/cp866.xml from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/charsets/dec8.xml from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/charsets/geostd8.xml from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/charsets/greek.xml from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/charsets/hebrew.xml from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/charsets/hp8.xml from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/charsets/keybcs2.xml from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/charsets/koi8r.xml from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/charsets/koi8u.xml from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/charsets/latin1.xml from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/charsets/latin2.xml from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/charsets/latin5.xml from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/charsets/latin7.xml from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/charsets/macce.xml from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/charsets/macroman.xml from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/charsets/swe7.xml from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/czech/errmsg.sys from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/danish/errmsg.sys from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/dutch/errmsg.sys from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/english/errmsg.sys from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/estonian/errmsg.sys from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/french/errmsg.sys from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/german/errmsg.sys from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/greek/errmsg.sys from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/hungarian/errmsg.sys from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/italian/errmsg.sys from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/japanese/errmsg.sys from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/korean/errmsg.sys from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/norwegian-ny/errmsg.sys from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/norwegian/errmsg.sys from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/polish/errmsg.sys from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/portuguese/errmsg.sys from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/romanian/errmsg.sys from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/russian/errmsg.sys from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/serbian/errmsg.sys from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/slovak/errmsg.sys from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/spanish/errmsg.sys from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/swedish/errmsg.sys from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64
        file /usr/share/mysql/ukrainian/errmsg.sys from install of MySQL-server-5.5.48-1.linux2.6.x86_64 conflicts with file from package mysql-libs-5.1.73-5.el6_6.x86_64

解决方法：

查看版本冲突：

[root@mini04 apps]# rpm -qa|grep -i mysql
mysql-libs-5.1.73-5.el6_6.x86_64
[root@mini04 apps]# rpm -e --nodeps mysql-libs-5.1.73-5.el6_6.x86_64

[root@mini04 apps]# rpm -ivh MySQL-server-5.5.48-1.linux2.6.x86_64.rpm 

小努蛋
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论
专栏目录
Centos6.7系统安装MySQL5.7总结
09-28
Centos6.7系统安装MySQL5.7总结 本资源总结了在Centos6.7系统中安装MySQL5.7的步骤，包括下载和安装MySQL软件包，创建数据库仓库目录，新建MySQL用户和组，修改目录属有者，配置参数，修改系统配置文件，启动MySQL...
Centos6.7系统安装MySQL5.7
08-30
以上步骤详尽地介绍了在CentOS 6.7上安装MySQL 5.7.17的整个过程，包括下载、解压、配置、启动服务以及解决可能出现的问题。安装完成后，你可以开始使用MySQL进行数据库管理，创建数据库、表，以及执行SQL查询。如果...
在centos7下安装mysql遇到的报错
weixin_50339521的博客
07-26 464
在centos7环境下安装mysql的问题。
centOs安装mysql错误集合
qq_36751833的博客
10-30 207
1.cmake时报错要安装openssl包，yum install openssl-devel 2.重启虚拟机之后，卡在进度条那里进不去，解决办法： (1) 启动虚拟机，出现倒数321时，按e，然后进入 （2）接着按e，进入kernel （3）接着按e，进入 （4）可以删除rhgb quiet，加上rdshell，点击回车，点击b可以看到 （5）根据提示，重启进入kerne...
centos安装MySQL出现问题与解决
大灰狼的专栏
05-22 6010
我是直接运行命令： yum install mysql 然后 执行 mysql -uroot -p 报错：ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 执行命令：service mysqld start 报错： Redirect...
Centos7.5安装mysql遇到问题解决
qq_45199095的博客
01-30 375
解决方式：将Mysql安装目录下support-files文件夹里的mysql.server 复制到 /etc/init.d/mysql文件夹里就可以了。无 >> mysql服务未成功启动需重新启动mysql服务（因为这个文件是MySQL服务启动自动生成的文件）生成的路径配置在my.cnf文件中。这些解决办法都是我在安装过程中使用的，如果之后还是无法解决请另行搜索。首先查找虚拟机里是否有mysql.sock文件。有 >> 将文件设置一个软连接到报错路径里。
Error: Table ‘CTLGS‘ already exists (state=42S01,code=1050)问题解决
qq_45879579的博客
06-13 9480
Error: Table ‘CTLGS‘ already exists (state=42S01,code=1050) 问题一：在进入hive数据库进行操作时出现以下错误。 经过问题查找，原因是数据库没有进行初始化，所以退出hive进行数据库初始化，但在对数据库进行初始化时，出现问题二。 问题二；显示数据库初始化失败 所以随后又进行查找原因，原来是因为数据库已经存在，需要重新进入mysql进行删除数据库并对其重建 随后对元数据库进行初始化成功 再次进入hive进行操作，结果还是相同的错误，继续寻找错
centos6.7安装mysql5.5.48的方法
09-10
在CentOS 6.7操作系统上安装MySQL 5.5.48的步骤涉及几个关键环节，包括下载RPM包、解决可能的依赖冲突、安装服务以及配置启动服务。以下是详细的操作过程： 首先，你需要从MySQL的官方网站下载适用于CentOS 6.7的...
centos6.7安装mysql
05-18
centos6.7安装mysql详细全过程,若有疑问,欢迎联系交流!
Hive启动报错Error: Table ‘CTLGS’ already exists (state=42S01,code=1050)
最新发布
weixin_74143660的博客
09-19 1257
ctrl+d 退出mysql登录。
模型迁移错误常见问题”django.db.utils.InternalError: (1050, “Table ‘django_content_type’ already exists”)”
01-21
django迁移模型常见错误django.db.utils.InternalError: (1050, “Table ‘django_content_type’ already exists”)” 这个问题经常出现在迁移模型时报错，表示该表已经存在，说明之前进行过模型的迁移操作。 例如： 一般情况下出现这种错误，是因为在迁移过后进行了数据表的修改【字段的修改】，而再次进行数据表的迁移便会报错，因为之前该表已经存在，重复迁移。 解决办法： 1、先删除模块中迁移时生成的文件xxx_.initial.py文件 如： 0001_initial.py文件 注意：只删除该文件 2、然后依次输入以下命令
centos6 mysql 离线安装缺少的rpm包 libaio+numactl+perl
04-13
centos 6 minimal 离线安装mysql5.6 缺少的rpm依赖包，分别执行rpm -ivh 包名即可
记录一次hive包整体更新替换问题
qq_42437926的博客
03-05 546
hive3.1.2整体解压替换之前hive FAILED: HiveException java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.me错误 如果你整体解压替换后，你的hive的配置文件依旧是原来的，看起来好像没有问题，毕竟只是配置hive的mysql元数据之类的信息，但是报错 FAILED: HiveException java.lang.RuntimeException: Unable to in
Linux下安装mysql以及对应的配置（MYSQL高级调优周阳所需）
qq_41098689的博客
05-31 258
一、安装mysql 问题一:使用命令安装server 与client报依赖错误 错误：依赖检测失败： /usr/bin/perl 被 MySQL-server-5.5.48-1.linux2.6.i386 需要 libaio.so.1 被 MySQL-server-5.5.48-1.linux2.6.i386 需要 添加如下依赖: yum install libaio.so.1 yum install libncurses.so.5 yum install glibc.i686 yum
警告：MySQL-server-5.5.46-1.linux2.6.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY
klx502的专栏
12-15 2557
转自：https://yq.aliyun.com/articles/6742 摘要： CentOS安装rpm安装MySQL时爆出警告： 警告：MySQL-server-5.5.46-1.linux2.6.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY 原因：这是由于yum安装了旧版本的GPG key...
光盘挂载yum源
04-01 493
挂载光盘： mount -o ro /dev/cdrom /media/cdrom/ [root@localhost cdrom]# cat /etc/yum.repos.d/rhel.repo  [server] name=server baseurl=file:///media/cdrom/Server/ gpgcheck=0 enabled=1 挂载移动硬盘： moun
warning: MySQL-server-5.5.48-1.linux2.6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: N
Aaron960214的博客
11-05 3508
CentOS rpm安装Mysql时出现这样的错误：warning: MySQL-server-5.5.48-1.linux2.6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY error: Failed dependencies: /usr/bin/perl is needed by MySQL-ser
rpm安装mysql报错NOKEY_警告：MySQL-server-5.5.46-1.linux2.6.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1...
weixin_32571761的博客
01-30 235
CentOS安装rpm安装MySQL时爆出警告：警告：MySQL-server-5.5.46-1.linux2.6.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY原因：这是由于yum安装了旧版本的GPG keys造成的解决办法：后面加上--force --nodeps如：rpm -ivh MySQL-server-5.5.46-1...
MYSQL安装
xuanfengbo的专栏
04-23 153
一 安装前准备 1、检查是否已经安装过mysql，执行命令 [root@localhost /]# rpm -qa | grep mysql 从执行结果，可以看出我们已经安装了mysql-libs-5.1.73-5.el6_6.x86_64，执行删除命令 [root@localhost /]# rpm -e --nodeps mysql-libs-5.1.73-5.el6_6.x86_64 再次执行查询命令，查看是否删除 [root@localhost /]# rpm -qa |.
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

小努蛋

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

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

余额充值