Ошибка расширение mysqli для php не установлено

I have a problem with phpmyadmin on ubuntu 12.04.
I have already installed apache2, php5, mysql and phpmyadmin.

The phpinfo(); script, don’t show nothing about mysqli or mysql extension.

When I try start phpmyadmin this error appear:

----
**phpMyAdmin - Error**
-------
**The mysqli extension is missing. Please check your PHP configuration.**
----

In the php.ini file, I uncommented extension=mysql.so line, but doesn’t work…

Anyone have another posible solution?

asked May 26, 2012 at 19:30

I solved this problem by editing /usr/local/zend/etc/php.ini.

(found it by doing netstat -nlp ¦ grep apache, then strace -p somepid ¦ grep php.ini).

At the end of the file, I added:

extension=/usr/lib/php5/20090626+lfs/mysql.so
extension=/usr/lib/php5/20090626+lfs/mysqli.so
extension=/usr/lib/php5/20090626+lfs/mcrypt.so

Adding it without the path did not work.

Then after a restart it worked.

answered Feb 26, 2013 at 21:27

For ubuntu user open your terminal and type following command

sudo apt-get install mysql

After that just restart apache2 by typing this

sudo service apache2 restart 

refresh you browser and enjoy phhmyadmin

answered Jan 15, 2019 at 13:15

answered Apr 13, 2013 at 13:56

Just add this line to your php.ini if you are using XAMPP etc. also check if it is already there just remove ; from front of it

extension= php_mysqli.dll

and stop and start apache and MySQL it will work.

answered Apr 18, 2019 at 10:10

You need the MySQLi module. This error usually occurs when manually installing phpMyAdmin.

sudo apt-get install php7.3-mysql

It will return you with.

[Creating config file /etc/php/7.3/mods-available/mysqlnd.ini with new version]

[Creating config file /etc/php/7.3/mods-available/mysqli.ini with new version]

Then.

sudo service apache2 restart.

Then.

Press F5 on your browser.

answered Jan 21, 2020 at 3:10

at ubuntu 12.04 i had to change mssql.compatability_mode = On.
put On and works

Since I had this problem following an upgrade, I just disable Apache2-php5

a2dismod php5

and activated php7

a2enmod php7

Hope it may help anybody!

answered Mar 26, 2019 at 12:08

I have encountered the same error on ubuntu and what worked for me was editing 2 lines in /etc/php/7.3/apache2/php.ini

  ;extension=mysqli to   extension=mysqli

and gave the extension variable location to mysqli.so after uncommenting it

   extension=/usr/lib/php/20170718/mysqli.so

then restart the service just to make sure

systemctl start mysql

answered Feb 5, 2020 at 15:30

