wget mysql 5.6_一看必会系列:mysql 5.5版本升级到mysql 5.6版本

最新推荐文章于 2022-12-01 17:29:48 发布
最新推荐文章于 2022-12-01 17:29:48 发布
阅读量142 收藏
点赞数
文章标签： wget mysql 5.6
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_39851048/article/details/113168075
版权

1.停用应用

2.备用所有库

3.增加源

yum -y install gcc gcc-c++ make cmake automake autoconf libxml2 libxml2-devel zlib zlib-devel ncurses ncurses-devel

yum -y install libaio libaio-devel net-tools wget

4.在线升级

5.备用方案。卸载后再安装，再导入数据

6.回退方案

——–正确的安装过程

[root@localhost ~]# rpm -ivh mysql-community-client-5.5.35-2.el7.x86_64.rpm

Preparing…                          ################################# [100%]

Updating / installing…

1:mysql-community-client-5.5.35-2.e################################# [100%]

error: unpacking of archive failed on file /usr/bin/mysqlcheck;5a97f082: cpio: read

error: mysql-community-client-5.5.35-2.el7.x86_64: install failed

[root@localhost ~]# rpm -ivh mysql-community-client-5.5.35-2.el7.x86_64.rpm

Preparing…                          ################################# [100%]

Updating / installing…

1:mysql-community-client-5.5.35-2.e################################# [100%]

[root@localhost ~]#

[root@localhost ~]#

[root@localhost ~]#

[root@localhost ~]# rpm -ivh mysql-community-server-5.5.35-2.el7.x86_64.rpm

Preparing…                          ################################# [100%]

Updating / installing…

1:mysql-community-server-5.5.35-2.e################################# [100%]

[root@localhost ~]# systemctl status mysql

Unit mysql.service could not be found.

[root@localhost ~]# systemctl status mysqld

● mysqld.service – MySQL Community Server

Loaded: loaded (/usr/lib/systemd/system/mysqld.service; disabled; vendor preset: disabled)

Active: inactive (dead)

[root@localhost ~]# systemctl restart mysqld

———–登陆测试

[root@localhost ~]# mysql -u root -p

Enter password:

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 2

Server version: 5.5.35 MySQL Community Server (GPL)

Copyright (c) 2000, 2013, 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>

——————–5.5.45到5.6.34 升级过程

报错

[root@localhost ~]# rpm -ivh mysql-community-common-5.6.34-2.el7.x86_64.rpm

warning: mysql-community-common-5.6.34-2.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY

Preparing…                          ################################# [100%]

file /usr/share/mysql/errmsg-utf8.txt from install of mysql-community-common-5.6.34-2.el7.x86_64 conflicts with file from package mysql-community-common-5.5.35-2.el7.x86_64

解决  先卸载   mysql-community-common-5.5.35-2.el7.x86_64

[root@localhost ~]# rpm -qa |grep mysql

mysql-community-common-5.5.35-2.el7.x86_64

mysql-community-client-5.5.35-2.el7.x86_64

mysql-community-libs-5.5.35-2.el7.x86_64

mysql-community-server-5.5.35-2.el7.x86_64

[root@localhost ~]# yum remove mysql-community-common-5.5.35-2.el7.x86_64

Removed:

mysql-community-common.x86_64 0:5.5.35-2.el7

Dependency Removed:

mysql-community-client.x86_64 0:5.5.35-2.el7       mysql-community-libs.x86_64 0:5.5.35-2.el7       mysql-community-server.x86_64 0:5.5.35-2.el7

Complete!

开始安装

[root@localhost ~]# rpm -ivh mysql-community-common-5.6.34-2.el7.x86_64.rpm

warning: mysql-community-common-5.6.34-2.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY

Preparing…                          ################################# [100%]

Updating / installing…

1:mysql-community-common-5.6.34-2.e################################# [100%]

[root@localhost ~]# rpm -ivh mysql-community-client-5.6.34-2.el7.x86_64.rpm

warning: mysql-community-client-5.6.34-2.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY

