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.