centos6.5升级mysql数据库

操作系统：CentOS-6.5-x86_64-minimal

[b]# cat /etc/redhat-release[/b]
CentOS release 6.5 (Final)

卸载自带的5.1的mysql-libs包

[b]#rpm -e --nodeps mysql-libs[/b]

安装wget

[b]#yum install wget -y[/b]

……省略……
Installed:
wget.x86_64 0:1.12-1.8.el6

Complete!
下载5.6的依赖源配置repo rpm文件

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

安装repo rpm包

[b]# rpm -ivh mysql-community-release-el6-5.noarch.rpm [/b]
Preparing... ########################################### [100%]
1:mysql-community-release########################################### [100%]
或者rpm -ivh http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm

安装mysql-server

[b]# yum install mysql-server mysql-community-devel[/b]
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirrors.tuna.tsinghua.edu.cn
* extras: mirrors.tuna.tsinghua.edu.cn
* updates: mirrors.163.com
mysql-connectors-community | 2.5 kB 00:00
mysql-connectors-community/primary_db
中间省略

Warning: RPMDB altered outside of yum.
Installing : mysql-community-common-5.6.16-1.el6.x86_64 1/7
Installing : mysql-community-libs-5.6.16-1.el6.x86_64 2/7
Installing : mysql-community-client-5.6.16-1.el6.x86_64 3/7
Installing : perl-DBI-1.609-4.el6.x86_64 4/7
Installing : mysql-community-server-5.6.16-1.el6.x86_64 5/7
Installing : mysql-community-libs-compat-5.6.16-1.el6.x86_64 6/7
Erasing : mysql-libs-5.1.71-1.el6.x86_64 7/7
Verifying : mysql-community-libs-compat-5.6.16-1.el6.x86_64 1/7
Verifying : mysql-community-server-5.6.16-1.el6.x86_64 2/7
Verifying : mysql-community-common-5.6.16-1.el6.x86_64 3/7
Verifying : mysql-community-libs-5.6.16-1.el6.x86_64 4/7
Verifying : perl-DBI-1.609-4.el6.x86_64 5/7
Verifying : mysql-community-client-5.6.16-1.el6.x86_64 6/7
Verifying : mysql-libs-5.1.71-1.el6.x86_64 7/7

Installed:
mysql-community-libs.x86_64 0:5.6.16-1.el6 mysql-community-server.x86_64 0:5.6.16-1.el6

Dependency Installed:
mysql-community-client.x86_64 0:5.6.16-1.el6 mysql-community-common.x86_64 0:5.6.16-1.el6 mysql-community-libs-compat.x86_64 0:5.6.16-1.el6 perl-DBI.x86_64 0:1.609-4.el6

Replaced:
mysql-libs.x86_64 0:5.1.71-1.el6

Complete!


[b]# rpm -qa | grep mysql[/b]
mysql-community-release-el6-5.noarch
mysql-community-common-5.6.16-1.el6.x86_64
mysql-community-client-5.6.16-1.el6.x86_64
mysql-community-server-5.6.16-1.el6.x86_64
mysql-community-libs-5.6.16-1.el6.x86_64
mysql-community-devel-5.6.16-1.el6.x86_64

启动mysql-server

[b]#/etc/init.d/mysqld start[/b]

客户端连接

# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.6.16 MySQL Community Server (GPL)

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