Environment: mysql-5.1.61
Operating system: cent-os6.3
Purpose: Upgrade to MySQL 5.6.19
First, Yum is not feasible. Because Yum source is not updated, I have used 163 netease source, but still not. The latest version is still not 5.6. There is no way, MySQL partition is 5.5 after the function, to use the partition function, you must upgrade.
To official website: http://dev.mysql.com/downloads/mysql/
I am cent OS and I have selected the red Hat Enterprise Linux version.
Since the system is i686, select the i686 version
If you just installed MySQL, then you can choose 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
It means that the mysql-server.rpm bag and the mysql-libs package conflict ...
Very simple, delete the Mysql-libs package is OK, anyway is also 5.1 version of.
Then proceed to install Mysql-server, install successfully
Then start the MySQL service.
Error: Connection Error:can ' t connect to local MySQL server through socket '/var/lib/mysql/mysql.sock ' Mysql.sock
Viewed the MySQL log, said to be because there is no file/var/run/mysql/xxx. Look, the original/var/run/mysql have no folder, so set up, and then fix.
Do not know how many passwords, and then use Mysql_safe to operate, change the password. See http://blog.csdn.net/zouhao619/article/details/7592505 for details
Then change the password, log in, import data, prompting me to modify the MySQL password, OK. Set Password=password ("123456");
After you have modified, import the database. Error: In short, the coding is wrong ... Forget what's wrong ...
Then at the time of import, set the encoding import. Get...
Next find Php-mysql No, yum, and need mysql-libs connection package. This bag has clashed with me again.
Then install the mysql-shared-compat-5.6.19-1.el6.i686, this package can solve this problem. Get
The php-mysql is installed properly.
This article remembers the same as journal. Did not write the specific problem reason ... Because it was very urgent, there is no record of error details ...
Lessons learned, next record