error: Failed dependencies:

mysql-community-libs(x86-64) >= 5.6.10 is needed by mysql-community-client-5.6.34-2.el7.x86_64

[root@localhost ~]# rpm -ivh mysql-community-libs-5.6.34-2.el7.x86_64.rpm

warning: mysql-community-libs-5.6.34-2.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY

Preparing…                          ################################# [100%]

Updating / installing…

1:mysql-community-libs-5.6.34-2.el7################################# [100%]

[root@localhost ~]# rpm -ivh mysql-community-client-5.6.34-2.el7.x86_64.rpm

warning: mysql-community-client-5.6.34-2.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY

Preparing…                          ################################# [100%]

Updating / installing…

1:mysql-community-client-5.6.34-2.e################################# [100%]

[root@localhost ~]# rpm -ivh mysql-community-server-5.6.34-2.el7.x86_64.rpm

warning: mysql-community-server-5.6.34-2.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY

Preparing…                          ################################# [100%]

Updating / installing…

1:mysql-community-server-5.6.34-2.e################################# [100%]

[root@localhost ~]#

[root@localhost ~]#

[root@localhost ~]#

[root@localhost ~]#

启动

systemctl restart  mysqld.service

[root@localhost ~]# !mysql

mysql -u root

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 2

Server version: 5.6.34 MySQL Community Server (GPL)  —————————验证版本正确，数据都在

Copyright (c) 2000, 2016, 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 databases;

+——————–+

| Database           |

+——————–+

| information_schema |

| bass               |

| budget             |

| mysql              |

| performance_schema |

| test               |

+——————–+

6 rows in set (0.05 sec)

mysql>

——-安装失败

[root@localhost ~]# rpm -ivh mysql-community-server-5.5.35-2.el7.x86_64.rpm

error: Failed dependencies:

mysql-community-client(x86-64) = 5.5.35-2.el7 is needed by mysql-community-server-5.5.35-2.el7.x86_64

[root@localhost ~]# rpm -ivh mysql-community-client-5.5.35-2.el7.x86_64.rpm

Preparing…                          ################################# [100%]

Updating / installing…

1:mysql-community-client-5.5.35-2.e################################# [100%]

error: unpacking of archive failed on file /usr/bin/mysqlcheck;5a97f082: cpio: read

error: mysql-community-client-5.5.35-2.el7.x86_64: install failed    ——-安装包损坏，重新下载

[root@localhost ~]#

———–报错

[root@localhost ~]# rpm -ivh mysql-community-server-5.5.35-2.el7.x86_64.rpm

error: Failed dependencies:

mysql-community-client(x86-64) = 5.5.35-2.el7 is needed by mysql-community-server-5.5.35-2.el7.x86_64

mysql-community-common(x86-64) = 5.5.35-2.el7 is needed by mysql-community-server-5.5.35-2.el7.x86_64

net-tools is needed by mysql-community-server-5.5.35-2.el7.x86_64

perl(DBI) is needed by mysql-community-server-5.5.35-2.el7.x86_64

————解决

按顺序安装

mysql-community-common

mysql-community-libs

mysql-community-client

mysql-community-server

net-tools is needed by mysql-community-server-5.5.35-2.el7.x86_64

perl(DBI) is needed by mysql-community-server-5.5.35-2.el7.x86_64

[root@localhost ~]# yum install -y net-tools  perl-DBI

———-解决

mysql-community-client(x86-64) = 5.5.35-2.el7 is needed by mysql-community-server-5.5.35-2.el7.x86_64

mysql-community-common(x86-64) = 5.5.35-2.el7 is needed by mysql-community-server-5.5.35-2.el7.x86_64

——–如有冲突

删除原有mariadb

[root@localhost ~]# rpm -qa |grep mariadb

mariadb-libs-5.5.52-1.el7.x86_64

[root@localhost ~]# yum remove -ymariadb-libs-5.5.52-1.el7.x86_64

