Unable to load MYSQL extension. Please check PHP configuration

Source: Internet
Author: User
This problem is especially caused by the unavailability of the MYSQL plug-in after PHPMYADMIN updates PHP, in general, PHP and MYSQL have a series of integration packages. However, if this problem occurs, you can refer to the following solution: phpMyAdmin cannot load mysql extensions, check the PHP configuration solution in the PHP runtime environment configured, and "> <LINKhref =

This problem is especially caused by the unavailability of the MYSQL plug-in after PHPMYADMIN updates PHP, in general, PHP and MYSQL have a series of integration packages, but if this problem occurs, you can refer to the following solutions:
PhpMyAdmin "unable to load mysql extension, please check PHP configuration" solution

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.

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: PHPext "(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.

PhpMyAdmin solves the problem of "unable to load mysql extensions, please check the PHP configuration" (thanks for the guidance and reference with a smile). next we can learn how to use PHP to interact with MySQL.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.