WinXP + Apache +PHP5 + MySQL + phpMyAdmin°²×°È«¹¦ÂÔ - 代码块 - 哈喽比特

5年以前 | 阅读数：742 次 | 编程语言：PHP

I finally got this to work, so I will post my findings here.

//PHP 5 : Windows build needs a MySQL DLL
//PHP 5.0 doesn't come with mysql support... You have to get the librariesyourself...
//I think u can get them from mysql.com

// PHP 5 Beta 2
//The file php_mysql.dll comes with these snapshots, as well as a new version of libmySQL.dll,
//so I suggest a full upgrade to Beta 2 instead of just extracting php_mysql.dll for use with Beta 1.

--------------------------------------------------------
µ½ www.jetdown.com ÏÂÔØÏÂÃaeÈýÖÖÈi¼þ,×oºÃ°²×°×¼±¸

apache_2.0.47-win32-x86-no_ssl.msi
mysql-4.0.14-win.zip
phpMyAdmin-2.5.3-rc1-php.zip
----------------------------------------------------------------------------------------------
PHP 5 Beta 2 http://snaps.php.net/win32/php5-win32-latest.zip size£º5.87 MB (6,162,835 bytes)
----------------------------------------------------------------------------------------------

<1>°²×°ÅaÖÃPHP ¡¡¡¡1.½aÑ¹ËoPHPÑ¹Ëo°uµ½C:\php\

2.¸´ÖÆC:\php\Ä¿Â¼ÏÂµÄphp4ts.dll¼°C:\php\dllsÄ¿Â¼ÏÂµÄËuÓÐÎÄ¼þµ½windows°²×°Ä¿Â¼µÄÏµÍ³ÎÄ¼þ¼ÐÀi
(win9x/meÊÇsystemÄ¿Â¼£¬winNT,2k/winXP,2003ÊÇsystem32Ä¿Â¼)

¸´ÖÆC:\php\php.ini-distµ½windows°²×°Ä¿Â¼ÏÂ£¨Èç£ºc:\windows£(C)£¬²¢½«Æa¸ÄÃuÎªphp.ini¡£ÓÃ¼ÇÊÂ±¾´o¿ª£¬ÐÞ¸ÄÒ»ÏÂÐÅÏ¢£º
¡¡¡¡ËÑË÷extension_dir = ./ ÕaÐÐ£¬²¢½«ÆaÂ*¾¶Ö¸µ½ÄaµÄPHPÄ¿Â¼ÏÂµÄextensionsÄ¿Â¼£¬±ÈÈç£º
¡¡¡¡extension_dir = C:\php\extensions

¡¡¡¡ÈçÈoÏeÖ§³Ö¸u¶aÄ£¿e£¬£¬ËÑË÷£º
;Windows Extensions
;Note that MySQL and ODBC support is now built in, so no dll is needed for it.

ÏÂÃae¶¼ÓÃ*ÖºÅÔÚÇ°Ãae×¢ÊÍµoÁËÖ§³ÖµÄÀ(C)Õ¹Ä£¿e£¬Èç¹uÄaÏePHPÖ§³ÖÄ³¸oÄ£¿e£¬Çe½«Ç°ÃaeµÄ¡°;¡±È¥µo¼´¿É
ÐÞ¸ÄÍe³Éºo,±£´aephp.ini£¬µ½´ËÍe³ÉPHPµÄ°²×°ºÍÅaÖÃ¡£
ÎÒÃÇÔÚÏÂÃae¼ÓÈeÒ»ÐÐ
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 Apache root, as lars mentioned. It works fine for me in the Windows dir.

<2>°²×°Apach2 1.±¸*Ý¡¡C:\Program Files\Apache Group\Apache2\conf\httpd.conf ÎÄ¼þ¡£ 2.ÓÃ¼ÇÊÂ±¾´o¿ªC:\Program Files\Apache Group\Apache2\conf\httpd.conf ÕÒµ½£º #NameVirtualHost * ÐÞ¸ÄÎª£º NameVirtualHost 127.0.0.1¡¡//»olocalhost ÕÒµ½£º ÐÞ¸ÄÏÂÃae¼¸ÐÐ£º ServerAdmin (Äa¸Õ²Å°²×°Ê±ºoÊaÈeµÄ¹ÜÀiÔ±ÐÅÏa) DocumentRoot C:\Program Files\Apache Group\Apache2\htdocs ServerName Apache2 ErrorLog C:\Program Files\Apache Group\Apache2\logs\error_log CustomLog C:\Program Files\Apache Group\Apache2\logs\access_log common ÕÒµ½£º AddType application/x-tar .tgz ÔÚÏÂÃaeÌi¼ÓÒÔÏÂÁ½ÐÐ£º AddType application/x-httpd-php .php AddType image/x-icon .ico ÕÒµ½£º #LoadModule ssl_module modules/mod_ssl.so ÔÚÏÂÃaeÌi¼ÓÒ»ÐÐ£º LoadModule php5_module C:\php\sapi\php4apache2.dll //ÕaÀiphp5_moduleÊÇ¹Ø¼u£¬Èç¹uphp4_module apache¾ÍÎÞ*¨Æo¶¯ÁË Ôo¼ÓÄ¬ÈÏÎÄ¼þ£º ÕÒµ½DirectoryIndex * ÕaÐÐ£¬¿ÉÒÔÕaÑuÐÞ¸Ä£¬Ìi¼ÓÄ¬ÈÏµÄÎÄ¼þÃu£º DirectoryIndex index.php default.php index.htm index.html default.htm default.html ±£´aeÎÄ¼þ£¬ÖØÆðapache*þÎñÆ÷¡£

