IIS6+PHP5+MySQL5+Zend Optimizer+phpMyAdmin installation and configuration graphic tutorial 2009

For everyone to reprint and read offline, the HTML source code, UBB source code, PDF version, and Flash version of this tutorial are available for download.
Download address: http://code.google.com/p/wpmi/downloads/list

Operating system: Windows.Server.2003. R2, Enterprise.Edition, SP2, x86, CHS, VOL, MSDN
The server environment for configuring PHP this time: Windows2003+ IIS6+PHP5+MySQL3+Zend+phpMyAdmin
The entire configuration process needs to use owned management Log in to Windows with a system account with administrator privileges
The screenshots shown during the entire configuration process may vary depending on the system used and the window interface, but the corresponding tab columns are the same. You only need to find the mentioned Just click the corresponding tab.

1. Download related software

Software that needs to be prepared before installation (because the server operating system I use here is the x86 version, so the following programs are all for Windows The version used in x86 environment ) without special instructions is the latest version of as of January 16, 2009 :

1. PHP recommends the ZIP compressed version of PHP 5.2.8
PHP 5.2.8 zip package [10,115Kb] - 08 December 2008
MD5: 71511834881753ea0906f2bca91632b9
Official download page: http:/ /www.php.net/downloads.php
http://cn2.php.net/get/php-5.2.8-Win32.zip/from/a/mirror
Direct download address: http://cn2.php.net/distributions/php-5.2.8-Win32.zip
2. MySQL recommends the Windows ZIP of MySQL 5.0.67 /Setup.EXE (x86) version
MD5: ed76e5ad8b251ca643766c70926854d7
Official download page: http://dev.mysql.com/downloads/mysql/5.0.html#win32
http://dev.mysql.com/get/Downloads/MySQL-5.0/mysql-5.0.67-win32.zip/from/pick
Direct download address: http ://mysql.cs.pu.edu.tw/Downloads/MySQL-5.0/mysql-5.0.67-win32.zip
3. Zend Optimizer recommends the latest version. The latest version now is Zend Optimizer v3.3
(Although the download is free, you must register as a user before you can download it. For everyone’s convenience, I will disclose my registered username: ideacmblog Password: ideacm.com.cn, It is convenient for everyone to use. I hope you will not change the password or use it in other illegal ways when using this account)
MD5: f1766065288d509d5286c4c3c7239412
Official download page: http://www.zend.com/en /products/guard/downloads
Direct download address: http://downloads.zend.com/optimizer/3.3.3/ZendOptimizer-3.3.3-Windows-i386.exe
4. The latest version of phpMyAdmin is not recommended here. We recommend the phpMyAdmin-2.11.9.4-all-languages.zip version of phpMyAdmin 2.11.9.4
MD5: 84a4399fdac85f4fbeb0ff68a5a89edd
Official download page: http://www.phpmyadmin.net/home_page/downloads.php
Direct download address: http://nchc.dl.sourceforge.net/sourceforge/phpmyadmin/phpMyAdmin-2.11 .9.4-all-languages.zip

2. Preparations before installation and configuration

2.1. First use anti-virus on the downloaded files The software performs a virus scan to prevent accidents. 【As shown in Figure 1】

【Figure 1】

2.2. Okay, now start the environment configuration:
Assume that the operating system is installed on the C drive. If your system is not installed on the C drive, please change the drive letter mentioned below accordingly. At the same time, in order to avoid operating the C drive due to various reasons such as reinstalling the system, it is not recommended to install PHP related software in the C drive . Here I install PHP related programs in the D:PHP directory (You can also define this directory yourself. If you want to install it in a different path, please modify the corresponding path mentioned by yourself).

3. Officially start the environment configuration

The first step is to install PHP

3.1.1. Download the Unzip the php-5.2.8-Win32.zip file to the D:PHP directory, and rename the resulting secondary directory php-5.2.8-Win32 For php5; you can also unzip php-5.2.8-Win32.zip in the default location, and then copy the unzipped files and folders to D:PHPphp5[As shown in Figure 2].

[Picture 2]

3.1.2. Replace all in the D:PHPphp5 directory Copy the dll file to C:windowssystem32 (C:winntsystem32 for Windows 2000 system, the same below). If there are already several files with the same name, just overwrite them.【图三、四所示】

