Unable to load dynamic library 'mysqli'

[tomaszbadon]

Hi there,

I installed PHP 7.4 on my Mac using home brew using a tutorial:

https://getgrav.org/blog/macos-bigsur-apache-multiple-php-versions

and I enabled mysql in php.ini

The problem is that if I type php in the command line I receive:

PHP Warning: PHP Startup: Unable to load dynamic library 'mysqli' (tried: /usr/local/lib/php/pecl/20190902/mysqli (dlopen(/usr/local/lib/php/pecl/20190902/mysqli, 9): image not found), /usr/local/lib/php/pecl/20190902/mysqli.so (dlopen(/usr/local/lib/php/pecl/20190902/mysqli.so, 9): image not found)) in Unknown on line 0

It's quite strange because I configured this particular version with apache2 in http.conf and I am able to use this mysql library.

phpinfo(); displays also that mysqli is available.

If I run php -a it allows me to execute: $link = mysqli_connect("localhost:3306", "user1", "password", "test");.

I'd appreciate you help.

Thank you in advance.

BR,

Tomasz

[shivammathur]

To fix this run this command.

php --ini

It will print the path to loaded configuration file and additional .ini files.
For example:

Configuration File (php.ini) Path: /usr/local/etc/php/7.4
Loaded Configuration File:         /usr/local/etc/php/7.4/php.ini
Scan for additional .ini files in: /usr/local/etc/php/7.4/conf.d
Additional .ini files parsed:      /usr/local/etc/php/7.4/conf.d/ext-opcache.ini

check these files, if they have a line extension=mysqli, please remove that line as both mysqli and mysqlnd extensions are compiled statically into php binary and do not need to be loaded using a ini file.

If you are not able to find any such line, remove the PHP 7.4 along with its configuration and install it again.

brew remove php@7.4
sudo rm -rf $(brew --prefix)/etc/php/7.4

brew update
brew install shivammathur/php/php@7.4
brew link --force --overwrite php@7.4

Restart your terminal, and test php version php -v

[tomaszbadon]

Thank you. It works perfectly. BR, Tomasz

…

Wiadomość napisana przez Shivam Mathur ***@***.***> w dniu 21.12.2020, o godz. 16:53: To fix this run this command. php --ini It will print the path to loaded configuration file and additional .ini files. For example: Configuration File (php.ini) Path: /usr/local/etc/php/7.4 Loaded Configuration File: /usr/local/etc/php/7.4/php.ini Scan for additional .ini files in: /usr/local/etc/php/7.4/conf.d Additional .ini files parsed: /usr/local/etc/php/7.4/conf.d/ext-opcache.ini check these files, if they have a line extension=mysqli, please remove that as both mysqli and mysqlnd extensions are compiled statically into php binary and do not need to be loaded using a ini file. If you are not able to find any such line, remove the PHP 7.4 along with its configuration and install it again. brew remove ***@***.*** sudo rm -rf /usr/local/etc/php/7.4 brew update brew install ***@***.*** brew link --force --overwrite ***@***.*** Restart your terminal, and test php version php -v — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#73 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ASHGQIQSYUL3GMGLUHYX55LSV5VQ3ANCNFSM4VEMROUA>.