For the record, my system is Ubuntu Server 20.04 and none of the solutions here worked. For me, I installed PHP 7.4 and I had to edit enter code here/etc/php/7.4/apache2/php.ini`.

Within this, search for ;extension=mysqli, uncomment and change mysqli to mysqlnd so it should look like this extension=mysqlnd. I tried using mysqli but I faced the same error as if I didn’t enable it but mysqlnd worked for me.

answered May 7, 2020 at 13:34

Had the very same problem, but in my case the reason was update of Ubuntu and php version — from 18.04 and php-7.2 up to 20.04 and php-7.4.

The Nginx server was the same, so in my /etc/nginx/sites-available/default was old data:

server {
  location /pma {
    location ~ ^/pma/(.+.php)$ {
      fastcgi_pass unix:/run/php/php7.2-fpm.sock;
    }
  }
}

I could not get phpmyadmin to work with any of php.ini changes and all answers from this thread, but at some moment I had opened the /etc/nginx/sites-available/default and realised, that I still had old version of php. So I just changed it to

fastcgi_pass unix:/run/php/php7.4-fpm.sock;

and the issue was gone, phpmyadmin magically started to work without any mysqli-file complaint. I even double checked it, but yeap, that’s how it works — if you have wrong version for php-fpm.sock in your nginx config file, your phpmyadmin will not work, but the shown reason will be ‘The mysqli extension is missing’

answered Oct 29, 2020 at 9:41

I hope my successful answer helps someone in recent times as I had to try many mix-and-matches and then found it:

This solution worked for me on Ubuntu 20.04 Desktop with PHP v7.4, PHP v8.0.7 and MySQL v8.0.25 setup.

What I did was edited /etc/php/7.4/apache2/php.ini and /etc/php/8.0/apache2/php.ini files and replaced
extension=mysqli.so
with
extension=/usr/lib/php/20190902/mysqli.so
in both the files.

Later, restarted both of these (PHP and MySQL) by sudo systemctl restart apache2 and sudo systemctl restart mysql. Refreshed Chrome, and phpMyAdmin responded with the login screen.

(UPDATE: Please check if you have /usr/lib/php/20200930/mysqli.so file as well. I tested this as it looked newer by directory date, and this too worked in both the PHP files as extension=/usr/lib/php/20200930/mysqli.so)

answered Jun 25, 2021 at 14:16

I have a problem with phpmyadmin on ubuntu 12.04.
I have already installed apache2, php5, mysql and phpmyadmin.

The phpinfo(); script, don’t show nothing about mysqli or mysql extension.

When I try start phpmyadmin this error appear:

----
**phpMyAdmin - Error**
-------
**The mysqli extension is missing. Please check your PHP configuration.**
----

In the php.ini file, I uncommented extension=mysql.so line, but doesn’t work…

Anyone have another posible solution?

asked May 26, 2012 at 19:30

I solved this problem by editing /usr/local/zend/etc/php.ini.

(found it by doing netstat -nlp ¦ grep apache, then strace -p somepid ¦ grep php.ini).

At the end of the file, I added:

extension=/usr/lib/php5/20090626+lfs/mysql.so
extension=/usr/lib/php5/20090626+lfs/mysqli.so
extension=/usr/lib/php5/20090626+lfs/mcrypt.so

Adding it without the path did not work.

Then after a restart it worked.

answered Feb 26, 2013 at 21:27

For ubuntu user open your terminal and type following command

sudo apt-get install mysql

After that just restart apache2 by typing this

sudo service apache2 restart 

refresh you browser and enjoy phhmyadmin

answered Jan 15, 2019 at 13:15

answered Apr 13, 2013 at 13:56

Just add this line to your php.ini if you are using XAMPP etc. also check if it is already there just remove ; from front of it

extension= php_mysqli.dll

and stop and start apache and MySQL it will work.

answered Apr 18, 2019 at 10:10

You need the MySQLi module. This error usually occurs when manually installing phpMyAdmin.

sudo apt-get install php7.3-mysql

It will return you with.

[Creating config file /etc/php/7.3/mods-available/mysqlnd.ini with new version]

[Creating config file /etc/php/7.3/mods-available/mysqli.ini with new version]

Then.

sudo service apache2 restart.

Then.

Press F5 on your browser.

answered Jan 21, 2020 at 3:10

at ubuntu 12.04 i had to change mssql.compatability_mode = On.
put On and works

Since I had this problem following an upgrade, I just disable Apache2-php5

a2dismod php5

and activated php7

a2enmod php7

Hope it may help anybody!

answered Mar 26, 2019 at 12:08

I have encountered the same error on ubuntu and what worked for me was editing 2 lines in /etc/php/7.3/apache2/php.ini

  ;extension=mysqli to   extension=mysqli

and gave the extension variable location to mysqli.so after uncommenting it

   extension=/usr/lib/php/20170718/mysqli.so

then restart the service just to make sure

systemctl start mysql

answered Feb 5, 2020 at 15:30

For the record, my system is Ubuntu Server 20.04 and none of the solutions here worked. For me, I installed PHP 7.4 and I had to edit enter code here/etc/php/7.4/apache2/php.ini`.

Within this, search for ;extension=mysqli, uncomment and change mysqli to mysqlnd so it should look like this extension=mysqlnd. I tried using mysqli but I faced the same error as if I didn’t enable it but mysqlnd worked for me.

answered May 7, 2020 at 13:34

Had the very same problem, but in my case the reason was update of Ubuntu and php version — from 18.04 and php-7.2 up to 20.04 and php-7.4.

The Nginx server was the same, so in my /etc/nginx/sites-available/default was old data:

server {
  location /pma {
    location ~ ^/pma/(.+.php)$ {
      fastcgi_pass unix:/run/php/php7.2-fpm.sock;
    }
  }
}

