Mysql-5.1.61 Environment
Operating System: Cent-os6.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 am cent OS and chose Red Hat Enterprise Linux.
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 how much the password, so I use mysql_safe to operate, change the password. For details, see the http://www.jb51.net/article/16726.htm
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