PhpMyAdmin "unable to load mysql extension, please check PHP configuration" solution

When you configure the php environment for the first time and use phpmyadmin, the system prompts "; unable to load mysql Extensions. check the PHP configuration"; ". I will introduce the solution to this problem. in the PHP runtime environment configured, and... when you configure the php environment for the first time and use phpmyadmin, the system prompts "unable to load mysql extensions, please check the PHP configuration" error. next I will introduce the solution to this problem.

After configuring the PHP runtime environment and installing the MySQl database, you can now learn how PHP interacts with MySQL.

Since MySQL is a database, it is essential to create databases, tables, fields, and other operations. in the illusion that we use ASP + ACCESS, however, for MySQL databases, by default, we do not have a visual interface for MySQl operations. Therefore, we often use phpMyAdmin to operate MySQL databases.

However, when we use the "PHP 5.2.3 installer" installation version, when we apply phpMyAdmin, the page prompts "unable to load mysql extensions, please check the PHP configuration.

1. First, check the PHP configuration file php. ini.

Open PHP under the php installation directory. ini file, Ctrl + F search for "php_mysql.dll", and delete ";" before "; extension = php_mysql.dll" to cancel comments, search for and modify the "extension_dir" value to the folder where the "php_mysql.dll" file is located, that is:

Extension_dir = "D: \ PHP \ ext \"

Extension = php_mysql.dll

2. However, the installation version used through this page does not save the ext folder of the PHP extension DLL file, so there is no php_mysql.dll. Of course there will be problems when we run phpMyAdmin.

Continue to open the http://www.php.net/downloads.php select "PHP 5.2.3 zip package" zip package file, and extract all the ext folders to the PHP installation directory, so there is extension_dir = "D: \ PHP \ ext \ "(note: The premise is that your PHP is installed on the D drive)

3. modified the php. ini file and added the ext folder containing php_mysql.dll. we recommend that you restart the computer and debug phpMyAdmin.

4. of course, if you modify the MySQL account and password in the config. inc. php file in the phpMyAdmin folder, we will not describe it here.

Modifications to config. inc. php: For the config. inc. php file, the most important thing is to modify the username and password of the phpMyAdmin connection to MySQL and find the code line:

// $cfg['Servers'][$i]['controluser'] = 'pma'; // $cfg['Servers'][$i]['controlpass'] = 'pmapass';

Delete the "//" comment and enter the username and password configured in MySQL. for remote servers, contact your space service provider. for example:

$cfg['Servers'][$i]['controluser'] = 'leosn_com';$cfg['Servers'][$i]['controlpass'] = '*********;

For details about the password of your MySQL database account, refer to (you set it yourself during installation ):

In addition, I searched for solutions to the next problem on the network. some solutions still need to use "php. the INI file and php_mysql.dll are copied to the c:/windows and c:/windows/system32 directories. this is because PHP is not an installed version, and the general installation version is not required, you can select "environment variable" in "My Computer" attribute "advanced" to view the system variable "Path", which indicates the PHP installation Path.

PhpMyAdmin "unable to load mysql extensions, please check the PHP configuration" to solve the problem. thanks for the guidance and reference, we can learn how to use PHP to interact with MySQL.

Address:

Reprinted at will, but please attach the article address :-)