I could not get phpmyadmin to work with any of php.ini changes and all answers from this thread, but at some moment I had opened the /etc/nginx/sites-available/default and realised, that I still had old version of php. So I just changed it to

fastcgi_pass unix:/run/php/php7.4-fpm.sock;

and the issue was gone, phpmyadmin magically started to work without any mysqli-file complaint. I even double checked it, but yeap, that’s how it works — if you have wrong version for php-fpm.sock in your nginx config file, your phpmyadmin will not work, but the shown reason will be ‘The mysqli extension is missing’

answered Oct 29, 2020 at 9:41

I hope my successful answer helps someone in recent times as I had to try many mix-and-matches and then found it:

This solution worked for me on Ubuntu 20.04 Desktop with PHP v7.4, PHP v8.0.7 and MySQL v8.0.25 setup.

What I did was edited /etc/php/7.4/apache2/php.ini and /etc/php/8.0/apache2/php.ini files and replaced
extension=mysqli.so
with
extension=/usr/lib/php/20190902/mysqli.so
in both the files.

Later, restarted both of these (PHP and MySQL) by sudo systemctl restart apache2 and sudo systemctl restart mysql. Refreshed Chrome, and phpMyAdmin responded with the login screen.

(UPDATE: Please check if you have /usr/lib/php/20200930/mysqli.so file as well. I tested this as it looked newer by directory date, and this too worked in both the PHP files as extension=/usr/lib/php/20200930/mysqli.so)

answered Jun 25, 2021 at 14:16

I have a problem with phpmyadmin on ubuntu 12.04.
I have already installed apache2, php5, mysql and phpmyadmin.

The phpinfo(); script, don’t show nothing about mysqli or mysql extension.

When I try start phpmyadmin this error appear:

----
**phpMyAdmin - Error**
-------
**The mysqli extension is missing. Please check your PHP configuration.**
----

In the php.ini file, I uncommented extension=mysql.so line, but doesn’t work…

Anyone have another posible solution?

asked May 26, 2012 at 19:30

I solved this problem by editing /usr/local/zend/etc/php.ini.

(found it by doing netstat -nlp ¦ grep apache, then strace -p somepid ¦ grep php.ini).

At the end of the file, I added:

extension=/usr/lib/php5/20090626+lfs/mysql.so
extension=/usr/lib/php5/20090626+lfs/mysqli.so
extension=/usr/lib/php5/20090626+lfs/mcrypt.so

Adding it without the path did not work.

Then after a restart it worked.

answered Feb 26, 2013 at 21:27

For ubuntu user open your terminal and type following command

sudo apt-get install mysql

After that just restart apache2 by typing this

sudo service apache2 restart 

refresh you browser and enjoy phhmyadmin

answered Jan 15, 2019 at 13:15

answered Apr 13, 2013 at 13:56

Just add this line to your php.ini if you are using XAMPP etc. also check if it is already there just remove ; from front of it

extension= php_mysqli.dll

and stop and start apache and MySQL it will work.

answered Apr 18, 2019 at 10:10

You need the MySQLi module. This error usually occurs when manually installing phpMyAdmin.

sudo apt-get install php7.3-mysql

It will return you with.

[Creating config file /etc/php/7.3/mods-available/mysqlnd.ini with new version]

[Creating config file /etc/php/7.3/mods-available/mysqli.ini with new version]

Then.

sudo service apache2 restart.

Then.

Press F5 on your browser.

answered Jan 21, 2020 at 3:10

at ubuntu 12.04 i had to change mssql.compatability_mode = On.
put On and works

Since I had this problem following an upgrade, I just disable Apache2-php5

a2dismod php5

and activated php7

a2enmod php7

Hope it may help anybody!

answered Mar 26, 2019 at 12:08

I have encountered the same error on ubuntu and what worked for me was editing 2 lines in /etc/php/7.3/apache2/php.ini

  ;extension=mysqli to   extension=mysqli

and gave the extension variable location to mysqli.so after uncommenting it

   extension=/usr/lib/php/20170718/mysqli.so

then restart the service just to make sure

systemctl start mysql

answered Feb 5, 2020 at 15:30