【图三】

【图四】

3.1.3、将D:\PHP\php5目录下的php.ini-dist复制一份，更名为php.ini（还是在当前目录中）【图五所示】，再用文本编辑软件打开这个php.ini（建议使用Notepad2、EditPlus、UltraEdit等各种支持语法高亮显示的文本编辑软件）。

【图五】

3.1.4、查找：register_globals = Off （约第419行）
　　　　将Off更改为 On，即得到register_globals = On ；
　　　　注：这个对于PHP的全局变量功能，考虑有很多PHP程序需要全局变量功能所以打开，打开后请注意PHP程序的严谨性，如果不需要全局变量功能，请保持默认Off状态。
　　　　再搜索 extension_dir = "./" （约第491行）
　　　　将其路径知道你的PHP目录下的扩展功能目录中，这里PHP5对应修改为extension_dir = "D:/PHP/php5/ext" 。
　　　　再在D:\PHP下建立文件夹，并命名为tmp
　　　　查找 ;upload_tmp_dir =
　　　　将;upload_tmp_dir =该行的注释符，即前面的分号”;”去掉，使该行在php.ini文档中起作用。
　　　　upload_tmp_dir是用来定义上传文件存放的临时路径，在这里你还可以修改并给其定义一个决定路径，需要注意的是，这里设置的目录必须有读、写权限。
　　　　这里我设置为upload_tmp_dir = D:/PHP/tmp （这里就是我前面建立的文件夹）
3.1.5、搜索 ; Windows Extensions，定位到php.ini文件的约604行，将下面列出的常用扩展前面的分号注释符去掉：

; extension=php_curl.dll
; extension=php_dbase.dll
; extension=php_gd2.dll
; extension=php_ldap.dll
; extension=php_mbstring.dll
; extension=php_exif.dll

　　特别提示：Exif扩展是用来显示图片的exif信息的，因该扩展需要mbstring支持，所以将extension=php_exif.dll这一行移动到extension=php_mbstring.dll一行的下面。

; extension=php_mcrypt.dll
; extension=php_ming.dll
; extension=php_mysql.dll
; extension=php_sockets.dll
;extension=php_xmlrpc.dll
; extension=php_zip.dll

3.1.6、查找：;date.timezone =
　　　　去掉前面的分号注释符，这里将其设置为 date.timezone = PRC

关于时区设定的说明：
从php5.1.0开始，php.ini里加入了date.timezone这个选项，默认情况下是关闭的，也就是显示的时间（无论用什么php命令）都是格林威治标准时间，和我们的时间（北京时间）差了正好8个小时，有以下2种方法可以恢复正常的时间。
1、如果要用5.1以上版本，而且不修改php.ini，则需要在关于时间的初始化的语句的上面加上date_default_timezone_set (XXX)，或者使用date('Y-m-d G:i:T', strtotime('+8HOUR') )来获取日期时间；
2、一劳永逸，仅限能修改php.ini。打开php.ini把date.timezone前面的分号去掉，在=后面加XXX，重启http服务（如apache2或iis等）即可。
关于XXX，大陆内地可用的值是：Asia/Chongqing、Asia/Shanghai、Asia/Urumqi（依次为重庆，上海，乌鲁木齐），港台地区可用：Asia/Macao、Asia/Hong_Kong、Asia/Taipei（依次为澳门，香港，台北），还有新加坡：Asia/Singapore，以上没有北京，不过接着往下看，其他可用的值是：Etc/GMT-8，Singapore ，Hongkong，PRC（中华人民共和国）。

3.1.7、查找：;session.save_path = "/tmp"
　　　　将前面的分号注释符去掉，这里将其设置为session.save_path = "D:/PHP/tmp" （这里就是我前面建立的文件夹）

3.1.8、如果你有遇到无法上传较大文件或者运行某些程序经常超时，那么可以修改以下内容来调整相关限额：
　　　　在大约第255行，
　　　　max_execution_time = 30 ; 这个是每个脚本运行的最长时间，根据你的需求更改数值，单位秒
　　　　max_input_time = 60 ; 这是每个脚本可以消耗的时间，根据你的需求更改数值，单位也是秒

