The pdo_mysql or mysqli extension is missing on alt-php81

Issue

The pdo_myslq or mysqli extension exists in PHP Selector for PHP 8.1, but it doesn't work.

PHP Warning: PHP Startup: Unable to load dynamic library 'pdo_mysql.so' (tried: /opt/alt/php81/usr/lib64/php/modules/pdo_mysql.so (/opt/alt/php81/usr/lib64/php/modules/pdo_mysql.so: cannot open shared object file: No such file or directory), /opt/alt/php81/usr/lib64/php/modules/pdo_mysql.so.so (/opt/alt/php81/usr/lib64/php/modules/pdo_mysql.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0

Environment

• pdo_mysql
• alt-php81

Solution

1. Get MySQL server version with mysqld -V

2. Ensure that corresponding module installed. For example, MariaDB 10.3
    

   yum install alt-php81-mariadb103

3. Run the following command to restore PHP database bindings:

   /usr/bin/alt-php-mysql-reconfigure -v