Title resolution: unable to load MYSQL expansion, please check the PHP configuration

Source: Internet
Author: User
PhpMyAdmin "cannot be loaded into mysql expansion, please check the PHP configuration" solution after the PHP runtime environment is configured and the MySQl database is installed, next we can learn how PHP interacts with MySQL. Since MySQL is a database

PhpMyAdmin "cannot be loaded into mysql expansion, please check the 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 establish the control of databases, tables, fields and so on (in the case that we apply asp access). However, for MySQL databases, by default, we do not have a visual interface to control MySQl. Therefore, we often use phpMyAdmin to control MySQL databases.

However, when "PHP 5.2.3 installer" is used to install the application, when phpMyAdmin is used, the page displays the prompt "cannot be loaded into mysql for expansion, 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 the comment, 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 of the application through this page does not retain the ext folder for PHP to expand the DLL file, so there is no php_mysql.dll. of course, the title will be displayed when we run phpMyAdmin.

Open the http://www.php.net/downloads.php, select the "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 condition is that your PHP is installed on the D drive)

3. corrected the php. ini file and added the ext folder containing php_mysql.dll. we recommend that you restart the next disk 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 the corresponding solution under the title on the internet. some solutions still need to refer to "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's title "cannot be loaded into mysql for expansion, please check the PHP configuration" (thanks for the reference of the smiling leaders). next we can learn how to control the interaction between PHP and 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.