3分钟，YUM升级MYSQL，5.1到5.6-创新互联

本文介绍如何通过YUM升级Mysql的版本（默认用YUM安装的MySQL都是5.1的版本）

额尔古纳网站制作公司哪家好，找创新互联！从网页设计、网站建设、微信开发、APP开发、响应式网站设计等网站项目制作，到程序开发，运营维护。创新互联于2013年创立到现在10年的时间，我们拥有了丰富的建站经验和运维经验，来保证我们的工作的顺利进行。专注于网站建设就选创新互联。

环境：CENTOS6.9

原Mysql 版本：5.1

新Mysql 版本：5.6

时间需要：3分钟以内

注意：做任何动作前，先做好数据备份和恢复计划

[willson@heegw3o0cZ ~]$ sudo su - root

[root@heegw3o0cZ ~]#

[root@heegw3o0cZ ~]# /etc/init.d/mysqld stop

Stopping mysqld: [ OK ]

[root@heegw3o0cZ~]# yum remove mysql

Loaded plugins: fastestmirror

Setting up Remove Process

Resolving Dependencies

--> Running transaction check

---> Package mysql.x86_64 0:5.1.73-8.el6_8 will be erased

--> Processing Dependency: mysql = 5.1.73-8.el6_8 for package: mysql-devel-5.1.73-8.el6_8.x86_64

--> Processing Dependency: mysql = 5.1.73-8.el6_8 for package: mysql-server-5.1.73-8.el6_8.x86_64

--> Running transaction check

---> Package mysql-devel.x86_64 0:5.1.73-8.el6_8 will be erased

---> Package mysql-server.x86_64 0:5.1.73-8.el6_8 will be erased

--> Processing Dependency: mysql-server for package: perl-Test-mysqld-0.17-3.el6.noarch

--> Running transaction check

---> Package perl-Test-mysqld.noarch 0:0.17-3.el6 will be erased

--> Finished Dependency Resolution

Dependencies Resolved

===================================================================================

Package Arch Version Repository Size

===================================================================================

Removing:

mysql x86_64 5.1.73-8.el6_8 @updates 2.4 M

Removing for dependencies:

mysql-devel x86_64 5.1.73-8.el6_8 @updates 388 k

mysql-server x86_64 5.1.73-8.el6_8 @updates 25 M

perl-Test-mysqld noarch 0.17-3.el6 @epel 14 k

Transaction Summary

===================================================================================

Remove 4 Package(s)

Installed size: 27 M

Is this ok [y/N]: y

Downloading Packages:

Running rpm_check_debug

Running Transaction Test

Transaction Test Succeeded

Running Transaction

Erasing : mysql-devel-5.1.73-8.el6_8.x86_64 1/4

Erasing : perl-Test-mysqld-0.17-3.el6.noarch 2/4

Erasing : mysql-server-5.1.73-8.el6_8.x86_64 3/4

warning: /var/log/mysqld.log saved as /var/log/mysqld.log.rpmsave

Erasing : mysql-5.1.73-8.el6_8.x86_64 4/4

Verifying : perl-Test-mysqld-0.17-3.el6.noarch 1/4

Verifying : mysql-server-5.1.73-8.el6_8.x86_64 2/4

Verifying : mysql-5.1.73-8.el6_8.x86_64 3/4

Verifying : mysql-devel-5.1.73-8.el6_8.x86_64 4/4

Removed:

mysql.x86_64 0:5.1.73-8.el6_8

Dependency Removed:

mysql-devel.x86_64 0:5.1.73-8.el6_8 mysql-server.x86_64 0:5.1.73-8.el6_8

perl-Test-mysqld.noarch 0:0.17-3.el6

Complete!

[root@heegw3o0cZ ~]#

[root@heegw3o0cZ ~]# rpm -Uvh http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm

Retrieving http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm

Preparing... ########################################### [100%]

1:mysql-community-release########################################### [100%]

[root@heegw3o0cZ ~]# yum install mysql-community-server

Loaded plugins: fastestmirror

Setting up Install Process

Determining fastest mirrors

