Php5.2 and later versions

Source: Internet
Author: User
Tags mysql login
After php5.2 and later versions are installed and the extension Library is installed with phpmyadmin, the common problem is that the mysql extension cannot be loaded. check the php configuration. If you are using a php version later than php5.2, note that php has made some changes to the service's extended functions. that is to say, you have to adjust the installation methods of php and extensions. There are two major adjustments: first, the PHP. INI PHP5.2 and later versions and the extension Library installation.

After installing phpmyadmin, you often encounter the following error: "mysql extension cannot be loaded. check the php configuration ".

If you are using a php version later than php5.2, note that php has made some changes to the service's extended functions. that is to say, you have to adjust the installation methods of php and extensions.

There are two major adjustments: in PHP5.2 and later versions, the PHP. ini file does not need to be added to the WINDOWS directory. Second, library files such as "mysql extension" C: \ PHP \ libmcrypt. the dll must be copied to the C: \ PHP \ ext Directory, instead of the c: \ windows \ system32 directory in the old version.

For detailed installation steps, see the following:

1. decompress PHP5.2.X to your installation directory, such as C: \ PHP.

2. in the apache configuration file http. conf, add the following code to enable apache to load php as a module:

LoadModule php5_module "c:/php/php5apache2_2.dll"
AddType application/x-httpd-php. php

3. in the apache configuration file http. conf, add the following code to specify the Directory of the PHP. ini file:

PHPIniDir "C:/php"

4. rename the PHP.INI-DIST to PHP. INI and edit the C: \ PHP. INI file:
Find extension_dir = "./"
Changed to extension_dir = "C: \ php \ ext"
Find; extension = php_mysql.dll
Remove the semicolon.

5. now is the most important step. note: Copy C: \ PHP \ libmysql. dll to the C: \ PHP \ ext directory to support MYSQL extension libraries,
In the configuration file of APACHE2.2, add
LoadFile C: \ php \ php5ts. dll
LoadFile C: \ php \ libmysql. dll

6. restart the WEB service

7. for IIS users, the change content is the same as above. copy the PHP. ini file to % STSTEMROOT %.

After completing the preceding operations, restart the service.


After all services are configured, install PhpMyAdmin. the Message "unable to load mcrypt extensions, please check the PHP configuration" appears. the solution to this problem is as follows:

1. edit the configuration file HTTPD. CONF of APACHE2.2.X and add LoadFile C: \ php \ libmcrypt. dll.

2. Copy C: \ PHP \ libmcrypt. dll to C: \ PHP \ ext for the complete extension file.

3. edit the C: \ PHP. ini file and find; extension = php_mcrypt.dll. remove the semicolon ";"

If, when PhpMyAdmin is installed, the following error occurs: "mbstring is not found for PHP extensions, but the wide character set seems to be used in the current system. phpMyAdmin without mbstring extensions cannot correctly recognize strings, an unexpected result may be returned. the solution to this problem is as follows:
Edit C: \ PHP. INI and find; extension = php_mbstring.dll. remove the semicolon ";"

After completing the preceding operations, restart the service again.

Finally, some basic configurations before PHPMYADMIN3 are used. This configuration is for phpMyadmin3.0 and later versions.

Before configuration, make sure that you have correctly configured the PHP runtime environment as described above.

The configuration procedure is as follows:

1. copy phpMyAdmin \ libraries \ config. default. php to The phpMyAdmin root directory and rename it config. inc. php.

2. edit config. inc. php.

$ Cfg ['blowfish _ secret'] = ''; changed to $ cfg ['blowfish _ secret'] = 'abc'. you can enter any character in either single quotes.
$ Cfg ['servers'] [$ I] ['auth _ type'] = 'config '; change to $ cfg ['servers'] [$ I] ['auth _ type'] = 'cooker ';

After saving, refresh the page and enter the MYSQL login account and password.

If the Cookies must be enabled to log on, clear the Cookies of the browser.

Http://student.csdn.net/space.php? Uid = 435961 & do = blog & id = 36724

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.