Configuration method for apache+mysql+php+phpmyadmin under Windows

Apache server has nothing to say, try to go to the official website to download the latest.

There is a place to note: PHP Tutorial is loaded into the form of a module in the Apache container, that is, when you configure Apache loading PHP module, pay attention to the path of the problem. Specific configuration statement

LoadModule Php5_module D:/php/php5apache2.dll refers to the loading of PHP in module mode

Phpinidir "d:/php" is the location that indicates the configuration file php.ini for PHP

In this path try not to appear spaces, such as my path is LoadModule php5_module D:/peogram Files/php/php5apache2.dll This will lead to errors, you need to replace the relative path, such as ". /php/php5apache2.dll ", but the relative path must be correct, it depends on how you install each module, it is recommended to install in the Unified directory, easy to manage.

PHP has to be aware that this is a very troubling question. Here is the download of PHP

PHP 5.3 (5.3.5) window platform package download

VC9 x86 non thread safe (2011-jan-05 21:37:35)

• zip  [14.96MB]
  sha1:2fdd7b2b17d359725d9f297b6a59f17b71a913a6
• Font color= "#6466b3" >installer  [26.9mb]
  SHA1: d7cfd584231e68dc9e87cdff45a6d11fa3b03689
• debug pack  [7.94MB]
  sha1:414c30a12a402d3af30b46de4b2e0ca391872982

VC9 x86 thread safe (2011-jan-05 21:31:04)

• zip [15.1MB]
  sha1:7593b0ebba4b43418fd2f3c18eac83d698da46d6
• installer  [27.02mb]
  SHA1: db510126e3f9b580c38fb6dd8895e5a67403a223
• debug pack  [8.29MB]
  sha1:339f6092e4c4fee9c5a6a0f6d0f8359fbfbda60b

VC6 x86 non thread safe (2011-jan-06 19:06:20)

• Zip [13.13MB]
  sha1:b11a6a1597219d7ce10bc315cde411f37346383e
• Installer [23.84MB]
  Sha1:4249683e8b88ceed32bf12c0b883a51bb10e43d9
• Debug Pack [4.86MB]
  Sha1:9fb328a8c798bfe797e1a7f683571dc3812f3aa8

VC6 x86 thread safe (2011-jan-06 18:56:08)

• Zip [13.26MB]
  sha1:8658b5c58a9893d46290beb70aa2335226e2c523
• Installer [23.95MB]
  sha1:05fe4fb8f03a2f9fa71d47aad60e8c9becd6bb7d
• Debug Pack [5.03MB]
  SHA1:9D96D42B14F516EE5935404161836EC28B572BBF
• There are four of them for you to choose from. But be sure to choose the right.