　　　　大约第258行，
　　　　memory_limit = 128M ; 这个是脚本运行最大消耗的内存，根据你的需求更改数值。

　　　　大约第552行，
　　　　upload_max_filesize = 2M
　　　　上载文件的最大许可大小，根据你的需求更改数值，M是单位：兆。
3.1.9、 php.ini文件中基本就是作如上修改，其他的你可以根据自己的具体需求修改，然后将该文件保存，再复制一份到C:\Windows下面。

第二步、安装IIS

3.2.1、打开“添加或删除程序”面板【图六所示】

以下两种方法均可打开“添加或删除程序”面板：
1、点击“开始”-“控制面板”-“添加/删除程序”；
2、直接在“开始”-“运行”中输入：Appwiz.cpl （回车确定）

[Picture 6]

3.2.2, Click "Add/Remove Windows Components (A " "Windows Component Wizard"[shown in Figure 8]

[Picture 8]

3.2.4. Drag Scroll the right scroll bar in the panel until you see "
Application Server", click to select the checkbox in front of it, then click "Details
", and then click "

ASP.NET
", and then click on "Internet Information Services (IIS)" (the checkbox here is currently selected, and here is the text Click (not the signature checkbox), then click "
Details (D)
" in the opened panel, and drag the right scroll bar down. Then click on "
Web Services" and then click on "Details".
Check "Active Server Pages", "Internet Data Connector", "Included files on the server side"; "World Wide Web Service " is already selected.

3.2.5, then click OK (World Wide Web Service Panel) - OK (Internet Information Services (IIS) Panel) - OK (Application Server Panel) [As shown in Figure 9] - In the next step (Windows Component Wizard Panel), the required file dialog box will pop up during the configuration process [shown in Figure 10] . At this time, insert the installation CD of this system into the CD-ROM drive, click Browse, and select the CD-ROM drive letter , enter the i386 folder, the required files will be automatically displayed, directly click "Open " [shown in Figure 11] , and then click " Confirm”[As shown in Figures 12 and 13], at this time, a dialog box of “Required files” will pop up again, still follow the previous one Steps, click "Browse", then locate the i386 folder, the required files will be automatically displayed, directly click "Open" - "Confirm ”, and then wait until the “Windows Component Wizard” completes the interface[shown in Figure 14], click “Complete”, and “Windows Please wait a moment to install the program..." dialog box, wait for it to close automatically, then close the "Add or Remove Programs" panel, go to Start-Control Panel-Management ToolsYou can see "Internet Information Services (IIS) Manager" in the menu. At this time, IIS has been installed[As shown in Figure 15 】.

[Picture 9]

[Picture 10]

[Picture 11]

[Picture 12]

[Picture 13]

[Picture 14]

[Picture 15]

The third step is to configure IIS to support PHP

3.3.1. Open the browser and enter: http://localhost for normal access , see a page with text similar to "Under Construction" [shown in Figure 16] .

[Figure 16]

3.3.2. PHP supports CGI and ISAPI installation modes. CGI consumes more resources and is easy to cause There is no response after timeout, but it is actually relatively safe; ISAPI has strong load capacity and saves resources, but the security is slightly worse than CGI mode. ISAPI mode is recommended here. So here we only introduce the ISAPI mode configuration method.

3.3.3. Open "Internet Information Services (IIS) Manager " (in Start-Run Enter: inetmgr, Enter to confirm; or click the icon in the management tool as mentioned above)
Click "(Computer Name)(local computer)” in front of “+” to expand the tree directory.【图十七所示】

【图十七】

