Shulou(Shulou.com)06/01 Report--

This article is about solutions to the lack of mysqli extensions in phpmyadmin. The editor thought it was very practical, so I shared it with you as a reference. Let's follow the editor and have a look.

PhpMyAdmin error missing mysqli extension. Please check the solution of PHP configuration

PhpMyAdmin is missing a mysqli extension. Please check the solution for PHP configuration: missing mysqli extension. Please check the PHP configuration.

Opening your php.ini- > is usually in the C:WINDOWS directory. find

The code is as follows:

; extension=php_msql.dll;extension=php_mssql.dllextension=php_mysql.dllextension=php_mysqli.dll

Which extension needs to be enabled, just remove the semicolon in front of this line, and pay attention to restart Apache

Or IIS solution steps: 1. See if there is a php_mysqli.dll file in php's ext directory. If so, continue with the following steps. If not, reinstall a php2. Open php.ini and find

The code is as follows:

; extension=php_mysqli.dll

Change the preceding semicolon ";" to

The code is as follows:

Extension=php_mysqli.dll

3. find

The code is as follows:

; extension_dir= ". / ext"

Remove the previous semicolon ";" and change it to (ext directory relative to php's installation path)

The code is as follows:

Extension_dir = "e:\ php\ ext"

E:php is the storage directory of php

4. Copy php.ini to c:windows 5. Copy libmysql.dll to the System32 directory under Windows (this is critical) 6. Restart IIS (not a website)

Run iisreset / RESTART under cmd

If the above method does not work, you can refer to the following method

The first step is to output phpinfo () to see if the MySQL module is loaded successfully. If it is successfully loaded, you have seen the hell, otherwise see step 2.

Why does phpinfo () have no mysql module under IIS? The original php was installed with .msi, but it was all redone and installed in the form of a compressed package. Configure php.ini again, copy to windows, copy libmysql.dll to system32. And then the test was successful. Step two, check

Whether the setting of extension_dir is correct step 3, check whether to copy the libmysql.dll file to c:windowssystem32

1. The Mysql database is not installed correctly, and the Mysql-related services are not started in the system service (please see how to install Mysql correctly)

2. Missing in the system32 (C:windowssystem32) directory of the system

Libmysql.dll file, the solution is to find the libmysql.dll in the php directory, copy the libmysql.dll to the C:windowssystem32 directory, and then restart the Web service.

3. In the php.ini file under the C:windows directory, the previous ";" in "; extension=php_mysql.dll" is not removed, so the corresponding function cannot be used. The solution is to open the php.ini file.

4. Mysql directory does not have read permissions. The correct directory permissions are as follows: administrator controls system completely.

Full control of user read and run other user rights are deleted (can also be retained, but not very secure, it is recommended to delete), and then restart the MYsql service and Web service.

You may report such an error when you open phpmyadmin

Missing mysqli extension. Please check the PHP configuration.

You can check it in the following ways:

1. Check whether php.ini; extension=php_mysqli.dll is enabled, that is, remove the previous

two。 This step is critical to check whether the php.ini extension_dir address points to the ext directory of the php directory.

I'm just at this point. I just set extension_dir = "e:\ www\ php54\ ext" to my own directory.

3. Check to see if lib_mysql.dll has been copied to the windows directory. This dll file is available in many forms.

Do you have an ununderlined libmysql_d.dll, so pay attention to it for yourself

4. Check the php installation directory under the ext directory. Whether the php_mysqli.dll file exists on the Internet also indicates that it is best to use the zip package to extract it.

There will be no file loss.

5. Check the php details page to see if mysql and mysqli have started this step is to check if you have enabled mysqli.

You can't find the mysqli keyword on the php detail page.

Finally, pay attention to it! Restart Apache

Thank you for reading! This is the solution to the lack of mysqli extension in phpmyadmin. I hope the above content can be of some help to you, so that you can learn more. If you think the article is good, you can share it and let more people see it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.