weixin_39851048
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Mysql5.6安装
qq_36709906的博客
09-22 735
1.删除和安装必要的插件 yum remove mysql-libs yum install libaio yum -y install autoconf yum -y install wget 2.下载包并安装 wget https://downloads.mysql.com/archives/get/p/23/file/MySQL-shared-compat-5.6.24-1.el6.x86_64.rpm wget https://downloads.mysql.com/archives/get/p/
ubuntu下mysql版本升级到5.7
12-15
最后，如果你需要从其他版本（如5.5或5.6）升级到5.7，除了上述步骤，可能还需要处理特定的兼容性问题，比如修改存储引擎、优化配置参数等。务必查阅MySQL的官方文档以获取详细指导。 总之，升级MySQL数据库需要...
mysql安装
zssz1026的专栏
05-14 243
1.下载mysql源安装包 $ wgethttp://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm 2.安装mysql源 $yum localinstall mysql57-community-release-el7-8.noarch.rpm 3.检查mysql源是否安装成功 $yum repolist enabled | grep "mysql.*-community.*" 4.修改yum源...
linux 安装mysql-5.6
u012389669的专栏
09-04 789
mysql在linux下的安装 如有问题可联系本人qq，加qq请备注来源（1666464075） 1、下载 　　　　下载地址：https://dev.mysql.com/downloads/mysql/ 　　　　下载版本：我这里选择的5.6.41，通用版，linux下64位 2、解压 　　　#进入指定目录                 [root@jameszhou mysql-5...
mariadb mysql 5.6_MySQL / MariaDB 5.5 升级到 MySQL 5.6
weixin_34625578的博客
02-26 362
RHEL 及 CentOS 7 默认的资库系统是 MariaDB 5.5 (等同 MySQL 5.5), 虽然现时 MySQL 最新版是 5.7, 但一般上升级都建议一级一级上, 而 MySQL 5.6 比 5.5 也提高了效能及提供更多功能, 以下是在 RHEL 及 CentOS 从原来的 MySQL 5.5 或 MariaDB 5.5, 升级到 MySQL 5.6 的步骤。1. 备份 MySQ...
wget mysql5.7.19_MySQL 5.7.19 CentOS 7 安装
weixin_35298139的博客
01-25 73
Linux的版本有很多，因此下载mysql时，需要注意下载对应Linux版本的MySql数据库文件。以下方法也适合centOS 7 的mysql 5.7.* 版本的安装。安装方法我整理为16步。1：下载centOS7对应的MySQL版本(通用版的Generic)百度云分享下载：http://pan.baidu.com/s/1eSiXD6M2：在/usr/local/下新建mysql目录[root@...
linux CentOS6.5 yum安装mysql5.6
12-16
总的来说，安装MySQL 5.6在CentOS 6.5上是一个相对直接的过程，主要涉及检查系统状态、添加YUM源、安装服务、设置密码和优化安全性。了解这些步骤可以帮助你顺利地在Linux环境中部署MySQL数据库。
Centos6.5 编译安装mysql 5.6.16 详细教程
09-10
- `cmake`：构建管理系统，MySQL 5.5以后版本的编译配置需要它。 - `make`：用于自动化编译过程。 - 其他如`bison`、`openssl`、`openssl-devel`、`gcc*`、`libxml2`、`libxml2-devel`、`curl-devel`、`libjpeg*`、`...
Centos5.5中安装Mysql5.5过程分享
12-15
Mysql5.5.37安装需要cmake，5.6版本开始都需要cmake来编译，5.5以后的版本应该也要装这个。 安装cmake 代码如下: [root@local ~]# wget http://www.cmake.org/files/v2.8/cmake-2.8.12.2.tar.gz [root@local ~]# ...
CentOS 7.x编译安装Nginx1.10.3+MySQL5.7.16+PHP5.2 5.3 5.4 5.5 5.6 7.0 7.1多版本全能环境
09-15
在搭建Linux服务器时，有时需要从源代码编译安装软件以获取特定版本或自定义配置。本教程将详细介绍如何在CentOS 7.x系统上编译安装Nginx 1.10.3、MySQL 5.7.16以及多个PHP版本（5.2至7.1）的全过程。在开始之前，...
Mysql 5.5.33 在linux64位下安装步骤完整版
03-13
Mysql 5.5.33 在linux64位下安装步骤完整版
centos7 安装mysql5.6
08-16
1. 开启网络wget http://mirrors.sohu.com/mysql/MySQL-5.6/mysql-5.6.25.tar.gz 2. 卸载centos 7自带的MariaDB数据库（mysql的分支） a) rpm -qa | grep mariadb b) rpm -e --nodeps mariadb-libs-5.5.41-2.el7_0.x86_64 3. 安装mysql（如果安装过请卸载掉再安装） a) 解压安装包 双击wget http://mirrors.sohu.c
linux下安装mysql5.5版本
h15637811412的博客
03-04 1178
将MySQL的服务端和客户端安装包（RPM）上传到服务器 查询之前是否安装过MySQL rpm -qa|grep -i mysql 卸载旧版本MySQL rpm -e --nodeps 软件名称 例如rpm -e --nodeps mysql-libs-5.1.71-1.el6.i686 安装服务端rpm -ivhMySQL-server-5.5.49-1.linux...
Mysql5.6.22-1安装及常见解决
fenqinqizheng的博客
05-15 328
2．Mysql安装 步骤： 1）查看CentOS自带的mysql 输入 rpm -qa | grep mysql 2）将自带的mysql卸载 rpm -e --nodeps mysql* 3）上传Mysql到linux 4）安装mysql的依赖（选做） yum -y install libaio.so.1 libgcc_s.so.1 libstdc++.so.6 yum update libstdc+±4.4.7-4.el6.x86_64 5）解压Mysql到/usr/local/下的mysql目录(mys
linux wget命令安装mysql_linux下安装mysql，求助大侠们
weixin_29337315的博客
01-27 134
展开全部MySQL有两种安装32313133353236313431303231363533e78988e69d8331333337623561方式：源码包安装和二进制包安装。这两种方式各有特色：二位制包安装不需编译，针对不同的平台有经过优化编译的不同的二进制文件以及包格式，安装简单方便；源码包则必须先配置编译再安装，可以根据你所用的主机环境进行优化，选择最佳的配置值，安装定制更灵活。下面分别介绍...
centos 5.8 安装 mysql 5.6.20
zhbpd的专栏
08-16 1403
1. 首先卸载系统自带的 mysql; 2.
linux下安装mysql5.5.43
u013183865的专栏
04-16 1777
find / -name mysql   查找文件 1,.d  删除vi编辑器中内容 1. 查看之前是否安装过mysql  ：  rpm -qa|grep -i mysql 2、停止mysql服务、删除之前安装的mysql    删除命令：rpm -ev –nodeps 包名 2.查找是否包含mysql文件夹，有的话删除  ：    find / -name mysql 3.卸
Linux安装mysql5.7和mysql5.6版本详细说明
Helen_1997_1997的博客
12-01 2143
linux上安装mysql5.7和mysql5.6，详细版！！！ 文章较长，图文并茂，就是为了照顾小白的，在安装的过程中也许会碰到很多问题，不要急。
mysql-community-common(x86-64) >= 5.7.9 is needed by mysql-community-libs-4
热门推荐
liukai6的博客
04-02 2万+
如果mysql报如下错误mysql-community-common(x86-64) >= 5.7.9 is needed by mysql-community-libs-5.7.21-1.el7.x86_64 这个时候需要解决的是将已经安装的rpm报卸载. 通过rpm -qa |grep -i mysql或者是rpm -qa |grep -i mariadb 如果找到那个执行 rpm -e
Ubuntu22.04怎么安装mysql5.6版本吗
最新发布
05-20
4. 安装MySQL 5.6： sudo apt-get install mysql-server=5.6* 注意：此命令仅将MySQL服务器安装为MySQL 5.6版本。如果您想安装其他MySQL 5.6软件包，请用apt-cache search MYSQL-5.6*命令列出可用的包。 希望这...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值