3.3.4、在“网站”上点击鼠标右键，查看“属性”，点击“ISAPI筛选器”选项卡，并点击“添加”按钮，在弹出的“添加/编辑筛选器属性”面板中的“筛选器名称”栏目中输入：PHP，再点击“可执行文件”下面的“浏览”按钮，选择php5isapi.dll文件（按照前面的设置这里的路径应该是D:\PHP\php5\php5isapi.dll），点击打开按钮【图十八所示】，使“可执行文件路径”指向到该文件。点击“确定”按钮；然后再点击“主目录”选项卡，找到并点击“配置”按钮，在弹出的“应用程序配置”面板中的“应用程序扩展”选项卡找到并点击“添加”按钮新增一个扩展名映射，再点击“可执行文件”后面的“浏览”按钮，选择php5isapi.dll文件（按照前面的设置这里的路径应该是D:\PHP\php5\php5isapi.dll），在“扩展名”栏目输入：.php，动作限制为：GET,HEAD,POST,TRACE，将“脚本引擎”、“确认文件是否存在”两项勾选中【图十九所示】（如果还想支持诸如.php5、.phtml等扩展名的PHP文件，可重复“添加”步骤，对应扩展名设置为需要的即可），然后点击确定按钮（添加/编辑应用程序扩展名映射面板），点击“选项”，把“启用父路径”勾选中，然后一路点击确定按钮。
这一步操作将使你服务器IIS下的所有站点都支持你所添加的PHP扩展文件，如果你只需要部分站点支持PHP，只需要在你需要支持PHP的Web站点（展开“网站”目录及可见）比如“默认网站”上单击右键选择“属性”，在打开的“默认网站的属性”“主目录”选项卡中做如上的“添加/编辑应用程序扩展名”操作即可，或者将你不需要支持PHP的站点中的.php扩展名映射删除即可。

【图十八】

【图十九】

3.3.5、打开“网站”属性中的“文档”选项卡，把“启用默认内容文档”列表中添加index.php和Default.php项，也可以将其上移到最前面两个，这样，访问站点时就会首先寻找并打开index.php、Default.php文档。【图二十所示】

什么是默认内容文档：
默认内容文档即默认首页，是指在访问一个文件目录的时候自动定位的一个文件。比如您的主机空间内有许多不同名字的文件，但是您希望在输入网址ideacm.com.cn的时候，默认访问其中一个叫做index.htm的文件，那么您就需要将默认首页设置为index.htm，也可以添加很多个默认内容文档，当访问该站点的时候会自动根据默认内容文档的排序来优先使用。

【图二十】

在这里我推荐默认内容文档做如下顺序的设置：
index.htm
Default.html
index.html
Default.html
index.asp
Default.asp
index.aspx
Default.aspx
index.php
Default.php

3.3.6、设置好默认内容文档后，点击应用按钮，会弹出一个“继承覆盖”对话框，点击全选按钮，再点击确定-确定。

3.3.7、点击“Web服务扩展”，点击其中的“添加一个新的Web服务扩展”，在弹出的窗口中，扩展名栏目填写PHP，点击添加按钮，在添加文件的对话框中文件路径栏目中浏览选择上面提到的php5isapi.dll文件，点击确定，勾选“设置扩展状态为允许”，点击确定。

3.3.8、完成以上操作后，需要重启IIS服务。
　　　　将以下命令命名为IIS.bat文件保存在桌面上【图二十一所示】，双击运行即可重启IIS服务【图二十二所示】，重启好后该窗口会自动关闭。

把以下代码保存为IIS.bat：
@ECHO off
@Title IIS6重新启动
net stop w3svc
net stop iisadmin /y
net start w3svc

【图二十一】

【图二十二】

3.3.9、到此，PHP的基本配置以及完成，IIS中的网站已经可以支持PHP脚本了。
　　　　打开默认网站所指向的文件夹（IIS管理器中网站下面的默认网站上面点击属性，查看主目录，即可在本地路栏目中看到该默认网站的所在文件夹），建立一个test.php文件，文件中内容如下：

把以下代码保存为test.php：
Phpinfo();
?>

3.3.10. Open the browser and enter: http://localhost/test.php. All information about PHP supported by this server will be displayed. You can see that the PHP version is 5.2 .8, Server API mode is: ISAPI[shown in Figure 23].

[Figure 23]

