Home / server / Questions / 1020827
Accepted
Pavel Tankov
Asked: 2020-06-11 01:00:07 +0800 CST

On CentOS7: Uninstalling mariadb-server also uninstalls php-mysql package

  • 772

On CentOS7: I need to upgrade MariaDB from 5.5 to 10.4

I followed this guide: https://itcloudnet.blogspot.com/2019/10/how-to-upgrade-mariadb-55-to-mariadb.html but instructions on other sites are similar.

When I do

yum remove mariadb-server mariadb-devel mariadb-libs mariadb

I get

Removing:
 mariadb
 mariadb-devel
 mariadb-libs
 mariadb-server
Removing for dependencies:
 perl-DBD-MySQL
 php-mysql
 postfix

Then I proceed with the instructions and do

yum install MariaDB-server MariaDB-client

and the output is

Installing:
 MariaDB-client
 MariaDB-server
Installing for dependencies:
 MariaDB-common
 MariaDB-compat
 boost-program-options
 galera-4

So, no php-mysql here. And the biggest mystery of all is that the PHP web applications using MariaDB still work!

How come? So, after all, do I need the package php-mysql or not?

Some clarifications:

  1. I use the standard Apache that comes with CentOS7 httpd-2.4.6.
  2. We have two legacy PHP applications that use the legacy PHP version which comes standard with CentOS7, namely php-5.4.
  3. We have one newer PHP application (Mediawiki) that needs newer PHP. So, I have installed php71 alongside with php-5.4, using Remi repository.
  4. I have switched Apache from mod_php to php-fpm.
  5. I have followed some online instructions how to make both legacy php-fpm-4.5 and the newer php71-php-fpm-7.1 (from Remi) work simultaneously on Apache - to serve both the two legacy and one newer web applications.

But my question still remains: Why my legacy PHP Web applications still work fine without the package php-mysql?

php mariadb

1 Answers

  1. Best Answer

    To access MariaDB or MySQL database, you need mysql or mysqli or pdo_mysql extension.

    The old php-mysql package have runtime dependency on libmysqlclient (that is removed with mariadb-libs)

    The alternative php-mysqlnd use the PHP Native Driver and provides the same set of extension.

    P.S.1. the mysql extension is deprecated and removed from PHP 7.

    • 1