Problems encountered during upgrading MySQL 5.1.61 to 5.6.19 in CentOS 6.3 and Their Solutions

Problems encountered during upgrading MySQL 5.1.61 to 5.6.19 in CentOS 6.3 and Their Solutions

Environment: MySQL 5.1.61

Operating System: CentOS 6.3

Objective: To upgrade to MySQL 5.6.19

First, yum is not feasible. because the yum source is not updated, I have used the 163 Netease source, but it still does not work. the latest version is still not 5. 6. no way. The MySQL partition is a function after 5.5. to use the partition function, you must upgrade it ..

Go to Official Website: http://dev.mysql.com/downloads/mysql/

I chose Red Hat Enterprise Linux for CentOS.

Because the system is i686, choose i686

If you only install mysql, you can select mysql-server. I downloaded all the packages.

Then the server installs the rpm package

Rpm-ivh MySQL-server-5.6.19-1.el6.i686

Error. file/usr/share/mysql/charsets/README from install of MySQL-server-5.6.10-1.linux_glibc2.5.i386conflicts with file from package mysql-libs-5.1.61-4.el6.i686

The mysql-server.rpm package conflicts with the mysql-libs package...

It's easy to delete the mysql-libs package. It's also version 5.1.

Continue to install Mysql-server. Installation successful

Start the mysql service.

Error: Connection error: Can't connect to local MySQL server through socket '/var/lib/mysql. sock' mysql. sock

I checked the mysql Log, saying that there is no file/var/run/mysql/xxx. I looked at it and there was no folder in the original/var/run/mysql, so I created it and got it done.

I don't know the password, so I use mysql_safe again. For more information, see

After changing the password, log on to and import the data, prompting me to change the mysql password first. set password = password ("123456 ");

After modification, import the database. An error is reported: the encoding is incorrect... What error is missing...

Then, set the encoding to import during the import...

Next I found that php-mysql does not exist, yum, and mysql-libs connection package is required. This package conflicts with me.

And then install the MySQL-shared-compat-5.6.19-1.el6.i686, this package can solve this problem ..

Php-mysql is installed.

I remember this article is the same as the journal account. I didn't write the specific cause of the problem... because it was very urgent at the time, I didn't record the error details...

Sum up experience, next record

-------------------------------------- Split line --------------------------------------

Install MySQL in Ubuntu 14.04

MySQL authoritative guide (original book version 2nd) Clear Chinese scan PDF

Ubuntu 14.04 LTS install LNMP Nginx \ PHP5 (PHP-FPM) \ MySQL

Build a MySQL Master/Slave server in Ubuntu 14.04

Build a highly available distributed MySQL cluster using Ubuntu 12.04 LTS

Install MySQL5.6 and Python-MySQLdb in the source code of Ubuntu 12.04

MySQL-5.5.38 universal binary Installation

-------------------------------------- Split line --------------------------------------

This article permanently updates the link address: