WinXP SP2 Apache 2.047 and PHP5.0.0B1 and MySQL-4.0.14 and PHPMYADMIN-2.5.3-RC1 correct installation and configuration

On February 16, 2005 I have encountered a lot of problems in learning, but I finally dial the cloud fog with the help of many friends. Time is easy for forgetting a lot, but there are too many people who want to thank. It can't forget. Slightly summarize, in order to see it. 1> Installation Configure PHP 1. Decompose the PHP compression package to C: / PHP / 2. Copy the PHP4TS.DLL and C: / PHP / DLLS directory under the C: / PHP / DCC to the Windows installation directory system Folder (Win9x / ME is System Directory, WinNT, 2K / WinXP, 2003 is System32 directory) Copy C: /php/php.ini-dist to Windows installation directory (eg: c: / windows), and Rename called php.ini. Use Notepad to open, modify the information: Search for extension_dir = ./ This line, point your path to the extensions directory under your php directory, such as: extension_dir = C: / PHP / EXTENSIONSONS If you want to support more modules, Search:; Windows Extensions; Note That MySQL And ODBC Support Is Now Built in, SO No DLL IS NEEDED for IT .; Believe in the next announcing module, if you want PHP to support a module, Please save the previous ";" and then modify it, save the PHP.ini to complete the installation and configuration of PHP. We join a row extension = php_mysql.dll // Note 1: The Extension Dir Need Not Be "./", As Hermawan Mentioned. It works fine for me with the extensions Subdir where the Other Extensions Are Located.//note 2 : The PHP.INI File NEED NOT BE IN THE ROOT, AS LARS MENTIONED. IT Works Fine for Me in the Windows Dir. <2> Install APACH21. Backup C: / Program Files / Apache Group / Apache2 / Conf / Httpd. Conf file.

2. Use Notepad to open C: / Program files / apache group / apache2 / conf / httpd.conf found: #NameVirtualHost * Modified to: NamevirtualHost 127.0.0.1 // or localhost find: Modify the following lines : ServerAdmin (installed when you just entered administrator mailbox) DocumentRoot C: / Program Files / Apache Group / Apache2 / htdocsServerName Apache2ErrorLog C: / Program Files / Apache Group / Apache2 / logs / error_logCustomLog C: / Program Files / Apache Group / apache2 / logs / access_log common found: AddType application / x-tar .tgz below in the following two lines: AddType application / x-httpd-php .phpAddType image / x-icon .ico found: #LoadModule ssl_module modules /mod_ssl.so Add a line: loadModule php5_module c: ///sapi/php4apache2.dll // Here PHP5_MODULE is the key, if PHP4_Module Apache can't start adding the default file: find DirectoryIndex *, you can modify it, add Default file name: DirectoryIndex index.php default.php index.htm index.html default.htm default.html Save File, restart the apache server. Finally, in the end of the file, the following two rows of Scriptalias / PHP / "C: / PHP /" Action Application / X-httpd-php "/ php/php.exe" to this Apache's PHP environment has been fully established. <3> Test: Use Notepad to create a new file, write down the following line, save it to the c: / program files / apache group / apache2 / htdocs directory, this directory is your site with the directory, named phpinfo.php. Then enter http://localhost/phpinfo.php in the browser to see the information about PHP.

PHPINFO.PHP code is as follows: <4> Install mysql 1. Install by default in c: / mysqlcopy the folowing files to the apache modules directory: php / php4ts.dllphp / sapi / php4apache2.dllphp / dlls / iconv.dllIf any of these files are missing in the modules directory, Apache will fail to start.Be sure the extension can find the following files: php_mysql.dll iconv.dlllibmySQL.dllIf any of them can not be found, Apache will start but will issue a warning like this:. "Unknown (): Unable to load dynamic library 'c / php / extensions / php_mysql.dll" - The specified module could not be found "php_mysql.dll should be in the extensions directory .iconv.dll should be in the Apache modules directory.libmySQL.dll must be either in the Apache root directory or the Windows system directory. I prefer the former because it's cleaner, as other applications do not necessarily use this MySQL library version. Note 3: Be Sure to Use the libmysql.dll file bundled with php. In My Case, Trying to use the libmysql.dll from the mysql 4.1 alpha package res ulted in this error message: "Unknown (): Unable to load dynamic library 'c: /php/extensions/php_mysql.dll" -. The specified procedure could not be found "Start Apache and everything should be fine.2 run C. : /mysql/bin/winmysqladmin.exe Sets User and Password3. Run mysql, test Mysql> show databases; --------- | Databases | ---------- - | MySQL | | TEST | ----------- If there is a picture above, indicate that mysql has been installed successfully; 2. Change the managers password of the MySQL system (new password, change Communication you want to set) Mysql> Update user set password = password ('new password') where user = 'root'; 3. Edit the startup file php.ini in PHP5, connect mysql and php5.mySql.default_port = mysql.default_host = mysql.default_user =

MySQL.DEFAULT_PASSWORD = Change to: mysql.default_port = 3306 Description is the default port of MySQL is generally 3306 mysql.default_host = localhost description is mysql's default host name mysql.default_user = jinchao description is Mysql default Username (root is the highest-level user) mysql.default_password = 666666 Setting the administrator's password modification After the Apache is restarted, view the PHPINFO page. <5> Install phpMyadmin modification C: / program files / apache group / apache2 / htdocs / phpMyadmin /config.inc.php Findings for this paragraph: $ I = 0; // The $ cfg ['Servers'] Array Starts with $ cfg ['Servers'] [1]. Do Not Use $ CFG ['Servers'] [0] .// You can disable a server config entry by setting host to ''. Continue to find after this section: Find $ CFG ['Servers'] [$ I] ['Auth_Type'] = 'cookie'; Change "CONFIG" to "Cookie" or "HTTP" to find $ cfg ['servers'] [$ I] ['Host'] = 'localhost'; see the corresponding modification to find $ cfg ['Servers'] [$ I] ['user'] = 'root'; see the corresponding modification to find $ cfg ['servers'] [$ I] ['Password'] = ''; seeing $ cfg ['Servers') ] [$ I] ['Port'] = '3306'; the appropriate modification is modified in the browser input http://127.0.0.1, at this time, the phpmyadmin login screen should be entered, requiring username and password, enter root, The password is modified just now. The integration of Apache 2.047 and PHP5.0.0B1 and MySQL-4.5.0.0B1 and MySQL-4.5.3-RC1 under this Windows XP platform have been completed. Thanks for support for Flyfox.