Centos 6.7 yum 升级mysql的版本
原来系统的mysql的版本信息如下：
yum info mysql-server
Mysql安装包的信息：
yum 命令补充：
yum info package1 显示安装包信息package1
运行的结果，默认 yum install mysql-server安装的版本是mysql5.1的版本，现在要借着官网
http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm rpm 安装包更新mysql的rpm安装包
查看当前mysql的版本：
[root@debug_test src]# yum info mysql-server Loaded plugins: security Installed Packages Name : mysql-server Arch : x86_64 Version : 5.1.73 Release : 8.el6_8 Size : 25 M Repo : installed From repo : updates Summary : The MySQL server and related files URL : http://www.mysql.com License : GPLv2 with exceptions Description : MySQL is a multi-user, multi-threaded SQL database server. MySQL is a : client/server implementation consisting of a server daemon (mysqld) : and many different client programs and libraries. This package contains : the MySQL server and some accompanying files and directories.
下载Mysql 的rpm 安装库
wget http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
下载后安装：
[root@debug_test src]# rpm -ivh mysql-community-release-el6-5.noarch.rpm Preparing... ########################################### [100%] 1:mysql-community-release########################################### [100%] [root@debug_test src]# rpm -ivh mysql-community-release-el6-5.noarch.rpm Preparing... ########################################### [100%] package mysql-community-release-el6-5.noarch is already installed
可以查看yum 安装库中关于Mysql的可以安装的Mysql的版本的信息
更新以后查看mysql可以安装的版本：
[root@debug_test src]# yum list |grep -i mysql
mysql-community-client.x86_64 5.6.35-2.el6 @mysql56-community
mysql-community-common.x86_64 5.6.35-2.el6 @mysql56-community
mysql-community-devel.x86_64 5.6.35-2.el6 @mysql56-community
mysql-community-libs.x86_64 5.6.35-2.el6 @mysql56-community
mysql-community-libs-compat.x86_64 5.6.35-2.el6 @mysql56-community
mysql-community-release.noarch el6-5 installed
mysql-community-server.x86_64 5.6.35-2.el6 @mysql56-community
perl-DBD-MySQL.x86_64 4.013-3.el6 @base
MySQL-python.x86_64 1.2.3-0.3.c1.1.el6 base
MySQL-zrm.noarch 3.0-6.el6 epel
apr-util-mysql.x86_64 1.3.9-3.el6_0.1 base
asterisk-mysql.x86_64 1.8.32.3-2.el6 epel
bacula-director-mysql.x86_64 5.0.0-13.el6 base
bacula-storage-mysql.x86_64 5.0.0-13.el6 base
collectd-mysql.x86_64 4.10.9-3.el6 epel
dmlite-plugins-mysql.x86_64 0.8.5-1.el6 epel
dovecot-mysql.x86_64 1:2.0.9-22.el6 base
dpm-copy-server-mysql.x86_64 1.9.0-1.el6 epel
dpm-name-server-mysql.x86_64 1.9.0-1.el6 epel
dpm-server-mysql.x86_64 1.9.0-1.el6 epel
dpm-srm-server-mysql.x86_64 1.9.0-1.el6 epel
dspam-mysql.x86_64 3.10.2-7.el6 epel
exim-mysql.x86_64 4.88-2.el6 epel
freeradius-mysql.x86_64 2.2.6-6.el6_7 base
fts-mysql.i686 3.5.7-1.el6 epel
fts-mysql.x86_64 3.5.7-1.el6 epel
gnokii-smsd-mysql.x86_64 0.6.30-2.el6 epel
holland-mysql.noarch 1.0.14-3.el6 epel
holland-mysqldump.noarch 1.0.14-3.el6 epel
holland-mysqllvm.noarch 1.0.14-3.el6 epel
lfc-server-mysql.x86_64 1.9.0-1.el6 epel
libdbi-dbd-mysql.x86_64 0.8.3-5.1.el6 base
libmysqlclient16.x86_64 5.1.69-1.w6 webtatic
libmysqlclient16-devel.x86_64 5.1.69-1.w6 webtatic
libnss-mysql.i686 1.5-12.el6 epel
libnss-mysql.x86_64 1.5-12.el6 epel
libodb-mysql.i686 2.3.0-1.el6 epel
libodb-mysql.x86_64 2.3.0-1.el6 epel
libodb-mysql-devel.i686 2.3.0-1.el6 epel
libodb-mysql-devel.x86_64 2.3.0-1.el6 epel
lighttpd-mod_authn_mysql.x86_64 1.4.45-1.el6 epel
lighttpd-mod_mysql_vhost.x86_64 1.4.45-1.el6 epel
lua-sql-mysql.x86_64 2.1.1-7.el6 epel
mod_auth_mysql.x86_64 1:3.0.0-11.el6_0.1 base
mydns-mysql.x86_64 1.2.8.31-2.el6 epel
mysql.x86_64 5.1.73-8.el6_8 updates
mysql++.i686 3.0.9-3.el6 epel
mysql++.x86_64 3.0.9-3.el6 epel
mysql++-devel.i686 3.0.9-3.el6 epel
mysql++-devel.x86_64 3.0.9-3.el6 epel
mysql++-manuals.x86_64 3.0.9-3.el6 epel
mysql-bench.x86_64 5.1.73-8.el6_8 updates
mysql-community-bench.x86_64 5.6.35-2.el6 mysql56-community
mysql-community-client.i686 5.6.35-2.el6 mysql56-community
mysql-community-common.i686 5.6.35-2.el6 mysql56-community
mysql-community-devel.i686 5.6.35-2.el6 mysql56-community
mysql-community-embedded.i686 5.6.35-2.el6 mysql56-community
mysql-community-embedded.x86_64 5.6.35-2.el6 mysql56-community
mysql-community-embedded-devel.i686 5.6.35-2.el6 mysql56-community
mysql-community-embedded-devel.x86_64 5.6.35-2.el6 mysql56-community
mysql-community-libs.i686 5.6.35-2.el6 mysql56-community
mysql-community-libs-compat.i686 5.6.35-2.el6 mysql56-community
mysql-community-test.x86_64 5.6.35-2.el6 mysql56-community
mysql-connector-java.noarch 1:5.1.17-6.el6 base
mysql-connector-odbc.x86_64 5.3.7-1.el6 mysql-connectors-community
mysql-connector-odbc-debuginfo.x86_64 5.3.7-1.el6 mysql-connectors-community
mysql-connector-odbc-setup.x86_64 5.3.7-1.el6 mysql-connectors-community
mysql-connector-python.noarch 2.0.4-1.el6 mysql-connectors-community
mysql-connector-python.x86_64 2.1.5-1.el6 mysql-connectors-community
mysql-connector-python-cext.x86_64 2.1.5-1.el6 mysql-connectors-community
mysql-connector-python-debuginfo.x86_64 2.1.5-1.el6 mysql-connectors-community
mysql-devel.i686 5.1.73-8.el6_8 updates
mysql-devel.x86_64 5.1.73-8.el6_8 updates
mysql-embedded.i686 5.1.73-8.el6_8 updates
mysql-embedded.x86_64 5.1.73-8.el6_8 updates
mysql-embedded-devel.i686 5.1.73-8.el6_8 updates
mysql-embedded-devel.x86_64 5.1.73-8.el6_8 updates
mysql-libs.i686 5.1.73-8.el6_8 updates
mysql-libs.x86_64 5.1.73-8.el6_8 updates
mysql-mmm.noarch 2.2.1-2.el6 epel
mysql-mmm-agent.noarch 2.2.1-2.el6 epel
mysql-mmm-monitor.noarch 2.2.1-2.el6 epel
mysql-mmm-tools.noarch 2.2.1-2.el6 epel
mysql-proxy.i686 0.8.5-2.el6 epel
mysql-proxy.x86_64 0.8.5-2.el6 epel
mysql-proxy-devel.i686 0.8.5-2.el6 epel
mysql-proxy-devel.x86_64 0.8.5-2.el6 epel
mysql-ref-manual-5.6-en-html-chapter.noarch
1-20170110 mysql56-community
mysql-ref-manual-5.6-en-pdf.noarch 1-20170110 mysql56-community
mysql-router.x86_64 2.0.4-1.el6 mysql-tools-community
mysql-router-debuginfo.x86_64 2.0.4-1.el6 mysql-tools-community
mysql-server.x86_64 5.1.73-8.el6_8 updates
mysql-test.x86_64 5.1.73-8.el6_8 updates
mysql-utilities.noarch 1.6.5-1.el6 mysql-tools-community
mysql-utilities-extra.noarch 1.5.6-1.el6 mysql-tools-community
mysql-workbench-community.x86_64 6.3.8-1.el6 mysql-tools-community
mysql-workbench-community-debuginfo.x86_64 6.3.8-1.el6 mysql-tools-community
mysql55w.x86_64 5.5.54-1.w6 webtatic
mysql55w-bench.x86_64 5.5.54-1.w6 webtatic
mysql55w-devel.x86_64 5.5.54-1.w6 webtatic
mysql55w-embedded.x86_64 5.5.54-1.w6 webtatic
mysql55w-embedded-devel.x86_64 5.5.54-1.w6 webtatic
mysql55w-libs.x86_64 5.5.54-1.w6 webtatic
mysql55w-server.x86_64 5.5.54-1.w6 webtatic
mysql55w-test.x86_64 5.5.54-1.w6 webtatic
mysqlreport.noarch 3.5-4.el6 epel
mysqltuner.noarch 1.6.0-1.el6 epel
nagios-plugins-mysql.x86_64 2.1.4-3.el6 epel
ndoutils-mysql.x86_64 1.5.2-1.el6 epel
nodejs-mysql.noarch 2.0.0-alpha9.2.el6.2 epel
opendbx-mysql.x86_64 1.4.6-6.el6 epel
openscada-DB-MySQL.x86_64 0.7.2-1.el6 epel
opensips-mysql.x86_64 1.7.2-2.el6 epel
pam_mysql.i686 1:0.7-0.12.rc1.el6 epel
pam_mysql.x86_64 1:0.7-0.12.rc1.el6 epel
pcp-pmda-mysql.x86_64 3.10.9-6.el6 base
pdns-backend-mysql.x86_64 3.3.3-2.el6 epel
perl-Class-DBI-mysql.noarch 1.00-7.el6 epel
perl-DateTime-Format-MySQL.noarch 0.04-8.el6 epel
perl-Test-mysqld.noarch 0.17-3.el6 epel
perl-Time-Piece-MySQL.noarch 0.05-8.el6 epel
php-ZendFramework-Db-Adapter-Mysqli.noarch 1.12.20-1.el6 epel
php-ZendFramework-Db-Adapter-Pdo-Mysql.noarch
php-mysql.x86_64 5.3.3-48.el6_8 updates
php-pear-MDB2-Driver-mysql.noarch 1.5.0-0.8.b4.el6 epel
php-pear-MDB2-Driver-mysqli.noarch 1.5.0-0.8.b4.el6 epel
php55w-mysql.x86_64 5.5.38-1.w6 webtatic
php55w-mysqlnd.x86_64 5.5.38-1.w6 webtatic
php56w-mysql.x86_64 5.6.30-1.w6 webtatic
php56w-mysqlnd.x86_64 5.6.30-1.w6 webtatic
php70w-mysql.x86_64 7.0.16-1.w6 webtatic
php70w-mysqlnd.x86_64 7.0.16-1.w6 webtatic
php71w-mysql.x86_64 7.1.2-1.w6 webtatic
php71w-mysqlnd.x86_64 7.1.2-1.w6 webtatic
poco-mysql.i686 1.4.2p1-3.el6 epel
poco-mysql.x86_64 1.4.2p1-3.el6 epel
proftpd-mysql.x86_64 1.3.3g-10.el6 epel
qt-mysql.i686 1:4.6.2-28.el6_5 base
qt-mysql.x86_64 1:4.6.2-28.el6_5 base
qt3-MySQL.i686 3.3.8b-30.el6 base
qt3-MySQL.x86_64 3.3.8b-30.el6 base
qt5-qtbase-mysql.i686 5.6.1-3.el6 epel
qt5-qtbase-mysql.x86_64 5.6.1-3.el6 epel
rekall-mysql.i686 2.4.6-13.el6 epel
rekall-mysql.x86_64 2.4.6-13.el6 epel
root-sql-mysql.x86_64 5.34.36-1.el6 epel
rsyslog-mysql.x86_64 5.8.10-10.el6_6 base
rsyslog7-mysql.x86_64 7.4.10-5.el6 base
ruby-mysql.x86_64 2.8.2-1.el6 epel
soci-mysql.i686 3.2.2-2.el6 epel
soci-mysql.x86_64 3.2.2-2.el6 epel
soci-mysql-devel.i686 3.2.2-2.el6 epel
soci-mysql-devel.x86_64 3.2.2-2.el6 epel
tcl-mysqltcl.x86_64 3.052-1.el6 epel
trytond-mysql.noarch 1.8.10-1.el6 epel
voms-mysql-plugin.x86_64 3.1.7-1.el6 epel
zabbix-proxy-mysql.x86_64 1.8.22-1.el6 epel
zabbix-server-mysql.x86_64 1.8.22-1.el6 epel
zabbix-web-mysql.noarch 1.8.22-1.el6 epel
zabbix20-proxy-mysql.x86_64 2.0.20-1.el6 epel
zabbix20-server-mysql.x86_64 2.0.20-1.el6 epel
zabbix20-web-mysql.noarch 2.0.20-1.el6 epel
zabbix22-dbfiles-mysql.noarch 2.2.16-1.el6 epel
zabbix22-proxy-mysql.x86_64 2.2.16-1.el6 epel
zabbix22-server-mysql.x86_64 2.2.16-1.el6 epel
zabbix22-web-mysql.noarch 2.2.16-1.el6 epel
只需要安装红色的字体的安装包即可，其他都是依赖库【包括mysql-client 客户端】
安装完成后，重启mysql
命令：
service mysqld restart 或者 /etc/init.d/mysqld start
有提示OK的字样说明安装成功：
Starting mysqld: [ OK ]
如果你没有将原来的版本删除而直接更新，可能会提示Failed的提示，此时，只有一个方法：看日志，默认的日志路径：/var/log/mysqld.log
2017-03-17 16:27:44 8783 [Note] Plugin 'FEDERATED' is disabled.
2017-03-17 16:27:44 8783 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-03-17 16:27:44 8783 [Note] InnoDB: The InnoDB memory heap is disabled
2017-03-17 16:27:44 8783 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-03-17 16:27:44 8783 [Note] InnoDB: Memory barrier is not used
2017-03-17 16:27:44 8783 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-03-17 16:27:44 8783 [Note] InnoDB: Using Linux native AIO
2017-03-17 16:27:44 8783 [Note] InnoDB: Using CPU crc32 instructions
2017-03-17 16:27:44 8783 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-03-17 16:27:44 8783 [Note] InnoDB: Completed initialization of buffer pool
2017-03-17 16:27:44 8783 [ERROR] InnoDB: auto-extending data file ./ibdata1 is of a different size 640 pages (rounded down to MB) than specified in the .cnf file: initial 768 pages, max 0 (relevant if non-zero) pages!
2017-03-17 16:27:44 8783 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
2017-03-17 16:27:44 8783 [ERROR] Plugin 'InnoDB' init function returned error.
2017-03-17 16:27:44 8783 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-03-17 16:27:44 8783 [ERROR] Unknown/unsupported storage engine: InnoDB
2017-03-17 16:27:44 8783 [ERROR] Aborting
2017-03-17 16:27:44 8783 [Note] Binlog end
2017-03-17 16:27:44 8783 [Note] Shutting down plugin 'partition'
2017-03-17 16:27:44 8783 [Note] Shutting down plugin 'BLACKHOLE'
2017-03-17 16:27:44 8783 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2017-03-17 16:27:44 8783 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2017-03-17 16:27:44 8783 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2017-03-17 16:27:44 8783 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2017-03-17 16:27:44 8783 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2017-03-17 16:27:44 8783 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2017-03-17 16:27:44 8783 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2017-03-17 16:27:44 8783 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2017-03-17 16:27:44 8783 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2017-03-17 16:27:44 8783 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2017-03-17 16:27:44 8783 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2017-03-17 16:27:44 8783 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2017-03-17 16:27:44 8783 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2017-03-17 16:27:44 8783 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2017-03-17 16:27:44 8783 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2017-03-17 16:27:44 8783 [Note] Shutting down plugin 'INNODB_METRICS'
2017-03-17 16:27:44 8783 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2017-03-17 16:27:44 8783 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2017-03-17 16:27:44 8783 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2017-03-17 16:27:44 8783 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2017-03-17 16:27:44 8783 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2017-03-17 16:27:44 8783 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2017-03-17 16:27:44 8783 [Note] Shutting down plugin 'INNODB_CMPMEM'
2017-03-17 16:27:44 8783 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2017-03-17 16:27:44 8783 [Note] Shutting down plugin 'INNODB_CMP'
2017-03-17 16:27:44 8783 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2017-03-17 16:27:44 8783 [Note] Shutting down plugin 'INNODB_LOCKS'
2017-03-17 16:27:44 8783 [Note] Shutting down plugin 'INNODB_TRX'
2017-03-17 16:27:44 8783 [Note] Shutting down plugin 'ARCHIVE'
2017-03-17 16:27:44 8783 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2017-03-17 16:27:44 8783 [Note] Shutting down plugin 'MRG_MYISAM'
2017-03-17 16:27:44 8783 [Note] Shutting down plugin 'MEMORY'
2017-03-17 16:27:44 8783 [Note] Shutting down plugin 'MyISAM'
2017-03-17 16:27:44 8783 [Note] Shutting down plugin 'CSV'
2017-03-17 16:27:44 8783 [Note] Shutting down plugin 'sha256_password'
2017-03-17 16:27:44 8783 [Note] Shutting down plugin 'mysql_old_password'
2017-03-17 16:27:44 8783 [Note] Shutting down plugin 'mysql_native_password'
2017-03-17 16:27:44 8783 [Note] Shutting down plugin 'binlog'
2017-03-17 16:27:44 8783 [Note] /usr/sbin/mysqld: Shutdown complete
注意红色字体的提示部分：
解决方案：
http://sharadchhetri.com/2014/11/29/upgrading-mysql-5-1-5-6-service-failed-start/
在配置文件中[mysqldd]模块中添加：
innodb_data_file_path = ibdata1:10M:autoextend
问题原因：我推测可能是我没有卸载原来默认的mysql 5.1版本所导致的。
至此，mysql的升级完成
【注意：在进行mysql升级之前，要做很多工作，升级完成或者升级失败，可能由于版本的原因，导致mysql一些原因，导致失败，所以，数据备份很重要的，很重要的。】
mysql的版本信息如下：
Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 Server version: 5.6.35 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.
Mysql5.6 社区版，至此安装成功
联系我->邮件写信