* base: mirrors.aliyuncs.com

* epel: mirrors.aliyuncs.com

* extras: mirrors.aliyuncs.com

* updates: mirrors.aliyuncs.com

base | 3.7 kB 00:00

epel | 4.7 kB 00:00

epel/primary_db | 6.0 MB 00:00

extras | 3.4 kB 00:00

extras/primary_db | 29 kB 00:00

mysql-connectors-community | 2.5 kB 00:00

mysql-connectors-community/primary_db | 17 kB 00:00

mysql-tools-community | 2.5 kB 00:00

mysql-tools-community/primary_db | 38 kB 00:00

mysql56-community | 2.5 kB 00:00

mysql56-community/primary_db | 197 kB 00:00

updates | 3.4 kB 00:00

updates/primary_db | 5.3 MB 00:00

zabbix | 951 B 00:00

zabbix-non-supported | 951 B 00:00

Resolving Dependencies

--> Running transaction check

---> Package mysql-community-server.x86_64 0:5.6.38-2.el6 will be installed

--> Processing Dependency: mysql-community-common(x86-64) = 5.6.38-2.el6 for package: mysql-community-server-5.6.38-2.el6.x86_64

--> Processing Dependency: mysql-community-client(x86-64) >= 5.6.10 for package: mysql-community-server-5.6.38-2.el6.x86_64

--> Running transaction check

---> Package mysql-community-client.x86_64 0:5.6.38-2.el6 will be installed

--> Processing Dependency: mysql-community-libs(x86-64) >= 5.6.10 for package: mysql-community-client-5.6.38-2.el6.x86_64

---> Package mysql-community-common.x86_64 0:5.6.38-2.el6 will be installed

--> Running transaction check

---> Package mysql-community-libs.x86_64 0:5.6.38-2.el6 will be obsoleting

---> Package mysql-libs.x86_64 0:5.1.73-8.el6_8 will be obsoleted

--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: 2:postfix-2.6.6-8.el6.x86_64

--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: redland-1.0.7-11.el6.x86_64

--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: perl-DBD-MySQL-4.013-3.el6.x86_64

--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: 2:postfix-2.6.6-8.el6.x86_64

--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: redland-1.0.7-11.el6.x86_64

--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: perl-DBD-MySQL-4.013-3.el6.x86_64

--> Running transaction check

---> Package mysql-community-libs-compat.x86_64 0:5.6.38-2.el6 will be obsoleting

--> Finished Dependency Resolution

Dependencies Resolved

===================================================================================

Package Arch Version Repository Size

===================================================================================

Installing:

mysql-community-libs x86_64 5.6.38-2.el6 mysql56-community 1.9 M

replacing mysql-libs.x86_64 5.1.73-8.el6_8

mysql-community-libs-compat x86_64 5.6.38-2.el6 mysql56-community 1.6 M

replacing mysql-libs.x86_64 5.1.73-8.el6_8

mysql-community-server x86_64 5.6.38-2.el6 mysql56-community 55 M

Installing for dependencies:

mysql-community-client x86_64 5.6.38-2.el6 mysql56-community 18 M

mysql-community-common x86_64 5.6.38-2.el6 mysql56-community 308 k

Transaction Summary

===================================================================================

Install 5 Package(s)

Total download size: 77 M

Is this ok [y/N]: y

Downloading Packages:

(1/5): mysql-community-client-5.6.38-2.el6.x86_64.rpm | 18 MB 00:01

(2/5): mysql-community-common-5.6.38-2.el6.x86_64.rpm | 308 kB 00:00

(3/5): mysql-community-libs-5.6.38-2.el6.x86_64.rpm | 1.9 MB 00:00

(4/5): mysql-community-libs-compat-5.6.38-2.el6.x86_64.rpm | 1.6 MB 00:00

(5/5): mysql-community-server-5.6.38-2.el6.x86_64.rpm | 55 MB 00:04

-----------------------------------------------------------------------------------

Total 11 MB/s | 77 MB 00:06

warning: rpmts_HdrFromFdno: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY

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>

