What to do if mysqli extension is missing in phpmyadmin

The following column of phpmyadmin usage tutorial will introduce to you the solution to the problem of missing mysqli extension in phpmyadmin. I hope it will be helpful to friends who need it. help!

#phpMyAdmin Error The mysqli extension is missing. Please check the solution for PHP configuration

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

Open your php.ini->usually in the C:WINDOWS directory. Find the

code 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. Be sure to restart Apache

## or IIS Solution steps: 1. Check if there is a php_mysqli.dll file in the ext directory of php. If so, continue with the following steps. If not, reinstall php2. Open php.ini and find the

code as follows:

;extension=php_mysqli.dll

Remove the semicolon ";" in front and change it to

The code is as follows:

extension=php_mysqli .dll

3. Find the

code as follows:

;extension_dir="./ ext"

Remove the semicolon ";" in front and change it to (ext directory relative to the php installation path)

The code is as follows:

extension_dir = "e:\php\ext"

e:php is the storage of php Directory

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

# Run iisreset/RESTART under cmd

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

The first step, output phpinfo() to see if the MySQL module is successfully loaded. If it is successfully loaded, you are in trouble. Otherwise, see the second step,

phpinfo under IIS ()What is the reason why there is no mysql module? The original php used was installed with .msi, but later I had to do it all over again and installed it in a compressed package. Then configure php.ini, copy it to windows, and copy libmysql.dll to system32. Then the test was successful. . . The second step is to check whether the
extension_dir setting is correct. The third step is to check whether the libmysql.dll file is copied to c:windowssystem32.

1. The Mysql database is not installed correctly. In the system service, Mysql-related services are not started (please check the method of correctly installing Mysql)

2.
libmysql is missing in the system's system32 (C:windowssystem32) directory. dll file, the solution is to find libmysql.dll in the php directory, copy libmysql.dll to the C:windowssystem32 directory, and then restart the web service.

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

4. The Mysql directory does not have read permissions. The correct directory permissions are as follows: administrator Full control system
Full control user Read and add Delete all other user permissions to run (you can also keep them, but the security is not high, so it is recommended to delete them), and then restart the MYsql service and Web service.

When you open phpmyadmin, you may get an error like this,

The mysqli extension is missing. Please check PHP configuration. target="documentation"> width= "11" style="max-width:90%" alt="What to do if mysqli extension is missing in phpmyadmin"
title="What to do if mysqli extension is missing in phpmyadmin" />

You can follow the following methods Check:

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

##2. Check whether the php.ini extension_dir address points to the ext directory of the php directory. This step is key. I am at this step. I set extension_dir = "e:\www\php54\ext" to myself. The directory is fine

3. Check whether lib_mysql.dll has been copied to the windows directory. This dll file has many forms. Is there any underlined libmysql_d.dll? Therefore Pay attention to yourself

4. Check the ext directory of the PHP installation directory to see if the php_mysqli.dll file exists online. It also indicates that it is best to use the zip package to decompress There will be no file loss

5. Check the php details page ?> to see if mysql and mysqli have been started. This step is to check whether you have enabled them. If mysqli is not turned on
If you search for the mysqli keyword, you will not be able to see it on the php detailed page

Finally, pay attention! ! ! ! Restart Apache

The above is the detailed content of What to do if mysqli extension is missing in phpmyadmin. For more information, please follow other related articles on the PHP Chinese website!