Today, I am trying to upgrade mysql server to a higher version, because I need to save some utf-8 bin data into the whole process, I encounter some difficulties and record here, to let me have a place to reference If I need to do it again.
Some steps in my ways are good best one, but in this way, I am successfully upgrade mysql server.
1. Back up your data.
2. Remove mysql server.
3. Download mysql source package file(rpm), and install it(rpm -i package name).
4. Import data to new server.
5. Download compatible file for Old PHP-Mysql version file to connect to new mysql server.(http://rpm.pbone.net/index.php3/stat/4/idpl/11455444/dir/redhat_el_5/com/MySQL-shared-compat-6.0.9-0.rhel5.i386.rpm.html).
6. Rpm -i to install above package.
7. Download Php mysql package file and install it.
Then, you can connect new version of mysql server from PHP. In your new mysql server, if you want to create a user from access this mysql server from in and outside, you need to create two accounts, one is for connect from localhost, another is for accessing from outside.Both account should have the same name and password. "%" means any outside host.