3.3.11, or use PHP probe inspection (a php with specific and intuitive PHP environment configuration detection File, download link: http://ideacm.com.cn/read.php?11), after downloading, unzip it and access it in the root directory of the website [As shown in Figure 24] .

[Picture 24]

The fourth step, install MySQL [must ensure before installation There is no version of mysql or mysql directory in your server]

3.4.1. After decompressing the downloaded mysql-5.0.67-win32.zip compressed package file, double-click to run Setup.exe【As shown in Figure 25】

【Figure 25】

3.4.2. Here is the installation welcome interface. Click [Next>] to start the next step of installation. The default is Typical. It is recommended to change it to Custom. Because Typical mode does not allow changing the installation path, it can only be installed on the C drive . Select the Custom option, [shown in Figure 26].

[Picture 26]

3.4.3. Click [Next>]【As shown in Figure 27】

【Figure 27】

3.4.4, At this step, you need to select the component and change the folder location. Use the default component. The folder location can be changed by selecting Change. It is recommended that the path be set to D :PHPMySQL5(You can also choose other disks for installation) (Note: The path to install mysql cannot contain Chinese! ). [Picture 28]

[Picture 28]

3.4.5 , click [OK][shown in Figure 29]

[Figure 29]
3.4 .6. Click [Next>][shown in Figure 30]

[Figure 30 】
3.4.7. Everything is ready, click [Install] to start the installation. 【As shown in Figure 31】

【Figure 31】
3.4.8. After finishing here, click [Next>], [Next>], such as [shown in Figure 32], selected by default Start configuring the MySQL server now . Click [Finish] to continue.

[Figure 32]

3.4.9. To start configuration, click [Next>]Continue.【As shown in Figure 33】

【Figure 33】
3.4.10. Select Detailed Configuration【Figure Picture 34]

[Picture 34]
3.4.11, click [Next>] to continue [As shown in Figure 35]
This option is to choose the type of mysql application. The first is a development server, which will occupy as little memory as possible. The second is an ordinary web server. It will occupy a medium amount of memory. The last option is to only run the MySQL database on this server, which will occupy all the memory. Choose the second option here. You can choose other options according to your own needs.

[Picture 35]
3.4.12. Click [Next>] to continue [As shown in Figure 36]
Here is the choice of database usage. The first one is multi-purpose, which will optimize the database into a good InnoDB storage type and high Efficient MyISAM storage type, the second is only used for transaction processing type, the best optimization InnoDB, but also supports MyISAM, the last one It is a non-transaction processing type, suitable for simple applications. Only the MyISAM type that does not support transaction processing is supported. Generally choose the first multi-functional .

[Picture 36]
3.4.13. Click [Next>]Continue [As shown in Figure 37]
Here is the data storage location for selecting InnoDB. It is generally set by default and does not need to be changed.

[Picture 37]
3.4.14. Click [Next>]Continue [As shown in Figure 38]
Here is the selection of the maximum number of connections allowed by mysql. The first is the maximum number of concurrent connections of 20, the second is the maximum number of concurrent connections of 500, and the last is Customized, you can choose according to your needs. Here I choose the third custom item and enter 20 (you can select or enter according to your specific needs).

[Picture 38]

3.4.15, click [Next>]Continue[As shown in Figure 39]
Here is the port to select for database monitoring. The default is usually 3306. If you change it to another port, you can connect later. When using the database, you must remember the modified port, otherwise you cannot connect to the mysql database . It is recommended not to modify it and use the default port of mysql: 3306.
　Check the "Add firewall exception for this port" after the port setting. If you enable the Windows Firewall, the port set here (3306 ) is excluded (allow to connect to the network) (If you have not turned on Windows Firewall, do not check here, Windows server 2003 genuine version is not turned on by default ).
　Uncheck the Enable Strict Mode below and change it to unchecked. [As shown in Picture 40]

[Picture 39]

[Picture 40]
3.4.16, click [Next>]Continue[shown in Figure 41]
This step sets the default for mysql Encoding, the default is latin1. It is recommended to choose the third customization item and change it to utf8.

[Picture 41]

3.4.17. Click [Next>] to continue [As shown in Figure 42]
This step sets mysql as a windows service. service name is the service name for naming MySQL. The following launch the mysql server automaticallyCheck it to indicate that the service runs automatically. In this way, the mysql database can be started and closed through the windows service in the future.
　 Then check the following Include Bin Directory in Windows PATH (this means automatically modify the environment variable in PATH Add ../bin directory to the value).

[Picture 42]

3.4.18, click [Next>]Continue[As shown in Figure 43]
　This step is to set the super user password of mysql. This super user is very important and has all the knowledge about mysql. Permissions and passwords must be remembered.
　 Enter the password to be set twice in the two input boxes (New root password, Confirm).
　For security reasons, generally do not select "Enable root access from remote machines". It is very dangerous to allow external connections to the database.
　"Create An Anonymous Account" is to create an anonymous account. This will cause unauthorized users to illegally access your database, which is a security risk. It is recommended not to check it.

[Picture 43]
3.4.19. Click [Next>]Continue [As shown in Figure 44]
At this point, the mysql database has obtained sufficient configuration conditions

[Figure 44]
3.4.20. Click [Execute] to start executing the previously set MySQL configuration to make it effective. [As shown in Figure 45]
Click [Finish] to complete the installation.

[Picture 45]

3.4.21. Check the "" of "Control Panel" In "Management Tools ", whether "Service " has "MySQL " process [shown in Figure 46]

【 Figure 46]
3.4.22. For further optimization settings of MySQL, you can refer to relevant information, or visit this website: http://ideacm.com.cn/read.php?13