Package: mysql-community-release-el6-5.noarch (installed)

From : file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

Is this ok [y/N]: y

Running rpm_check_debug

Running Transaction Test

Transaction Test Succeeded

Running Transaction

Warning: RPMDB altered outside of yum.

** Found 3 pre-existing rpmdb problem(s), 'yum check' output follows:

tomcat6-6.0.24-98.el6_8.noarch has missing requires of tomcat6-lib = ('0', '6.0.24', '98.el6_8')

tomcat6-admin-webapps-6.0.24-105.el6_8.noarch has missing requires of tomcat6 = ('0', '6.0.24', '105.el6_8')

tomcat6-webapps-6.0.24-105.el6_8.noarch has missing requires of tomcat6 = ('0', '6.0.24', '105.el6_8')

Installing : mysql-community-common-5.6.38-2.el6.x86_64 1/6

Installing : mysql-community-libs-5.6.38-2.el6.x86_64 2/6

Installing : mysql-community-client-5.6.38-2.el6.x86_64 3/6

Installing : mysql-community-server-5.6.38-2.el6.x86_64 4/6

warning: /etc/my.cnf created as /etc/my.cnf.rpmnew

Installing : mysql-community-libs-compat-5.6.38-2.el6.x86_64 5/6

Erasing : mysql-libs-5.1.73-8.el6_8.x86_64 6/6

Verifying : mysql-community-common-5.6.38-2.el6.x86_64 1/6

Verifying : mysql-community-libs-5.6.38-2.el6.x86_64 2/6

Verifying : mysql-community-libs-compat-5.6.38-2.el6.x86_64 3/6

Verifying : mysql-community-client-5.6.38-2.el6.x86_64 4/6

Verifying : mysql-community-server-5.6.38-2.el6.x86_64 5/6

Verifying : mysql-libs-5.1.73-8.el6_8.x86_64 6/6

Installed:

mysql-community-libs.x86_64 0:5.6.38-2.el6

mysql-community-libs-compat.x86_64 0:5.6.38-2.el6

mysql-community-server.x86_64 0:5.6.38-2.el6

Dependency Installed:

mysql-community-client.x86_64 0:5.6.38-2.el6

mysql-community-common.x86_64 0:5.6.38-2.el6

Replaced:

mysql-libs.x86_64 0:5.1.73-8.el6_8

Complete!

[root@heegw3o0cZ ~]# mysql -V

mysql Ver 14.14 Distrib 5.6.38, for Linux (x86_64) using EditLine wrapper

[root@heegw3o0cZ ~]# /etc/init.d/mysqld start

Starting mysqld: [ OK ]

[root@heegw3o0cZ ~]# mysql

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

Your MySQL connection id is 2

Server version: 5.6.38 MySQL Community Server (GPL)

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 |

| mysql |

| rt3 |

+--------------------+

7 rows in set (0.00 sec)

mysql>

另外有需要云服务器可以了解下创新互联cdcxhl.cn，海内外云服务器15元起步，三天无理由+7*72小时售后在线，公司持有idc许可证，提供“云服务器、裸金属服务器、高防服务器、香港服务器、美国服务器、虚拟主机、免备案服务器”等云主机租用服务以及企业上云的综合解决方案，具有“安全稳定、简单易用、服务可用性高、性价比高”等特点与优势，专为企业上云打造定制，能够满足用户丰富、多元化的应用场景需求。

网站题目：3分钟，YUM升级MYSQL，5.1到5.6-创新互联
URL地址：https://www.cdcxhl.com/article24/deedje.html

成都网站建设公司_创新互联，为您提供关键词优化、面包屑导航、软件开发、小程序开发、网站收录、搜索引擎优化

声明：本网站发布的内容（图片、视频和文字）以用户投稿、用户转载内容为主，如果涉及侵权请尽快告知，我们将会在第一时间删除。文章观点不代表本网站立场，如需处理请联系客服。电话：028-86922220；邮箱：631063699@qq.com。内容未经允许不得转载，或转载时需注明来源：创新互联

猜你还喜欢下面的内容