一台老服务器的升级日志（PHP4.4.9+MySQL5.1）升级MySQL5.6

提示：扫一扫查出行
【扫一扫了解最新限行尾号】
复制提示

1.备份数据库

mysqldump -uroot -p --all-databases > databases.sql

2.停止mysql服务

service mysqld stop

3.卸载旧版本mysql

yum remove mysql mysql-*

rpm -qa | grep mysql

yum list installed | grep mysql

rm -rf /var/lib/mysql

4.安装mysql5.6

rpm -Uvh http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm

yum install mysql-community-server

yum -y install mysql mysql-server mod_auth_mysql mysql-connector-odbc mysql-devel libdbi-dbd-mysql

5.启动mysql

service mysqld start

chkconfig mysqld on

mysqladmin -u root password 'mysql'

6.重新编辑php
6.1查找mysql.h文件
find / -name mysql.h
/usr/include/mysql/mysql.h
查找到mysql.h文件，我们更改参数为--with-mysql=/usr，如果没有的话，请安装mysql-devel包

./configure --enable-mbstring --with-zlib --without-iconv --with-mysql=/usr --with-apxs2=/usr/sbin/apxs
make clean
make
make install

感谢：

https://blog.csdn.net/u013987661/article/details/53924394

https://www.cnblogs.com/luomir/p/4772903.html