MySQL installation completed

Step 5, install Zend Optimizer

3.5.1, directly Double-click the downloaded ZendOptimizer-3.3.3-Windows-i386.exe and run the installation program [shown in Figure 47]

[Figure 47 】

3.5.2. Click [Next>]Continue[As shown in Figure 48]
　Select "I accept the terms of the license agreement" to agree to the license agreement.

[Picture 48]

3.5.3. Click [Next>]Continue[As shown in Figure 49]
Here is the location where Zend is located. According to the previous rules in this article, change the Zend installation path to D:PHPZend .[As shown in Picture 50]

[Picture 49]

[Picture 50 】
3.5.4. Click [Next>]Continue[As shown in Figure 51]
Choose you here Web server version, because we need to configure it in IIS and IIS has been installed before, so the first item IIS has been selected by default (if IIS is not selected by default, please click to select it manually ).

[Picture 51]
3.5.5. Click [Next>]Continue [As shown in Figure 52]
Select the directory where the PHP configuration file php.ini is located. Here the automatically default path is the directory where the Windows system is located (C:Windows , if your system is installed on the D drive, you should enter D:Windows) here. If the default path here is not the directory where the Windows system is located, please modify it manually.

[Picture 52]

3.5.6. Click [Next>] to continue [As shown in Figure 53]
Here is to select the directory where your website is located. Here you can choose according to your default site directory, or you can directly select D:PHPZend, in order to standardize the website directory structure, I put all the websites to be built in the D:webroot directory, so I changed the path to D:webroot [As shown in Picture 54]

[Picture 53]

[Picture 54]

3.5.7, click [Next>]Continue[shown in Figure 55]
　This The interface is a step-by-step preview of the previous settings. If the previous settings are incorrect and need to be modified, click the [<Back] button to return and modify as needed. If it is confirmed that there is no problem, just click the [Install] button to install.

[Picture 55]

3.5.8. After clicking the [Install] button A dialog box will pop up, to the effect that the IIS service needs to be shut down during the subsequent installation process until the installation process is completed. Click "Yes (Y)" to agree to the execution, and click "No (N)" to refuse execution, click "Yes (Y)" here.【As shown in Figure 56】

【Figure 56】

3.5.9, Stopping Web server (IIS) 【 As shown in Figure 57]
After Zend is installed, automatically open the Web Server (IIS) [As shown in Figure 58]

[Picture 57]

[Picture 58]

3.5.10. The entire zend installation process is completed, remove "View Readme Now” Check the check mark in front of the documentation and click the [Finish] button to complete the installation. 【As shown in Figure 59】

【Figure 59】
3.5.11, About Zend Optimizer configuration file For detailed instructions, please refer to relevant information, or browse this website: http://ideacm.com.cn/read.php?12

Step 6. Configure phpMyAdmin to manage MySQL

3.6.1. Create a directory named phpMyAdmin under D:PHP, and download the downloaded phpMyAdmin -2.11.9.4-all-languages.zipUnzip and copy the files and folders inside. 【As shown in Figure 60】

【Figure 60】
3.6.2. First open Internet Information Services (IIS ) Manager, click "+" to expand the directory tree, then expand the website, right-click on the Default Website-New- Virtual directory . [As shown in Figure 61]

[Picture 61]

3.6.3. Pop-up Click the Next button in the panel and enter in the alias field: phpmyadmin[shown in Figure 62]

[Figure 60 2】

3.6.4. Click the Next button and select the path: D:PHPphpMyAdmin[As shown in Figure 63]

[Picture 63]

3.6.5. Click the Next button and check "Read" , "Run script (such as asp)" these two items[shown in Figure 64], then click Next-Complete.
　【The settings in this step can be based on your own specific needs to create an independent website as phpMyAdmin or create a virtual directory in any website you have already established to use phpMyAdmin】

[Figure 64]

3.6.6. Find and open the config.default.php file in the D:PHPphpMyAdminlibraries directory.

3.6.7. Find: $cfg['PmaAbsoluteUri'] = '';
　 Here is the web access address of your phpMyAdmin, according to For the settings in the previous step, the address I filled in here is: http://localhost/phpmyadmin/ [As shown in Figure 65]
　 $cfg['PmaAbsoluteUri'] = 'http://localhost/phpmyadmin/';

[Figure 65]

3.6.8, Search: $cfg['blowfish_secret'] = '';
　 Here is the cookie encryption key, you can set any legal characters.My settings here are as follows: 【As shown in Figure 66】

【Figure 66】

3.6.9, Search: $ cfg['Servers'][$i]['auth_type'] = 'config';
　 Defaultconfig, if set to config, you only need to access it directly You can directly manage MySQL using the login address of phpmyadmin. This is unsafe and not recommended.
It is recommended to use cookie and set it to: $cfg['Servers'][$i]['auth_type'] = 'cookie'; [Picture Shown in Figure 67]

[Figure 67]

3.6.10. If you must set it to config, please Then fill in your MySQL management account root and password in the following lines. 【As shown in Figure 68】

【Figure 68】

3.6.11. Search: $cfg['DefaultLang'] = 'en-iso-8859-1';
Set it to: $cfg['DefaultLang'] = 'zh-gb2312';

3.6.12. Find: $cfg['DefaultCharset']
Set it to $cfg['DefaultCharset'] = 'gb2312';

3.6.13, then save and close.
Please refer to relevant information to get familiar with the richer functions of phpMyAdmin. I will not go into details here.

Step 7: Directory permission settings (the permission settings here are for reference only. More detailed and strict permission control can be done according to your actual needs. I will not go into details here. . )

3.7.1, D:PHP directory is set to admin user group or account of a certain administrator group, system full permissions, users group read and run permissions.
　The php5 and tmp directories give everyone full control permissions.
　MySQL5, Zend just inherit the permissions of the upper-level PHP directory.
　phpMyAdminOn the basis of inheriting the permissions of the superior PHP directory, adds the read and run permissions of an Internet guest account.

4. The configuration is completed. Check whether the configuration just now is correct by opening phpMyAdmin

4.1. Double-click the IIS.bat file on the desktop to restart the IIS server, and then Then enter in the browser address bar:
　http://localhost/phpmyadmin
　The login interface of phpMyAdmin will appear [shown in Figure 69]

[Figure 69]

4.2. Enter the MySQL management account root and the root account password, click the Execute button to log in to phpMyAdmin to perform MySQL management operations. 【As shown in Figure 70】

【Figure 70】

At this point, the entire environment configuration is completed.

5. Supplementary explanation

5.1 , in order to avoid re-copying the dll files in the php5 directory to the system location C:windowssystem32 directory, you can skip the 3.1.2 step and do not operate, then right-click " on the desktop My Computer ”-Properties-Advanced -Environment variables -System variables -Then find the variable "Path", click Edit, and add ";D:PHPphp5” (characters within quotation marks, excluding quotation marks), click Confirm, then click New, and enter "phpext for the variable name ", enter the variable value as "D:PHPphp5ext", click OK.

5.2, in order to avoid some phpprogram due to session is configured and cannot be used normally, you can skip the 3.1.7 step and do not operate.

5.3. After completing the entire configuration process, restart the computer.

5.4, if after all configurations are completed, access phpmyadmin and a red interface will appear Tip, please check the settings of phpmyadmin according to 3.6.6-3.6.13, and then follow the settings of 3.7.1Check permission settings.