Topic: MySQL connection not working after upgrading to PHP 5.6.22
Hello,
Thanks for your fine packages.
I have upgraded to PHP 5.6.22 successfully on Centos 6, but it didn't work on Centos 5.
Upgrade (using remi-php56 repo) completed, but I always got the error:
Database connection error (2): Could not connect to MySQL.
I couldn't find why it didn't work. I had to downgrade to the old 5.4.45-9 (from remi-php repo). After downgrade, things worked fine again (fortunately).
I did not downgrade MySQL but only php.
Can you please provide an explanation why this happened? MySQL and PHP versions should be compatible.
Can you please advise me on how to retry to upgrade safely?
I had installed the following packages:
Installed:
php-mysqlnd.x86_64 0:5.6.22-1.el5.remi
Dependency Installed:
GeoIP-GeoLite-data.noarch 0:2015.12-1.el5 GeoIP-GeoLite-data-extra.noarch 0:2015.12-1.el5 gd-last.x86_64 0:2.2.1-2.el5.remi
geoipupdate.x86_64 0:2.2.1-2.el5 lcms2.x86_64 0:2.7-3.el5 php-pecl-jsonc.x86_64 0:1.3.10-1.el5.remi.5.6
php-pecl-jsonc-devel.x86_64 0:1.3.10-1.el5.remi.5.6 php-pecl-zip.x86_64 0:1.13.2-1.el5.remi.5.6
Updated:
GeoIP.x86_64 0:1.6.5-2.el5 GraphicsMagick.x86_64 0:1.3.23-5.el5 GraphicsMagick-doc.x86_64 0:1.3.23-5.el5
jasper-libs.x86_64 0:1.900.1-15.el5 lua.x86_64 0:5.1.4-4.el5 mysql.x86_64 0:5.5.50-1.el5.remi
mysql-libs.x86_64 0:5.5.50-1.el5.remi mysql-server.x86_64 0:5.5.50-1.el5.remi openssl.x86_64 0:0.9.8e-40.el5_11
php.x86_64 0:5.6.22-1.el5.remi php-bcmath.x86_64 0:5.6.22-1.el5.remi php-cli.x86_64 0:5.6.22-1.el5.remi
php-common.x86_64 0:5.6.22-1.el5.remi php-devel.x86_64 0:5.6.22-1.el5.remi php-gd.x86_64 0:5.6.22-1.el5.remi
php-imap.x86_64 0:5.6.22-1.el5.remi php-intl.x86_64 0:5.6.22-1.el5.remi php-ldap.x86_64 0:5.6.22-1.el5.remi
php-mbstring.x86_64 0:5.6.22-1.el5.remi php-mcrypt.x86_64 0:5.6.22-1.el5.remi php-oci8.x86_64 0:5.6.22-1.el5.remi
php-pdo.x86_64 0:5.6.22-1.el5.remi php-pecl-memcache.x86_64 0:3.0.8-3.el5.remi.5.6 php-pecl-pthreads.x86_64 0:2.0.10-1.el5.remi.5.6
php-pgsql.x86_64 0:5.6.22-1.el5.remi php-process.x86_64 0:5.6.22-1.el5.remi php-soap.x86_64 0:5.6.22-1.el5.remi
php-xml.x86_64 0:5.6.22-1.el5.remi php-xmlrpc.x86_64 0:5.6.22-1.el5.remi
Replaced:
php-mysql.x86_64 0:5.4.45-8.el5.remi
Note: I also had problems with MySQL upgrade (on CentOS 5.11 only). I had to run mysql_upgrade to fix things, but this is a different story which does not affect the above issue.
Thanks in advance for any help.
Nick