Problem Resolution: Unable to load MySQL extensions, please check the PHP configuration

Source: Internet
Author: User
Tags ini mysql mysql in php file php and mysql database phpmyadmin

phpMyAdmin "Unable to load MySQL extensions, please check the PHP configuration" workaround

After configuring the running environment of PHP and installing the MySQL database, you can learn how PHP interacts with MySQL in the following.

Since MySQL is a database, it is essential to establish databases, tables, fields and other operations (the illusion that we use the asp+access case), however, for MySQL database, in our default installation is not a visual interface to operate MySQL, So we often use phpMyAdmin to operate the MySQL database.

However, with the use of the "PHP 5.2.3 Installer" Installation version, when we apply to phpMyAdmin, the page appears "Unable to load MySQL extensions, please check the PHP configuration" prompts.

1, first, we'll check the PHP configuration file php.ini

Open the directory of PHP installed php.ini file, ctrl+f search "Php_mysql.dll", will "; Extension=php_mysql.dll" before ";" Delete to uncomment, and search for and modify the folder where the value of "Extension_dir" is the "Php_mysql.dll" file. That

Extension_dir = "D:\PHP\ext\"

Extension=php_mysql.dll

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

Continue to open http://www.php.net/downloads.php Select the "PHP 5.2.3 Zip Package" Compression package file, the Ext folder in which all of the folders are unzipped to the installation directory of PHP, so have a extension_dir = "D : \php\ext\ "(Note: If your PHP is installed in D disk)

3, the completion of the php.ini file changes and contains Php_mysql.dll Ext folder Add, it is recommended to restart the computer, and then debug phpMyAdmin

4, of course, for the phpMyAdmin folder in the config.inc.php file for MySQL account and password changes.

In addition, the network search for the next issue related to the solution, and some solutions also need to "php.ini files and Php_mysql.dll copy to the c:/windows and C:/windows/system32 directory", which is because PHP is not installed version, The general installation version is not needed, you can select "Environment variable" in the "My Computer" attribute "advanced" to view the system variable "path" which indicates the installation path of PHP.

phpMyAdmin "Unable to load MySQL extensions, please check the PHP configuration" problem Resolution (thanks to the Smiling Guide reference), the following can learn to use PHP interaction with MySQL.



Related Article

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.