{"id":2430,"date":"2019-09-16T13:35:54","date_gmt":"2019-09-16T05:35:54","guid":{"rendered":"https:\/\/www.baishitou.cn\/?p=2430"},"modified":"2020-03-13T14:02:08","modified_gmt":"2020-03-13T06:02:08","slug":"windows10%e6%9c%ac%e5%9c%b0%e6%90%ad%e5%bb%baiisphpmysqlphpmyadmin%e8%bf%90%e8%a1%8c%e7%8e%af%e5%a2%83%e5%9b%be%e6%96%87%e6%95%99%e7%a8%8b%ef%bc%88%e4%b9%9f%e5%8f%af%e7%94%a8%e4%ba%8e%e6%9c%8d","status":"publish","type":"post","link":"https:\/\/www.baishitou.cn\/2430.html","title":{"rendered":"Windows10\u672c\u5730\u642d\u5efaIIS+PHP+MYSQL+phpMyAdmin\u8fd0\u884c\u73af\u5883\u56fe\u6587\u6559\u7a0b\uff08\u4e5f\u53ef\u7528\u4e8e\u670d\u52a1\u5668\uff09"},"content":{"rendered":"
\u9700\u8981\u63d0\u524d\u4e0b\u8f7d\u7684\u5de5\u5177\u8f6f\u4ef6<\/p>\n
1\u3001php5.45\uff0cwindows\u5e94\u8be5\u4f7f\u7528PHP\u7684\u975e\u7ebf\u7a0b\u5b89\u5168\uff08NTS\uff09\u7248\u672c\u3002\u6211\u7ecf\u5e38\u7528\u7ec7\u68a6\u7a0b\u5e8f\u505a\u7ad9\uff0c\u6240\u4ee5\u9009\u62e9php-5.4.45-nts-Win32-VC9-x86.zip\uff0c\u4e0b\u8f7d\u5730\u5740:<\/p>\n
https:\/\/windows.php.net\/downloads\/releases\/archives\/php-5.4.45-nts-Win32-VC9-x86.zip<\/code><\/pre>\n2\u3001MYSQL\u6570\u636e\u5e93\uff0c\u6211\u8fd9\u91cc\u9009\u62e9\u4e86mysql-5.5.62-winx64\u3002\u4e0b\u8f7d\u5730\u5740<\/p>\n
https:\/\/dev.mysql.com\/get\/Downloads\/MySQL-5.5\/mysql-5.5.62-winx64.msi<\/code><\/pre>\n3\u3001phpMyAdmin\u6570\u636e\u5e93\u7ba1\u7406\u8f6f\u4ef6\u00a0 \u4e0b\u8f7d\u5730\u5740\uff1a<\/p>\n
https:\/\/files.phpmyadmin.net\/phpMyAdmin\/4.4.12\/phpMyAdmin-4.4.12-all-languages.7z<\/code><\/pre>\n\u7b2c\u4e00\u6b65 \u5b89\u88c5IIS<\/h2>\n
\u9996\u5148\uff0c\u53f3\u952e\u5355\u51fb\u53f3\u4e0b\u89d2\u7684WINDOWS\u5fbd\u6807\uff0c\u70b9\u51fb\u8bbe\u7f6e-\u5e94\u7528\u7a0b\u5e8f-\u7a0b\u5e8f\u548c\u529f\u80fd\uff08\u6216\u8005\u662f\u76f4\u63a5\u641c\u7d22\u63a7\u5236\u9762\u677f\u70b9\u51fb\u7a0b\u5e8f\u548c\u529f\u80fd\uff09<\/p>\n
<\/p>\n
<\/a>
<\/a><\/p>\n\u70b9\u51fb\uff1a\u542f\u7528\u6216\u8005\u5173\u95edWINDOWS\u529f\u80fd<\/p>\n
<\/a><\/p>\n\u9009\u4e2dinternet information services\uff0c\u70b9\u5f00\u4e07\u7ef4\u7f51\u670d\u52a1-\u5e94\u7528\u7a0b\u5e8f\u5f00\u53d1\u529f\u80fd\uff0c\u9009\u4e2dCGI\uff0c\u7136\u540e\u786e\u5b9a\u4fdd\u5b58\u3002<\/p>\n
<\/a><\/p>\n\u7136\u540e\u5728\u7ba1\u7406\u5de5\u5177\u91cc\u9762\u5c31\u53ef\u4ee5\u770b\u5230IIS\u7ba1\u7406\u5668\u4e86\u3002\u628a\u8fd9\u4e2a\u7ba1\u7406\u5668\u53d1\u9001\u5feb\u6377\u5f0f\u5230\u56fe\u7247\u3002\u65b9\u4fbf\u540e\u9762\u64cd\u4f5c\u3002<\/p>\n
<\/a><\/p>\n\u6253\u5f00\u684c\u9762\u4e0a\u7684IIS\u7ba1\u7406\u5668\uff0c\u70b9\u5f00\u7f51\u7ad9\uff0c\u91cc\u9762\u6709\u4e00\u4e2a\u9ed8\u8ba4\u7ad9\u70b9\uff0c\u6d4f\u89c8<\/p>\n
<\/a><\/p>\n\u5982\u679c \u51fa\u73b0\u8fd9\u4e2a\u753b\u9762\uff0c\u5c31\u8bf4\u660e\u6211\u4eec\u7684IIS\u5df2\u7ecf\u5b89\u88c5\u597d\u4e86\u3002<\/p>\n
<\/a><\/p>\n\u7b2c\u4e8c\u6b65\uff0c\u4fee\u6539PHP\u914d\u7f6e\u6587\u4ef6<\/h2>\n
\u5728D\u76d8\u6839\u76ee\u5f55\u65b0\u5efa\u4e00\u4e2a\u540d\u4e3aphp\u7684\u6587\u4ef6\u5939\uff0c\u8fd9\u4e2a\u6587\u4ef6\u5939\u7528\u6765\u5b58\u653ePHP\u914d\u7f6e\u6587\u4ef6\u3001\u6570\u636e\u5e93\u6587\u4ef6\u3002\u7136\u540e\u5728\u8fd9\u4e2a\u6587\u4ef6\u5939\u518d\u65b0\u5efa\u4e00\u4e2a\u540d\u4e3aphp\u7684\u6587\u4ef6\u5939\uff0c\u628a\u6211\u4eec\u521a\u624d\u4e0b\u8f7d\u7684PHP\u6587\u4ef6\u89e3\u538b\u5230\u8fd9\u4e2a\u6587\u4ef6\u5939\u91cc\u9762\u3002\u628aphp\u6587\u4ef6\u91cc\u9762\u7684php.ini-development\u590d\u5236\u4e00\u4efd\uff0c\u7136\u540e\u628a\u540d\u79f0\u4fee\u6539\u4e3aphp.ini\uff0c\u5982\u4e0b\u56fe\uff1a<\/p>\n
<\/a><\/p>\n\u7528\u8bb0\u4e8b\u672c\u6253\u5f00\u8fd9\u4e2aphp.ini,\u641c\u7d22extension_dir\uff0c\u5927\u7ea6\u5728721\u884c<\/p>\n
<\/a><\/p>\n\u628aextension_dir\u524d\u9762\u5206\u53f7\u53bb\u6389\uff1b\u628a\u540e\u9762\u7684ext\u4fee\u6539\u4e3a\uff1aD:\\php\\php\\ext \uff0c\u4fee\u6539\u540e\u5982\u4e0b\u3002<\/p>\n
<\/a><\/p>\n\u641c\u7d22date.timezone\uff0c\u5927\u7ea6\u5728909\u884c\uff0c\u628a\u5b83\u524d\u9762\u7684\u5206\u53f7\u53bb\u6389\uff0c\u628adate.timezone =\u4fee\u6539\u4e3a\uff1adate.timezone = Asia\/Shanghai<\/p>\n
<\/a><\/p>\n\u7ee7\u7eed\u641c\u7d22extension=php_ \u628a\u4e0b\u5217\u51e0\u4e2a\u6269\u5c55\u524d\u9762\u7684\u5206\u53f7\u53bb\u6389\uff0c\u4e0b\u9762\u51e0\u4e2a\u662f\u5fc5\u987b\u8981\u6253\u5f00\u7684\u3002\u5982\u679c\u4f60\u8fd0\u884c\u7a0b\u5e8f\u63d0\u793a\u7f3a\u5c11\u54ea\u4e2a\u6269\u5c55\uff0c\u76f4\u63a5\u4fee\u6539PHP.INI\u6587\u4ef6\u5c31\u884c\u4e86\u3002<\/p>\n
extension=php_curl.dll\r\nextension=php_gd2.dll\r\nextension=php_mysql.dll\r\nextension=php_mbstring.dll\r\nextension=php_mysqli.dll\r\nextension=php_pdo_mysql.dll<\/code><\/pre>\n
<\/a><\/p>\n\u4fdd\u5b58\u3002\u6253\u5f00IIS\u7ba1\u7406\u5668\uff0c\u70b9\u51fb\u53f3\u8fb9\u7684\u5904\u7406\u7a0b\u5e8f\u6620\u5c04\u3002<\/p>\n
<\/a><\/p>\n\u6dfb\u52a0\u6a21\u5757\u6620\u5c04<\/p>\n
<\/a><\/p>\n\u586b\u5199\u5982\u4e0b\u56fe\u6240\u793a\uff1a\u6a21\u5757\u9009\u62e9FastCgiModule<\/p>\n
<\/a><\/p>\n\u6ce8\u610f\uff0c\u5f53\u4f60\u9009\u62e9\u53ef\u6267\u884c\u6587\u4ef6\u65f6\uff0c\u770b\u5230\u7684\u90fd\u662f.dll\u6587\u4ef6<\/p>\n
<\/a><\/p>\n\u4f60\u8981\u5148\u9009\u62e9*.exe\uff08\u5982\u4e0b\u56fe\uff09\uff0c\u7136\u540e\u624d\u4f1a\u770b\u5230\u8fd9\u4e2aphp-cgi.exe<\/p>\n
<\/a><\/p>\n <\/p>\n
<\/a><\/p>\n\u6dfb\u52a0php\u9ed8\u8ba4\u6587\u6863<\/p>\n
<\/a><\/p>\n <\/p>\n
<\/a><\/p>\n <\/p>\n
\u628a\u9ed8\u8ba4\u7ad9\u70b9\u6682\u505c\uff0c\u6216\u8005\u5220\u9664\u4e5f\u884c\u3002<\/p>\n
<\/p>\n
<\/a><\/p>\n\u7136\u540e\uff0c\u6211\u4eec\u6765\u770b\u770bPHP\u6709\u6ca1\u6709\u914d\u7f6e\u6210\u529f\u3002\u5728D\u76d8\u6839\u76ee\u5f55\u4e0b\u65b0\u5efa\u4e00\u540d\u4e3aweb\u6587\u4ef6\u5939\uff0c\u7528\u6765\u5b58\u653e\u7f51\u7ad9\uff0c\u5982\u679c\u4f60\u6709\u591a\u4e2a\u7f51\u7ad9\u9700\u8981\u8c03\u8bd5\uff0c\u90a3\u5c31\u5728\u8fd9\u4e2aweb\u6587\u4ef6\u5939\u91cc\u9762\u518d\u5efa\u4e00\u4e2a\uff0c\u8fd9\u91cc\u6211\u5728WEB\u6587\u4ef6\u5939\u91cc\u65b0\u5efa\u4e00\u4e2atest\u7684\u6587\u4ef6\u5939\uff0c\u5728\u8fd9\u4e2a\u6587\u4ef6\u5939\u91cc\u65b0\u5efa\u4e00\u4e2aphp\u6587\u4ef6\uff0c\u540d\u79f0\u968f\u610f\uff0c\u6211\u8fd9\u91cc\u6587\u4ef6\u540d\u4e3aindex.php,\u5185\u5bb9\u4e3a<\/p>\n
<?php\r\nphpinfo();\r\n?><\/code><\/pre>\n
<\/a><\/p>\n <\/p>\n
\u6211\u4eec\u6765\u65b0\u5efa\u4e00\u4e2a\u7f51\u7ad9\u3002\u628a\u7269\u7406\u8def\u5f84\u6307\u5411\u6211\u4eec\u4e0a\u4e00\u6b65\u65b0\u5efatest\u7f51\u7ad9\u76ee\u5f55\u3002\u6ce8\u610f\u7aef\u53e3\u3002\u5982\u679c\u4f60\u5c31\u4e00\u4e2a\u7ad9\uff0c\u90a3\u5c31\u7528\u9ed8\u8ba4\u768480\u7aef\u53e3\u5c31\u884c\u4e86\u3002\u5982\u679c\u4f60\u6709\u9700\u8981\u65b0\u5efa\u591a\u4e2a\u7ad9\uff0c\u90a3\u5c31\u5f97\u4fee\u6539\u7aef\u53e3\u3002\u6211\u8fd9\u91cc\u75288001\uff0c\u5982\u679c\u518d\u5efa\u7b2c\u4e8c\u4e2a\u7ad9\u7684\u8bdd\uff0c\u90a3\u5c31\u662f8002\u30018003\uff0c\u4ee5\u6b64\u7c7b\u63a8\u3002\u53ef\u5efa\u591a\u4e2a\u7ad9\u3002\u70b9\u51fb\u786e\u5b9a\u3002\u5982\u679c\u4f60\u642d\u5efa\u7684\u73af\u5883\u5e94\u7528\u4e8e\u670d\u52a1\u5668\u4e0a\u9762\uff0cIP\u5730\u5740\u5904\u5e94\u586b\u5199\u4f60\u7684\u670d\u52a1\u5668IP\uff0c\u7aef\u53e3\u5904\u9ed8\u8ba480\uff0c\u4e3b\u673a\u540d\u5904\u586b\u5199\u4f60\u7684\u57df\u540d\u3002<\/p>\n
<\/a><\/p>\n\u4e0b\u9762\u6fc0\u52a8\u4eba\u5fc3\u7684\u65f6\u523b\u5c31\u8981\u5230\u4e86\uff0c\u5728\u65b0\u5efa\u7684\u7ad9\u70b9\u5355\u51fb\u53f3\u952e\uff0c\u7ba1\u7406\u7f51\u7ad9-\u6d4f\u89c8<\/p>\n
<\/a><\/p>\n\u51fa\u73b0\u8fd9\u4e2a\u753b\u9762\uff0c\u8bf4\u660e\u6211\u4eec\u7684PHP\u8fd0\u884c\u73af\u5883\u914d\u7f6e\u6210\u529f\u3002<\/p>\n
<\/a><\/p>\n\u4e0a\u9762\u6b65\u9aa4\u4e2d\uff0c\u5728\u6dfb\u52a0\u5904\u7406\u7a0b\u5e8f\u6620\u5c04\u6a21\u5757\u53ca\u9ed8\u8ba4\u9996\u9875\u6587\u4ef6\u6863\u8fd9\u4e24\u4e2a\u73af\u8282\u6211\u8fd9\u8fb9\u662f\u5168\u7ad9\u6dfb\u52a0\u7684\uff0c\u5c31\u662f\u8bf4\uff0c\u6dfb\u52a0\u540e\uff0c\u540e\u9762\u7684\u65b0\u5efa\u7684\u7ad9\u70b9\u90fd\u7528\u8fd9\u4e2a\u914d\u7f6e\uff0c\u4f60\u4e5f\u53ef\u4ee5\u4e0d\u7528\u6dfb\u52a0\u5168\u7ad9\uff0c\u65b0\u5efa\u4e00\u4e2a\u7ad9\u70b9\u5c31\u6dfb\u52a0\u4e00\u4e2a\u3002<\/p>\n
\u7b2c\u4e09\u6b65 \u5b89\u88c5\u6570\u636e\u5e93\u8f6f\u4ef6<\/h2>\n
\u76f4\u63a5\u53cc\u51fb\u5b89\u88c5\uff0c\u5230\u8fd9\u4e00\u6b65\u540e\uff0c\u9009\u7b2c\u4e8c\u9879,<\/p>\n
<\/a><\/p>\n\u628amysql server\u9ed8\u8ba4\u5b89\u88c5\u5728C\u76d8\u7684\u8def\u5f84\u4fee\u6539\u4e3aD:\\PHP\\<\/p>\n
<\/a><\/p>\n\u4fee\u6539\u540e\u5982\u4e0b\u56fe<\/p>\n
<\/a><\/p>\n\u70b9\u51fbserver data files\uff0c\u628a\u6570\u636e\u5e93\u8def\u5f84\u4e5f\u4fee\u6539\u4e3aD\u76d8PHP\u6587\u4ef6\u5939\u91cc\u9762\u3002\u5982\u4e0b\u56fe<\/p>\n
<\/a><\/p>\n
<\/a><\/p>\n\u7f16\u7801\u9009\u62e9UTF8<\/p>\n
<\/a><\/p>\n <\/p>\n
<\/a><\/p>\n\u8f93\u5165\u6570\u636e\u5e93\u5bc6\u7801\u3002<\/p>\n
<\/a><\/p>\n\u5b89\u88c5\u7ed3\u675f<\/p>\n
<\/a><\/p>\n\u73b0\u5728\u6211\u4eec\u6d4b\u8bd5\u4e00\u4e0b\u770b\u770b\u6210\u529f\u4e0d\u3002\u70b9\u51fb\u5f00\u59cb\uff0c\u6253\u5f00MySQL 5.5 Command Line Client<\/p>\n
<\/a><\/p>\n\u8f93\u5165\u6570\u636e\u5e93\u5bc6\u7801\uff1a\u51fa\u73b0\u8fd9\u4e2a\u753b\u9762\uff0c\u5c31\u8bf4\u660e\u5b89\u88c5\u6210\u529f\u4e86\u3002<\/p>\n
<\/a><\/p>\n\u7b2c\u56db\u6b65\u3002\u5b89\u88c5\u6570\u636e\u5e93\u7ba1\u7406\u5de5\u5177phpmyadmin<\/h2>\n
\u628a\u4e0a\u9762\u4e0b\u8f7d\u7684phpmyadmin\u89e3\u538b\u5230D\u76d8PHP\u6587\u4ef6\u5939\u91cc\u9762<\/p>\n
<\/a><\/p>\n\u6253\u5f00IIS\u7ba1\u7406\u5de5\u5177\uff0c\u65b0\u5efaphpmyadmin\u7ba1\u7406\u7f51\u7ad9<\/p>\n
<\/a><\/p>\n\u8bbf\u95ee\u8fd9\u4e2a\u7ba1\u7406\uff0c\u8f93\u5165\u7528\u6237\u540d\u548c\u5bc6\u7801\uff0c<\/p>\n