For the record, my system is Ubuntu Server 20.04 and none of the solutions here worked. For me, I installed PHP 7.4 and I had to edit enter code here/etc/php/7.4/apache2/php.ini`.

Within this, search for ;extension=mysqli, uncomment and change mysqli to mysqlnd so it should look like this extension=mysqlnd. I tried using mysqli but I faced the same error as if I didn’t enable it but mysqlnd worked for me.

answered May 7, 2020 at 13:34

Had the very same problem, but in my case the reason was update of Ubuntu and php version — from 18.04 and php-7.2 up to 20.04 and php-7.4.

The Nginx server was the same, so in my /etc/nginx/sites-available/default was old data:

server {
  location /pma {
    location ~ ^/pma/(.+.php)$ {
      fastcgi_pass unix:/run/php/php7.2-fpm.sock;
    }
  }
}

I could not get phpmyadmin to work with any of php.ini changes and all answers from this thread, but at some moment I had opened the /etc/nginx/sites-available/default and realised, that I still had old version of php. So I just changed it to

fastcgi_pass unix:/run/php/php7.4-fpm.sock;

and the issue was gone, phpmyadmin magically started to work without any mysqli-file complaint. I even double checked it, but yeap, that’s how it works — if you have wrong version for php-fpm.sock in your nginx config file, your phpmyadmin will not work, but the shown reason will be ‘The mysqli extension is missing’

answered Oct 29, 2020 at 9:41

I hope my successful answer helps someone in recent times as I had to try many mix-and-matches and then found it:

This solution worked for me on Ubuntu 20.04 Desktop with PHP v7.4, PHP v8.0.7 and MySQL v8.0.25 setup.

What I did was edited /etc/php/7.4/apache2/php.ini and /etc/php/8.0/apache2/php.ini files and replaced
extension=mysqli.so
with
extension=/usr/lib/php/20190902/mysqli.so
in both the files.

Later, restarted both of these (PHP and MySQL) by sudo systemctl restart apache2 and sudo systemctl restart mysql. Refreshed Chrome, and phpMyAdmin responded with the login screen.

(UPDATE: Please check if you have /usr/lib/php/20200930/mysqli.so file as well. I tested this as it looked newer by directory date, and this too worked in both the PHP files as extension=/usr/lib/php/20200930/mysqli.so)

answered Jun 25, 2021 at 14:16

1. Узнать какой php.ini используется.

2. В файле php.ini эта строка:

   extension=mysqli
   

3. Заменить на:

   extension="C:phpextphp_mysqli.dll"
   

4. Перезагрузите apache

ответ дан 10 мая ’20, 07:05

Я знаю, что это было давно, но я столкнулся с этим и следил за другими ответами здесь, но безрезультатно, я нашел решение с помощью этого вопроса (Вопрос о переполнении стека)

По сути, просто нужно было отредактировать файл php.ini (мой был найден в c:xamppphpphp.ini) и раскомментировать эти строки…

;extension=php_mysql.dll
;extension=php_mysqli.dll
;extension=php_pdo_mysql.dll

После перезапуска apache все заработало как положено.

ответ дан 23 мая ’17, 11:05

• В папке Xampp откройте php.ini файл внутри папки PHP, т.е. xamppphpphp.ini (с текстовым редактором).

• Найдите extension=mysqli (Ctrl+F), если их два, ищем тот, который был раскомментирован (без «;» позади)

• Измените mysqli с правильным адресом пути, т.е. extension=C:xamppphpextphp_mysqli.dll.

• На панели управления Xampp остановите и запустите apache и MySQL.

Создан 15 июн.

Если с вашими конфигурационными файлами все в порядке, но проблема остается, установите php7.x-mysql в соответствии с версией установленного php.

Например, в моем случае я использую php7.3, поэтому я выполнил следующую команду, чтобы все настроить:

sudo apt install php7.3-mysql

systemctl reload apache2

ответ дан 12 мар ’21, в 11:03

Эта статья может вам помочь Настройка PHP с MySQL для Apache 2 или IIS в Windows. Посмотрите раздел «Настройка PHP и MySQL под Apache 2», пункт 3:

extension_dir = "c:phpextensions"      ; FOR PHP 4 ONLY 
extension_dir = "c:phpext"             ; FOR PHP 5 ONLY

Вы должны раскомментировать строку параметра extension_dir и указать абсолютный путь к каталогу расширений PHP.

Создан 04 июн.

sudo apt-get install php7.2-mysql

extension=mysqli.so (добавьте этот файл php.ini)

sudo service apahce2 restart

Используйте приведенные выше команды для устранения ошибки отсутствия расширения mysqli.

ответ дан 28 апр.

ответ дан 18 мая ’13, 07:05

Я искал часы, и никто не мог мне помочь. Я сделал простую вещь, чтобы решить эту проблему. (ОКНА 10×64)

Следуйте этим:

1 — Перейдите по пути к php_mysqli.dll (в моем случае: C:/xampp/php/ext);

2 — Переместите php_mysqli.dll в предыдущую папку (C:/xampp/php);

3 — Откройте php.ini и найдите строку: «расширение: php_mysqli.dll»;

4 — Измените путь, где находится ваш файл: extension=»C:xamppphpphp_mysqli.dll»;

5 — Перезапустите приложение (wampp, xampp и т. д.) и запустите Apache Server;

Проблема заключалась в пути ext/php_mysqli.dll, я попытался изменить строку на extension=»C:xamppphpextphp_mysqli.dll», но это не сработало.

Создан 01 сен.

Просто укажите каталог, в котором находятся загружаемые расширения (модули), в файле php.ini из

; On windows:
extension_dir="C:xamppphpext"

в

; On windows:
;extension_dir = "ext"

Затем включите расширение, если оно было отключено, изменив

;extension=mysqli

в

extension=mysqli

ответ дан 04 дек ’19, 09:12

У меня была такая же проблема, и я решил ее. Вы также можете решить эту проблему, если выполните следующие действия:

1. вам нужно установить PHP для С:/php
   или ваша текущая версия найдите его по этому пути и укажите его как системную переменную

2. затем откройте программу xampp, нажмите «config», откройте php.ini и раскомментируйте следующие строки:

   extension=pdo_mysql
   extension=pdo_mysql
   extension=openssl
   

ответ дан 27 мар ’20, в 21:03

Я столкнулся с этой проблемой сегодня, и в конце концов я понял, что это был комментарий к строке перед dll mysql, которая вызывала проблему.

Это то, что вы должны иметь в php.ini по умолчанию для PHP 5.5.16:

;extension=php_exif.dll       Must be after mbstring as it depends on it
;extension=php_mysql.dll
;extension=php_mysqli.dll

Помимо удаления точек с запятой, вам также необходимо удалить строку комментария, которая идет после php_exif.dll. Это оставляет вас с

extension=php_exif.dll      
extension=php_mysql.dll
extension=php_mysqli.dll

В моем случае это решает проблему.

ответ дан 27 авг.

Создан 23 сен.

Это проблема каталога расширений. Вам нужно вручную изменить каталог расширения php, чтобы это работало.

Если вы используете сервер AMPP, выполните следующие действия.

Перейти к настройкам -> PHP -> Конфигурация

найти в php7.3.ini (версии могут измениться)

extension_dir = «» , (уже есть некоторый путь)

и измените значение на

extension_dir = «C:Program FilesAmppsphp-7.3ext»

Если вы используете XAMP

Перейти к настройкам XAMP, Apache -> PHP.ini

Найдите extension_dir = в php.ini и установите путь к папке расширения php на вашем локальном компьютере. См. приведенный ниже пример.

extension_dir = «C:phpext» (Правильно проверьте свой путь)

ответ дан 25 апр.

В моем случае у меня была аналогичная проблема после полной установки Debian 10.

Командная строка:
php -v показать, что я использую php7.4 но распечатать phpinfo() дает мне php7.3

Решение: отключить php7.3, включить php7.4.

   $ a2dismod php7.3
    
   $ a2enmod php7.4
    
   $ update-alternatives --set php /usr/bin/php7.4
   $ update-alternatives --set phar /usr/bin/phar7.4
   $ update-alternatives --set phar.phar /usr/bin/phar.phar7.4
   $ update-alternatives --set phpize /usr/bin/phpize7.4
   $ update-alternatives --set php-config /usr/bin/php-config7.4

ответ дан 16 авг.

Замените

include_path=C:Program Files (x86)xamppphpPEAR

со следующими

include_path="C:Program Files (x86)xamppphpPEAR"

т.е. добавьте запятые, я проверил журналы ошибок apache, он показывал синтаксическую ошибку, поэтому проверил весь файл на наличие синтаксических ошибок.

ответ дан 20 дек ’20, 22:12

Создан 08 июн.