The perfect solution for unable to load mysql extension_PHP tutorial

phpMyAdmin "Unable to load mysql extension, please check PHP configuration" solution

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

Since MySQL is a database, it is essential to establish databases, tables, fields and other operations (under the assumption that we use ASP+ACCESS). However, for the MySQL database, there is no visual interface when we install it by default. It operates MySQl, so we often use phpMyAdmin to operate the MySQL database.

However, through the use of the "PHP 5.2.3 installer" installation version, when we apply it to phpMyAdmin, a prompt "Unable to load the mysql extension, please check the PHP configuration" appears on the page.

1. First, let’s check the PHP configuration file php.ini

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

extension_dir = "D:PHPext"

extension=php_mysql.dll

2. However, the installation version used on this page does not have the ext folder that saves 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 http://www.php.net/downloads.php, select the "PHP 5.2.3 zip package" compressed package file, and extract all the ext folders to the PHP installation directory, so there is extension_dir = "D:PHPext" (Note: The premise is that your PHP is installed on the D drive)

3. Completed the modification of the php.ini file and the addition of the ext folder containing php_mysql.dll. It is recommended to restart the computer and then 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 related solutions to this problem on the Internet. Some solutions require copying "php.ini file and php_mysql.dll to the c:/windows and c:/windows/system32 directories". This is because PHP is a non-installation version, which is not required for general installation versions. You can select "Environment Variables" in the "Advanced" properties of "My Computer" to view the system variable "Path", which specifies the installation path of PHP.

phpMyAdmin "Unable to load the mysql extension, please check the PHP configuration" problem has been solved (thank you Hanxiao for your guidance and reference). Now you can learn to use PHP to interact with MySQL.

http://www.bkjia.com/PHPjc/364569.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/364569.htmlTechArticlephpMyAdmin cannot load the mysql extension. Please check the PHP configuration solution. Configure the PHP operating environment and install it. After understanding the MySQl database, you can learn how to use PHP with MyS...