Solution to the lack of mysqli extension in phpmyadmin _ php instance

This article describes in detail how to solve the problem of mysqli extension in phpmyadmin. For more information, see phpMyAdmin. the error message "mysqli extension" is missing. Check the PHP configuration solution.

PhpMyAdmin lacks the mysqli extension. Check the PHP configuration solution:
The mysqli extension is missing. Check the PHP configuration.

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

The code is as follows:

; Extension = php_msql.dll
; Extension = php_mssql.dll
Extension = php_mysql.dll
Extension = php_mysqli.dll

To enable the extension, remove the semicolon before this line. restart Apache or IIS.

Solution:
1. check whether the php ext directory contains the php_mysqli.dll file.
If yes, continue with the following steps. Reinstall php if no
2. open php. ini and find

The code is as follows:

; Extension = php_mysqli.dll

Remove the semicolon ";" and change it

The code is as follows:

Extension = php_mysqli.dll

3. find

The code is as follows:

; Extension_dir = "./ext"

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

The code is as follows:

Extension_dir = "e: \ php \ ext"

E: php is the directory for storing 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 in cmd

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

Step 1: output phpinfo () to check whether the MySQL module is successfully loaded. if the MySQL module is successfully loaded, you will be confused. otherwise, check the second step,

Why does phpinfo () have no mysql module in IIS?
The original php was installed by. msi, and all of them were re-installed in the form of a compressed package.
Copy the php. ini file to windows and copy libmysql. dll to system32.
Then the test is successful...
Step 2: Check whether the settings of extension_dir are correct.
Step 3: Check whether the libmysql. dll file is copied to c: windowssystem32.

1. the Mysql database is not correctly installed, and Mysql-related services are not started in the system service (please check the correct method for installing Mysql)

2. libmysql is missing in the system32 (C: windowssystem32) Directory of the system. dll file. the solution is to find libmysql in the php directory. dll, and libmysql. copy the dll to the C: windowssystem32 directory and restart the Web service.

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

4. the Mysql Directory has no read permission. the correct directory permission is as follows:
Full administrator control
Full system control
User reading and running
You can delete all other user permissions (which can be retained, but the security is not high. we recommend that you delete them), and then restart MYsql and Web services.

This error may be reported when you open phpmyadmin,

The mysqli extension is missing. Check the PHP configuration.

You can perform the following checks:

1.Check whether php. ini; extension = php_mysqli.dll is enabled or not;

2.Check php. if the ini extension_dir address points to the ext Directory of the php Directory, this step is critical. I am on this step. I will set extension_dir = "e: set \ www \ php54 \ ext "to your own directory.

3.Check whether lib_mysql.dll has been copied to the windows directory. this dll file has multiple forms of ununderlined libmysql_d.dll.

4.Check whether the php_mysqli.dll file exists online in the ext Directory of the php installation directory. it also indicates that it is best to decompress the zip package without File loss.

5.View the php details page <? Php phpinfo () ;?>, Check whether mysql and mysqli have been started. This step is to check whether you have enabled mysqli.
If the mysqli keyword is not enabled, you cannot view it on the php details page.

Last Note !!!! Restart Apache

Supplement:

After a whole day, I still haven't done a good job. I have read a lot of online solutions, but it's useless.

First, I absolutely guarantee that:

1: I have definitely removed the; extension_dir = "C:/myenv/php-5.3.5/ext" Semicolon in php. ini,
The path is also written. This exclusion

2: I have enabled the mysql function. in php. ini, go to extension = php_mysql.dll.

Extension = php_mysqli.dll

3: php ext files include php_mysqli.dll and php_mysql.dll.

4: php and apache integration are feasible. phpinfo () can be displayed, but mysql blocks cannot be found.
Only the mysqlnd option is available, and Configuration File (php. ini) Path C: \ WINDOWS is excluded.

5: I thought of modifying System Variables. some people on the Internet say php. ini, **. dll replication.
Go to windows or syetem32. However, this is not used to exclude

6. there is no way to reinstall and uninstall it many times. The problem cannot be solved. in dos, mysql can be started.

For a high-score solution, do not propose the above method. it is useless. Help me analyze and analyze. Solve the problem and give 50 more points!
Phpadmin versions have also been changed. Or not.

Finally solved the problem. If you encounter this situation, and the above method is useless. Try the following method.

1. copy ../mysql/bin/libmySQL. dll to php5.0 and to the php5.0/ext directory.
2. copy the libmySQL. dll php5ts. dll files to windows/system32.
3. copy the php. ini file under the php5.0 root directory to the windows directory (provided that php. ini must be configured)
4. if there is no problem at this time, you can connect to the database for testing. In fact, the key step to this problem is libmySQL. dll file, which is not included in the original php5.0, but libmySQL in the mysql file. dll