Upgrading MySQL from 5.5 to 5.7 failed on CentOS 6.7

[H Wang]

Dear all,

Previously I was running MySQL 5.5 on CentOS 6.7 32bit. For some reason I need to upgrade to MySQL 5.7. I executed following commands and got error mysqld cannot be started. Can you please help me?

wget http://dev.mysql.com/get/mysql57-community-release-el6-8.noarch.rpm
yum localinstall mysql57-community-release-el6-8.noarch.rpm
yum update mysql-server

Resolving Dependencies
--> Running transaction check
---> Package mysql-community-server.i686 0:5.7.13-1.el6 will be obsoleting
--> Processing Dependency: mysql-community-common(x86-32) >= 5.7.9 for package: mysql-community-server-5.7.13-1.el6.i686
--> Processing Dependency: mysql-community-client(x86-32) >= 5.7.9 for package: mysql-community-server-5.7.13-1.el6.i686
---> Package mysql-server.i686 0:5.5.50-1.el6.remi will be obsoleted
--> Running transaction check
---> Package mysql.i686 0:5.5.50-1.el6.remi will be obsoleted
--> Processing Dependency: real-mysql(x86-32) = 5.5.50-1.el6.remi for package: mysql-devel-5.5.50-1.el6.remi.i686
---> Package mysql-community-client.i686 0:5.7.13-1.el6 will be obsoleting
--> Processing Dependency: mysql-community-libs(x86-32) >= 5.7.9 for package: mysql-community-client-5.7.13-1.el6.i686
---> Package mysql-community-common.i686 0:5.7.13-1.el6 will be installed
--> Running transaction check
---> Package mysql-community-devel.i686 0:5.7.13-1.el6 will be obsoleting
---> Package mysql-community-libs.i686 0:5.7.13-1.el6 will be obsoleting
---> Package mysql-devel.i686 0:5.5.50-1.el6.remi will be obsoleted
---> Package mysql-libs.i686 0:5.5.50-1.el6.remi will be obsoleted
--> Finished Dependency Resolution

Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : mysql-community-common-5.7.13-1.el6.i686 1/9
Installing : mysql-community-libs-5.7.13-1.el6.i686 2/9
Installing : mysql-community-client-5.7.13-1.el6.i686 3/9
Installing : mysql-community-devel-5.7.13-1.el6.i686 4/9
Installing : mysql-community-server-5.7.13-1.el6.i686 5/9
warning: /etc/my.cnf created as /etc/my.cnf.rpmnew
Erasing : mysql-devel-5.5.50-1.el6.remi.i686 6/9
Erasing : mysql-server-5.5.50-1.el6.remi.i686 7/9
warning: /var/log/mysqld.log saved as /var/log/mysqld.log.rpmsave
Erasing : mysql-5.5.50-1.el6.remi.i686 8/9
Erasing : mysql-libs-5.5.50-1.el6.remi.i686 9/9
Verifying : mysql-community-server-5.7.13-1.el6.i686 1/9
Verifying : mysql-community-devel-5.7.13-1.el6.i686 2/9
Verifying : mysql-community-client-5.7.13-1.el6.i686 3/9
Verifying : mysql-community-libs-5.7.13-1.el6.i686 4/9
Verifying : mysql-community-common-5.7.13-1.el6.i686 5/9
Verifying : mysql-libs-5.5.50-1.el6.remi.i686 6/9
Verifying : mysql-devel-5.5.50-1.el6.remi.i686 7/9
Verifying : mysql-5.5.50-1.el6.remi.i686 8/9
Verifying : mysql-server-5.5.50-1.el6.remi.i686 9/9

Installed:
mysql-community-client.i686 0:5.7.13-1.el6 mysql-community-devel.i686 0:5.7.13-1.el6 mysql-community-libs.i686 0:5.7.13-1.el6
mysql-community-server.i686 0:5.7.13-1.el6

Dependency Installed:
mysql-community-common.i686 0:5.7.13-1.el6

Replaced:
mysql.i686 0:5.5.50-1.el6.remi mysql-devel.i686 0:5.5.50-1.el6.remi mysql-libs.i686 0:5.5.50-1.el6.remi mysql-server.i686 0:5.5.50-1.el6.remi

Complete!
[root@mail ~]# service mysqld start
MySQL Daemon failed to start.
Starting mysqld: [FAILED]

File /var/log/mysqld.log is empty.

# cat /var/log/mysqld.log.rpmsave
160321 10:32:08 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160321 10:32:08 InnoDB: Initializing buffer pool, size = 8.0M
160321 10:32:08 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
160321 10:32:08 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
160321 10:32:08 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
160321 10:32:08 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
160321 10:32:08 InnoDB: Started; log sequence number 0 0
160321 10:32:08 [Note] Event Scheduler: Loaded 0 events
160321 10:32:08 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
160321 10:35:39 [Note] /usr/libexec/mysqld: Normal shutdown

160321 10:35:39 [Note] Event Scheduler: Purging the queue. 0 events
160321 10:35:39 InnoDB: Starting shutdown...
160321 10:35:44 InnoDB: Shutdown completed; log sequence number 0 505971
160321 10:35:44 [Note] /usr/libexec/mysqld: Shutdown complete

160321 10:35:44 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended