When phpmyadmin is installed, the solution "mysql extension cannot be loaded. Check the PHP configuration" appears.

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

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

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 it to 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. in the ini file, Ctrl + F search for "php_mysql.dll" and delete ";" before "; extension = php_mysql.dll" to cancel comments, search for and modify the value of "extension_dir" 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.

Open the "PHP 5.2.3 zip package" zip package file and decompress all the ext folders to the PHP installation directory. Therefore, 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, modify the MySQL account and password in the config. inc. php file in the phpMyAdmin folder.

In addition, I searched for solutions to the next problem on the network. 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.