×iºo£¬ÔÚ¸ÃÎÄ¼þÄ(C)Î²¼ÓÉÏÏÂÃaeÁ½ÐÐ
ScriptAlias /php/ "c:/php/"
Action application/x-httpd-php "/php/php.exe¡°

µ½´ËApacheµÄPHP»*¾³ÒÑ¾ÍeÈ«½¨Á¢ÁË¡£

<3>²aÊÔ£º ¡¡¡¡ÓÃ¼ÇÊÂ±¾ÐÂ½¨¸oÎÄ¼þ£¬Ð´ÏÂÏÂÃae¼¸ÐÐ£¬±£´aeµ½C:\Program Files\Apache Group\Apache2\htdocsÄ¿Â¼ÏÂ£¬Õa¸oÄ¿Â¼¾ÍÊÇÄaµÄÕ¾µa¸uÄ¿Â¼£¬ÃuÃuÎªphpinfo.php.È»ºoÔÚa¯ÀÀÆ÷ÖÐÊaÈehttp://localhost/phpinfo.php ¾Í¿ÉÒÔ¿´µ½Ïe¾¡µÄ¹ØÓÚPHPµÄÐÅÏ¢ÁË¡£

phpinfo.php´uÂeÈçÏÂ£º
<?php

phpinfo();

<4>°²×°mysql

1.°´Ä¬ÈÏ°²×°ÔÚC:\mysql

Copy the following files to the Apache modules directory:

php\php4ts.dll
php\sapi\php4apache2.dll
php\dlls\iconv.dll

If 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.dll
libmySQL.dll

If any of them can't 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 don't 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 resulted 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.ÔËÐÐC:\mysql\bin\winmysqladmin.exe Ée¶¨user ºÍpassword
3.ÔËÐÐmysql,²aÊÔÒ»ÏÂ
mysql> show databases;

+-----------+
| Databases |
+-----------+
| mysql |
| test |
+-----------+

Èç¹u³oÏÖÒÔÉÏ»Ãae£¬±iÃ÷mysqlÒÑ¾°²×°³É¹¦£»

2.¸u¸ÄMySQLÏµ½yÖ®¹ÜÀiÕßÃÜ´a(ÐÂÃÜ´aµÄµØ*½£¬"Q³ÉÄuÒªÔO¶¨µÄÃÜ´a)
mysql> UPDATE user SET password=password('ÐÂÃÜ´a') where user='root';

3.±a¼php5ÖÐµÄÆo¶¯ÎÄ¼þphp.ini,½«mysqlºÍphp5Á¬½ÓÆðÀ´.
mysql.default_port=
mysql.default_host=
mysql.default_user=
mysql.default_password=
¸ÄÎª£º
mysql.default_port=3306 ËµÃ÷µÄÊÇmysqlµÄÈ±Ê¡¶Ë¿ÚÒ»°aÎª3306
mysql.default_host=localhost ËµÃ÷µÄÊÇmysqlµÄÈ±Ê¡Ö÷»uÃu³Æ
mysql.default_user=jinchao ËµÃ÷µÄÊÇmysqlµÄÈ±Ê¡µÄÓÃ»§Ãu(rootÊÇ×i¸ß¼¶ÓÃ»§)
mysql.default_password=666666 ÉeÖÃ¹ÜÀiÔ±µÄ¿ÚÁi

ÐÞ¸ÄÍeºo½«apacheÖØÆo,²e¿´phpinfoÒ³Ãae.

<5>°²×°phpmyadmin

ÐÞ¸Ä C:\Program Files\Apache Group\Apache2\htdocs\phpMyAdmin\config.inc.php
²eÕÒÒÔÏÂÕaÃ´Ò»¶Î£º
$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 ''.
ÔÚÕa¶ÎÖ®ºoÔÙ¼ÌÐø²eÕÒ£º

ÕÒµ½ $cfg['Servers'][$i]['auth_type'] = 'cookie'; Œ¢ ¡º config ¡»¸Äže ¡º cookie ¡»»o ¡º http ¡»
ÕÒµ½$cfg['Servers'][$i]['host'] = 'localhost'; ÊÓÇe¿o×oÏaÓ¦ÐÞ¸Ä
ÕÒµ½$cfg['Servers'][$i]['user'] = 'root'; ÊÓÇe¿o×oÏaÓ¦ÐÞ¸Ä
ÕÒµ½$cfg['Servers'][$i]['password'] = ''; ÊÓÇe¿o×oÏaÓ¦ÐÞ¸Ä
ÕÒµ½$cfg['Servers'][$i]['port'] = '3306'; ÊÓÇe¿o×oÏaÓ¦ÐÞ¸Ä