• What is VC6?
  VC6 is legacy Visual Studio 6 compiler, which is compiled using this compiler.
  What is VC9?
  VC9 is the Visual Studio 2008 compiler, which is compiled with the Microsoft vs Editor.

  So how do we choose which version of PHP to download?
  If you are using apache+php under Windows, please select the VC6 version;
  If you are using iis+php under Windows, please select the VC9 version;

  So what's non thread safe?
  Non thread safe is not threaded;
  What is thread safe?
  Non thread safe is threaded;
  The authorities do not recommend that you apply non thread safe to the production environment, so we chose the thread safe version of PHP to use

  I chose VC6 x86 thread safe (2011-jan-06 18:56:08) because I was a Apache server built under Windows.

  Direct decompression of PHP is even installed. Follow the tutorial step-by-step walk is OK.

  The problems that often arise are:

  Unable to load dynamic library ' D:/server/php/ext/php_exif.dll '
  Unable to load dynamic library ' D:/server/php/ext/php_fdf.dll '
  Unable to load dynamic library ' D:/server/php/ext/php_ifx.dll '

  ......

  Similar error, the solution is

  1. Modify the Extension_dir configuration of the php.ini file to your correct php/ext/, as this folder contains all of your expansion modules, including MySQL tutorials.

  2. Copy the DLL files under your PHP installation directory, php/ext files under the DLL files to Widows/0system32, or you modify the system environment variable path, plus; d:/www/php;d:/www/php/ext; This is my installation directory. The effect of this implementation is the same as being copied below the System32, specific reasons I do not know why, I only know the program to run when the first to System32 below to find the corresponding library files to load, if found to stop, if you can not find the path below to find, if you can not find, Go to the configuration file Extesion_dir below to find, and then can not find the error, so if you have previously installed PHP4 on the computer, please first system32 the corresponding DLL file deleted.

  3. These loaded modules, is loaded or deleted in the php.ini inside the configuration

  similar to Extension=php_bz2.dll

  Extension=php_curl.dll

  Extension=php_fileinfo.dll

  Extension=php_gd2.dll

  Extension=php_gettext.dll

  ; Extension=php_gmp.dll

  Extension=php_intl.dll

  Be sure to take care not to start all of your modules, although the system resources waste is not much, but the default PHP5 installation package does not necessarily exist in the module's corresponding DLL, so you should follow the system error prompts the corresponding module to deactivate, deactivate the method, and you are how to open the module is the opposite.

  4. There are dependencies between modules, such as I want to open extension=php_exif.dll This module, then you must first open the Extension=php_mbstring.dll module, which may be the reason for your failure to add modules.

  
  

  Install MySQL is very simple, directly follow the prompts to install the line, do not need to be configured with the various modules of the server

  Due to the current phpMyAdmin version has been updated to 2.11.5.1, many of the online distribution methods are old versions, has not been adapted to the new version of the configuration requirements; so Flymorn by the way also put phpmyadmin2.11.5.1 configuration steps are listed below; To switch and debug PHP Convenient, I am using the Windows system, local debugging.
  
  1, first download phpMyAdmin installation package:
  To foreign official website http://www.phpmyadmin.net, click on the navigation bar "downloads" link into the download page, select the "All-languages.zip" version of the download to the local, decompression , place the uncompressed file in the phpMyAdmin folder (customizable folder name) under the system-specified virtual root directory, such as Flymorn's local storage location is d:wwwphpmyadmin.

  2, find the phpMyAdmin folder in the/libraries/config.default.php file (the old version is the root of the config.inc.php file), with the support of UTF-8 encoded WordPad open for editing.

  3. Find $cfg [' Pmaabsoluteuri ']
  Modify the URL for the phpmyadmin you will upload to the space
  such as: $cfg [' pmaabsoluteuri '] = ' http://www.piaoyi.org/phpmyadmin/';
  Here because I am debugging locally, I change to $cfg[' pmaabsoluteuri ' = ' http://localhost/phpmyadmin/';
  Note: Do not omit the last backslash/and the beginning of HTTP.

  4. Find $cfg [' Servers '] [$i] [' host '] = ' localhost '; (usually with the default, there are exceptions, you can not modify)

  5. Find $cfg [' Servers '] [$i] [' auth_type '] = ' config ';
  Debug in your own machine with config, if the space on the network with cookies, here we have added a URL before, we modify the cookie.
  I personally suggest: whether local or online, are recommended to set cookies, security first.
  Also, when the Auth_type value is set to a cookie, there is another place to make the appropriate changes:
  $cfg [' blowfish_secret '] = ';
  Change to: $cfg [' blowfish_secret '] = ' www.piaoyi.org ';
  The www.piaoyi.org here is freely defined, no more than 46 characters. If this place is left blank, the 2nd error mentioned above will appear: "The configuration file now requires a top-secret phrase password (blowfish_secret)."

  6. Find $cfg [' Servers '] [$i] [' user '] = ' root '; MySQL User (username, use root in your own machine), General online for your FTP user name, virtual host provider to tell you;

  7. Find $cfg [' Servers '] [$i] [' password '] = ' 123456 '; MySQL password (123456 modified to connect your MySQL database tutorial user password)

  8, find $cfg [' defaultlang '] = ' en '; (Here is the choice of language, en for the meaning of Simplified Chinese) there are $cfg [' defaultcharset '] = ' gb2312 '; (modify default encoding to GB)

  Here, phpMyAdmin has been configured to complete OK, you can open http://localhost/phpmyadmin/access to convenient and efficient graphical management software phpMyAdmin. For other options in the configuration file not mentioned in this article, you don't have to worry about it or change it. about how to operate phpMyAdmin is not covered in this article, but the graphical interface, is easy to understand, a little look will be used (reference).

  Here's a few questions to Flymorn in the process of installing configuration phpMyAdmin.

  first question: "Unable to load MCrypt extensions, check your PHP configuration."

  1, does not install the MySQL database correctly, in the system service MySQL related service does not start.
  2, in the system system32 (C:WINDOWSSYSTEM32) directory is missing libmcrypt.dll files, the solution is to find the PHP directory Libmcrypt.dll, and the Libmcrypt.dll copy to C: Windowssystem32 directory, and then restart the Web service.
  3, in the PHP directory in the php.ini file, there is no "; Extension=php_mcrypt.dll" in the front of a ";" Remove, so can not use the corresponding function, the solution is to open the php.ini file, find, Extension=php_mcrypt.dll changed to Extension=php_mcrypt.dll///remove front; make it effective
  4, the MySQL directory does not read permissions, the correct directory permissions are as follows:
  Administrator Full Control
  System Full Control
  User Read plus Run
  All other user rights are removed (also reserved, but not safe, recommended for deletion), and then restart the MySQL service and Web service (we recommend that you restart the server after modifying this item).
  5, the above methods are not possible, and then use this method: Desktop > My Computer > Right key properties > Advanced > Environment variable > System variable > New
  Name: Phpdir
  Value: c:php (what is your PHP directory?)
  (Reference Source: Address)

  second question: "Unable to load MySQL extensions, check your PHP configuration"

  Copy the Libmysql.dll in the PHP directory to: c:windowssystem32, then restart Apache.

  third question: "The configuration file now requires a top-secret phrase password (blowfish_secret)"

  Make sure that you have the correct settings in the config.default.php file:
  $cfg [' Servers '] [$i] [' Auth_type ']= ' cookies ';
  While
  $cfg [' blowfish_secret '] = ' www.piaoyi.org '; (This value is casually written, you cannot leave it blank)

  Actually this problem, I met really very depressed, if follow the configuration method that I mentioned above to do, should not prompt this error. After my 2 hours of constant modification of the config.default.php configuration file, always prompted this error, almost reached the edge of the crash.

  Then there is a flash, suddenly found: I changed the Auth_type Authentication mode to HTTP, to config, open the page always appear this error, that is to say, changed the authentication mode, and did not play a role in phpMyAdmin, Is it the other configuration file that determines the phpMyAdmin in effect?

  Immediately came to phpMyAdmin root directory, impressively found under the root directory there is a config.sample.inc.php file exists at the same time, there is a file config.inc.php also exist!! And this is the old version of the configuration file, the original is this document ramming ghost. Immediately delete config.inc.php, and then into the Debug page, the error disappeared! Solve the problem.

  It appears that the config.inc.php configuration file in the phpMyAdmin root directory has precedence over/libraries/ config.default.php configuration file High, the system is the first call to the root directory of the configuration file, and then the Libraries folder in the configuration file, Ai, this problem, toss for so long, alas. It's settled, I'm relieved.

  Fourth question: "#2003-server is not responding".

  Encountered this problem most of the MySQL database is not started, recommended directly in: Control Panel-management tools-services inside the MySQL boot. about whether to start, you can see in the Task manager whether there is "mysqld-nt.exe" such a process, if there is, then the MySQL has been started.
  
  Fifth: "No PHP extension settings mbstring found."

  Modify the php.ini file under C:windows, find the Extension=php_mbstring.dll, remove, save php.ini, and restart Apache.