Iis6+php5+mysql5+zend optimizer+phpmyadmin Installation Configuration Graphic Tutorial 2009 _php Instance

Source: Internet
Author: User
Tags configuration php php server php software set cookie windows x86 root access virus scan
Convenient for everyone to reprint and offline reading, this tutorial HTML source code, UBB source, pdf version, flash version to provide download.
Download Address: Http://code.google.com/p/wpmi/downloads/list

Operating system: WINDOWS.SERVER.2003.R2,ENTERPRISE.EDITION,SP2,X86,CHS,VOL,MSDN
This configuration PHP server environment: windows2003+ iis6+php5+mysql3+zend+phpmyadmin
The entire configuration process needs to be logged into Windows with a System account with administrator privileges
As shown in the entire configuration process may vary depending on the system used, the window interface is different, but the corresponding tab column is the same, only need to find the corresponding tab mentioned.

First, download the relevant software


The software to be prepared before installation (because I use the server operating system is x86 version, so the following programs are used in the Windows X86 Environment version) No special instructions are the latest version until January 16, 2009

1, PHP recommended PHP 5.2.8 Zip compression package version
PHP 5.2.8 Zip Package [10,115kb]-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 recommended MySQL 5.0.67 version of Windows Zip/setup.exe (x86)
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 recommended the latest version, now the latest version is Zend Optimizer v3.3
(Although the download is free, but to register the user, can download, in order to facilitate the use of everyone, public I registered a good user name: ideacmblog password: ideacm.com.cn, convenient for everyone to use, I hope everyone in the use of this account do not change the password and for other non-legitimate ways)
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, PhpMyAdmin here is not recommended to use the latest version, recommended PhpMyAdmin 2.11.9.4 Phpmyadmin-2.11.9.4-all-languages.zip version
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


II. Preparation before installation and configuration

2.1, first to download the file back to use antivirus software to do a virus scan, in case of accidents. "As shown in Figure a"

"Figure I"


2.2, OK, now start the environment configuration:
Assuming the operating system is installed on the C drive, if your system is not installed on the C drive, please modify the drive letter mentioned below. At the same time, in order to avoid C drive because of the reinstall system and other reasons for the operation of the C-disk, do not recommend the PHP software installed in the C drive, here I put the PHP related program installed in the D:\PHP directory (this directory you can also define your own, if you want to install in a different path, Please modify the corresponding path mentioned in your own way).

Iii. Formal start of environmental configuration

first step, install PHP

3.1.1, unzip the downloaded Php-5.2.8-win32.zip file into the D:\PHP directory, Rename the resulting level two directory Php-5.2.8-win32 to PHP5, or you can unzip the Php-5.2.8-win32.zip in the default location and copy the extracted files and folders to D:\PHP\php5 "figure two."

"Figure II"

3.1.2, and then the D:\PHP\PHP5 directory of all DLLThe file is copied to C:\windows\system32 (Windows2000 system is C:\winnt\system32, the same as below), if there are already several files with the same name, overwrite. "As shown in figure three or four."

"Figure three"


"Figure Four"



3.1.3, copy the php.ini-dist in the D:\PHP\PHP5 directory, rename it to PHP.ini (or in the current directory), and then open the php.ini with the text editing software (Notepad2, EditPlus, UltraEdit and other text editing software that supports syntax highlighting.

"Figure Five"


3.1.4, find: register_globals = Off (about line No. 419)
Change off to ON, i.e. get register_globals = on;
Note: This global variable function for PHP, consider a lot of PHP programs need global variable function, so open, please pay attention to the rigor of PHP program, if you do not need the global variable function, please keep the default off state.
Search again for extension_dir = "./" (about line No. 491)
The path to know your PHP directory under the Extensions feature directory, where PHP5 corresponds to Extension_dir = "D:/php/php5/ext".
Create a folder under D:\PHP and name it tmp
to find; Upload_tmp_dir =
Upload_tmp_dir = The comment character of the line, which is the preceding semicolon ";" Remove to make the line work in the php.ini document.
Upload_tmp_dir is used to define the temporary path of the upload file storage, where you can also modify and define a decision path, it should be noted that the directory set here must have read, write permissions.
Here I set to Upload_tmp_dir = D:/php/tmp (This is the folder I created earlier)
3.1.5, search; Windows Extensions, navigate to the php.ini file for about 604Line, remove the semicolon comment in front of the common extensions listed below:

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

Special NOTE: The EXIF extension is used to display EXIF information for a picture, since the extension requires mbstring support, so move the Extension=php_exif.dll line below the Extension=php_mbstring.dll line.
; 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, find:;d Ate.timezone =
Remove the previous semicolon comment, set it to Date.timezone = PRC
Notes on time zone settings:
From php5.1.0 onwards, PHP.ini added date.timezone this option, by default is off, that is, the time displayed (no matter what the PHP command) is Greenwich Mean time, and our time (Beijing time) difference is exactly 8 hours, there are the following 2 ways to restore normal time.
1, if you want to use more than 5.1 version, and do not modify php.ini, you need to be on the initialization of the time of the statement with Date_default_timezone_set (XXX), or use the date (' y-m-d g:i:t ', Strtotime ( ' +8hour ')) to obtain the date and time;
2, once and for all, only can modify php.ini. Open the php.ini to remove the semicolon in front of the date.timezone, add xxx after =, restart the HTTP service (such as Apache2 or IIS, etc.).
For XXX, the values available in mainland China are: asia/chongqing, Asia/shanghai, Asia/urumqi (Chongqing, Shanghai, Urumqi, respectively), Taiwan available: Asia/macao, Asia/hong_kong, asia/ Taipei (Macau, Hong Kong, Taipei) and Singapore: Asia/singapore, the above is not Beijing, but then look down, the other available values are: Etc/gmt-8,singapore, HONGKONG,PRC (People's Republic of China).

3.1.7, find:; Session.save_path = "/tmp"
Remove the previous semicolon comment, set it to Session.save_path = "D:/php/tmp" (This is the folder I created earlier)

3.1.8, if you have encountered the inability to upload large files or run some programs often time out, then you can modify the following to adjust the relevant limits:
In about the first 255Yes
Max_execution_time = 30; This is the maximum time each script runs, changing the value according to your needs, in seconds
Max_input_time = 60; This is the time each script can consume, change the value according to your needs, the unit is the second

About the first 258Yes
Memory_limit = 128M; This is the memory that the script runs up to, changing the value according to your needs.

About the first 552Yes
Upload_max_filesize = 2M
Upload the maximum allowable size of the file, change the value according to your needs, M is the unit: trillion.
3.1.9, php.ini file is basically made as modified, the other you can modify according to their specific needs, and then save the file, and then copy one to C:\Windows below.


Step Two, install IIS

3.2.1, open the Add or Remove Programs panel, as shown in Figure six
The Add or Remove Programs panel can be opened in the following two ways:
1. Click "Start"-"Control Panel"-"Add/Remove Programs";
2, directly in the "Start"-"Run" Input: Appwiz.cpl ( enter OK)


"Figure Six"


3.2.2, click "Add/Remove Windows Components (A)" as shown in Figure seven.

"Figure Seven"


3.2.3, visible "Windows Component Wizard", "Figure eight"

"Figure Eight"


3.2.4, drag the right scroll bar inside the panel until you see the application server, click to select it in front of its check box, tap Details, and then click the check box in front of "ASP." In the "Internet Information Services (IIS)" Click on it (the check box is currently selected here, click on its text, not click on the signature check box), then click "Details (D)" In the open panel, drag the right scroll bar down. Then click on "World Wide Web Service" and click "Details".
Tick "Active Server Pages", "Internet Data Connector", "Include Files on server side" and "World Wide Web Service" selected.

3.2.5, then click OK (World Wide Web Service panel)-OK (Internet Information Services (IIS) panel)-OK (Application Server panel) "Figure Nine"-Next (Windows Components Wizard panel), the configuration process will pop up the required file dialog box "shown in Figure 10", This time the system installation CD into the CD-ROM drive, click Browse, select the drive letter, enter the I386 folder, this time will automatically display the required files, directly click on "Open" "Figure 11", and then click "OK" "Figure 12, 13," and this time will pop up a "Required files" dialog box, or follow the steps, click "Browse", then navigate to the I386 folder, this time will automatically display the required files, click "Open"-"OK", and then wait until the "Windows Components Wizard" completed the interface "Figure 14", click "Finish", the "windows Setup Please wait ... "dialog box, wait for it to close automatically, and then close the Add or Remove Programs panel, in the Start-Control Panel-Administrative Tools menu, you can see the Internet Information Services (IIS) Manager, this time IIS has been installed" Figure 15. "

"Figure Nine"



"Figure 10"



"Figure 11"



"Figure 12"



"Figure 13"


"Figure 14"


"Figure 15"


The third step, configuring IIS to support PHP

3.3.1, open the browser, enter: http://localhost to normal access, see "building" similar to the text of the page "shown in Figure 16."

"Figure 16"

3.3.2, PHP support CGI and ISAPI two kinds of installation mode, CGI consumes more resources, it is easy because time-out and no response, but in fact is relatively safe, ISAPI load capacity, save resources, but the security is slightly worse than CGI mode, the use of ISAPI mode is recommended here. Therefore, only the ISAPI mode configuration method is described here.

3.3.3, open Internet Information Services (IIS) Manager (at Start-run input: inetmgr, EnterOK, or click the icon in the Admin tool mentioned above)
Click "( Computer name) (local computer) "before" +, expand the tree directory. "As shown in Figure 17."

"Figure 17"


3.3.4, right-click on the "site", View "Properties", click on the "ISAPI Filter" tab, and click on the "Add" button, in the "Add/Edit Filter Properties" Panel in the "Filter Name" column, enter: PHP, then click on the "Browse" button under "Executable", select the Php5isapi.dll file (follow the previous settings where the path should be D:\PHP\php5\php5isapi.dll), click on the Open button "Figure 18," so that "executable file path" Point to the file. Click the "OK" button, then click on the "Home Directory" tab, find and click on the "Configure" button, in the "Application Configuration" Panel in the pop-up "Application Extensions" tab to find and click the "Add" button to create a new extension mapping, and then click "Executable file" after the "Browse" button, Select the Php5isapi.dll file (follow the previous settings where the path should be D:\PHP\php5\php5isapi.dll), and in the "Extensions" column enter: . PHP, the action limit is: Get,head,post,trace, "script Engine", "Confirm file existence" Check "Figure 19" (if you want to support PHP files such as. php5,. phtml, etc., you can repeat the "add" step, Set the extension to desired, then click the OK button (Add/Edit Application Extension Mapping panel), click "Options", select "Enable Parent path", then click OK button.
This step will enable all the sites under IIS for your server to support the PHP extension file you added, if you only need to support PHP in some sites, just need to support PHP Web site (Expand the "Web site" directory and visible), such as "Default Web Site" Right-click on the Select "Properties", in the Open " In the properties of the default Web site, in the Home Directory tab, do the Add/Edit Application extensions action above, or remove the. php extension mappings from sites that you do not need to support PHP.

"Figure 18"


"Figure 19"


3.3.5, open the Documents tab in the Web Site properties, add index.php and default.php items to the Enable Default content Documents list, or move them up to the top two so that when you visit the site, you will first look for and open the index.php, default.php documentation. "As shown in Figure 20."
What is the default content document:
The default content document is the default home page, which is a file that is automatically located when you access a file directory. For example, there are many different names of files in your host space, However, you want to enter the URL ideacm.com.cn, the default access to one of the files called index.htm, then you need to set the default home page to Index.htm, you can add a number of default content documents, when accessing the site will automatically according to the default content document sorting to take precedence.

"Figure 20"

Here I recommend the default content document to be set in the following order:
Index.htm
Default.html
Index.html
Default.html
Index.asp
Default.asp
Index.aspx
Default.aspx
index.php
default.php

3.3.6, set the default content document, click the Apply button, will pop up an inheritance Overlay dialog box, click the Select All button, then click OK-OK.

3.3.7, click "Web Service Extension", click on the "Add a new Web service extension", in the pop-up window, the extension column to fill in PHP, click the Add button, In the file path section of the Add File dialog box, browse to select the Php5isapi.dll file mentioned above, click OK, tick "set extension status to allow", click OK.

3.3.8, you will need to restart the IIS service after you have completed the above operation.
Name the following command as the Iis.bat file saved on the desktop as shown in Figure 21, double-click to restart the IIS service as shown in Figure 22, and the window will close automatically when it is restarted.
Save the following code as Iis.bat:
@ECHO off
@Title IIS6 Restart
net stop w3svc
net stop iisadmin/y
net start w3svc


"Figure 21"


"Figure 22"


3.3.9, to this, the basic configuration of PHP and completion, the Web site in IIS can support the PHP script.
Open the folder that the default Web site points to (the default Web site below the IIS Manager site, click Properties, view the home directory, you can see the default site in the local Road column folder), create a test.php file, the file content is as follows:
Save the following code as test.php:
Phpinfo ();
?>

3.3.10, open Browser input: http://localhost/test.php, will display all the information that the server supports PHP, you can see the PHP version of the 5.2.8,server API mode is: ISAPI "figure 23."

"Figure 23"

3.3.11, or the use of PHP probe check (a specific, intuitive PHP environment configuration detection php file, download link: http://ideacm.com.cn/read.php?11), download and extract to the site root directory Access can be "shown in Figure 24."

"Figure 24"


Fourth step, install MySQL "Before installing, you must ensure that there is no version of MySQL or MySQL directory on your server"

3.4.1, unzip the downloaded Mysql-5.0.67-win32.zip compressed package file, double-click Run Setup.exe "Figure 25"

"Figure 25"

3.4.2, here is the Install Welcome screen, click [ NExt>] Start the next installation. The default is typical, it is recommended to change to custom, because typical mode is not allowed to change the installation path, can only be installed on the C drive. Select the Custom option, as shown in Figure 26.

"Figure 26"

3.4.3, click [ NExt>] "Figure 27 shows"

"Figure 27"



3.4.4, to this step, you need to select components and Change folder location, the components are used by default, folder location can be selected CHange to change, the recommended path is set to D:\PHP\MySQL5\ (you can also choose another disk to install) (note: The path to install MySQL can not contain Chinese!) )。 "As shown in Figure 28."

"Figure 28"



3.4.5, click [OK] "Figure 29"

"Figure 29"
3.4.6, click [ NExt>] "Figure 30 shows"

"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 the end of this, click [ NExt>], [ NExt>], as shown in Figure 32, the default check now starts configuring the MySQL server. Click FInish] continue.

"Figure 32"

3.4.9, configure start, click [ NExt>] continue. "As shown in Figure 33."

"Figure 33"
3.4.10, select detailed Configuration "Figure 34"

"Figure 34"
3.4.11, point [ NExt>] Continue "as shown in Figure 35."
This option is to choose which type of MySQL to apply to, the first is the development server, will occupy as little memory, the second is a normal Web server, will occupy a medium amount of memory, the last is this server only run MySQL database, will occupy all the memory, here Select the second item, Depending on your needs, you can choose other options.


"Figure 35"
3.4.12, click [ NExt>] Continue "as shown in Figure 36."
Here is the choice of database use, the first is multi-purpose, will be the database optimization to a good InnoDB storage type and efficient MyISAM storage type, the second is only for transaction type, the best optimization innodb, but also support MyISAM, the last kind of non-transaction processing, Suitable for simple applications, only myisam types that do not support transactional processing are supported. Generally choose the first multifunctional.

"Figure 36"
3.4.13, click [ NExt>] Continue "as shown in Figure 37."
Here is the choice of INNODB data storage location, the general default is good, no need to change.

"Figure 37"
3.4.14, click [ NExt>] Continue "as shown in Figure 38."
Here is the choice of the maximum number of connections allowed by MySQL, the first is the maximum number of 20 connection concurrency, the second is the maximum number of 500 concurrent connections, the last is custom, you can choose according to their own needs. Here I choose the third customization, enter 20 (you can choose or enter according to your specific needs).

"Figure 38"


3.4.15, click [ NExt>] Continue "as shown in Figure 39."
Here is the choice of the database listening port, the general default is 3306, if you change to another port, the future connection to the database to remember the modified port, otherwise you can not connect to the MySQL database, it is recommended not to modify the default port with MySQL: 3306.
Check the "Add firewall exception for this port" next to the ports setting, and if you turn on Windows Firewall, the port (3306) set here will be automatically excluded (network connection allowed) ( If you do not turn on Windows Firewall here do not check, Windows Server 2003 genuine default is not turned on)。
The following enable Strict mode check is removed, instead of selected. "As shown in Figure 40."

"Figure 39"


"Figure 40"
3.4.16, click [ NExt>] Continue "as shown in Figure 41."
This step sets the default MySQL encoding, the default is Latin1, it is recommended to select the third customization, change it to UTF8.

"Figure 41"

3.4.17, click [ NExt>] Continue "as shown in Figure 42."
This step sets MySQL to the Windows service, the service name is named MySQL, and the following launch the MySQL server automatically check indicates that the service is running automatically. This allows you to start and close the MySQL database from the Windows service.
Then check the following include Bin Directory in Windows path (this represents automaticallyModify the environment variable to increase in the value of path: /bin directory).

"Figure 42"


3.4.18, click [ NExt>] Continue "as shown in Figure 43."
This step is to set up the MySQL super user password, this super user is very important, the MySQL has all the permissions, set the password must be remembered well.
Enter the password to be set two times in the two input boxes (New root password, Confirm).
For security reasons, generally do not select "Enable root access from remote machines", allowing the database to be outside the connection is very dangerous.
Create an Anonymous accounts is an anonymous account that causes unauthorized users to access your database illegally, with security implications and not recommended.

"Figure 43"
3.4.19, click [ NExt>] Continue "as shown in Figure 44."
In this step, the MySQL database has been given sufficient configuration conditions

"Figure 44"
3.4.20, click [Execute] to start executing the MySQL configuration set before it takes effect. "As shown in Figure 45."
Click [Finish] to complete the installation.

"Figure 45"


3.4.21, view the "Administrative Tools" in the Control Panel, "service" has "MySQL" process "Figure 46"

"Figure 46"
3.4.22, further optimization of MySQL settings can refer to the relevant information, or browse this site: http://ideacm.com.cn/read.php?13

MySQL Installation complete


Fifth Step, install Zend Optimizer

3.5.1, directly double-click the downloaded Zendoptimizer-3.3.3-windows-i386.exe, run the installer "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.

"Figure 48"

3.5.3, click [ NExt>] Continue "as shown in Figure 49."
Here is the location where you choose Zend, and modify the Zend installation path to D:\PHP\Zend as per the previous rules in this article. "As shown in Figure 50."

"Figure 49"


"Figure 50"
3.5.4, click [ NExt>] Continue "as shown in Figure 51."
Choose your Web server version here, because we need to configure it in IIS, and we have already installed IIS, so the first IIS is selected by default (if IIS is not selected by default, click Select Manually).

"Figure 51"
3.5.5, click [ NExt>] Continue "as shown in Figure 52."
Select the PHP configuration file php.ini directory, where the default path is the directory of the Windows system (C:\Windows, if your system is installed on the D disk, then here should enter D:\Windows), If the default path here is not the directory where the Windows system is located, modify it manually.

"Figure 52"

3.5.6, click [ NExt>] Continue "as shown in Figure 53."
Here is the choice of your site directory, where you can choose according to their default site directory, you can also directly select to D:\PHP\Zend, in order to standardize the site directory structure, I here to set up the site is placed in the D:\webroot directory, so I changed the path to D:\ Webroot "as shown in Figure 54"


"Figure 53"


"Figure 54"

3.5.7, click [ NExt>] Continue "as shown in Figure 55."
This interface is the previous step of the setting preview, if the previous setup is wrong to modify, click [< BACK] button to return and modify as required. If you are sure there is no problem, simply click [ INstall] button to install.

"Figure 55"

3.5.8, click [ INstall] button will pop up a dialog box to the effect that you need to close the IIS service during the next installation process until the installation process is complete, click Yes ( Y"Agree to execute, click" No "(N)" Refuse to execute, click here "Yes ( Y)”。 "As shown in Figure 56."

"Figure 56"

3.5.9, stopping Web server (IIS) "as shown in Figure 57"
When Zend is installed, automatically open Web Server (IIS) "as shown in Figure 58"


"Figure 57"


"Figure 58"

3.5.10, complete the Zend installation process, remove the "View Readme now" Check the description file in front of the tick, click [Finish] button to complete the installation. "As shown in Figure 59."


"Figure 59"
3.5.11, detailed description of Zend Optimizer configuration file can refer to the relevant information, or browse this URL: http://ideacm.com.cn/read.php?12


Sixth Step, configure phpMyAdmin to manage MySQL

3.6.1, D:\PHP under the establishment of a directory named phpMyAdmin, the download of the Phpmyadmin-2.11.9.4-all-languages.zip extracted after the files and folders copied 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 site, right-click on the Default Web site-new-virtual directory. "As shown in Figure 61."

"Figure 61"


3.6.3, in the pop-up panel click the Next button, in the alias column input: phpMyAdmin "Figure 62"

"Figure 62"

3.6.4, click Next button, path selection: D:\PHP\phpMyAdmin "Figure 63"

"Figure 63"

3.6.5, click the Next button, tick "read", "Run script (such as ASP)" Two "Figure 64", then click Next-Complete.
"This step can be set up according to your own specific needs to build a separate website to use as a phpmyadmin or in any of the sites you have established a virtual directory to work with phpMyAdmin"

"Figure 64"

3.6.6, locate and open the config.default.php file under the D:\PHP\phpMyAdmin\libraries directory.

3.6.7, find: $cfg [' pmaabsoluteuri '] = ';
Here is set your phpMyAdmin Web Access address, according to the previous step of the settings, I fill in the address here is: http://localhost/phpmyadmin/"Figure 65"
$cfg [' pmaabsoluteuri '] = ' http://localhost/phpmyadmin/';

"Figure 65"

3.6.8, find: $cfg [' blowfish_secret '] = ';
Here is the set cookie encryption key, you can set any legal characters. I set up here as: "Figure 66 Shows"

"Figure 66"

3.6.9, search: $cfg [' Servers '] [$i] [' auth_type '] = ' config ';
The default config, if set to config, only need to directly access the phpMyAdmin login address, you can directly manage MySQL, is not safe, not recommended.
It is recommended to use a cookie to set it to: $cfg [' Servers '] [$i] [' auth_type '] = ' cookie '; "As shown in Figure 67."

"Figure 67"

3.6.10, if you must be set to config, please fill in your MySQL admin account root and password in the following lines immediately. "As shown in Figure 68."

"Figure 68"

3.6.11, find: $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, and then save the shutdown.
phpMyAdmin More rich features, please refer to the relevant information slowly familiar, here is not detailed.


The seventh step, the Directory permission setting (here the permission setting is only for the reference, according to your actual demand may do more detailed, the strict authority control, here does not detail to repeat. )

The 3.7.1, D:\PHP directory is set to the Administrator user group or an account for one of the Administrators groups, full system permissions, and the Users group reads and runs permissions.
The PHP5, TMP directory gives everyone Full Control permissions.
MySQL5, Zend inherit the upper PHP directory permissions.
phpMyAdmin adds a permission to read and run an Internet Guest account, based on inheriting the permissions of the superior PHP directory.


Four, configuration completed, by opening phpMyAdmin monitoring the configuration is correct

4.1. Double-click the Iis.bat file on the desktop to restart the IIS server, and then enter in the browser address bar:
Http://localhost/phpmyadmin
The login screen for phpMyAdmin will appear "Figure 69"

"Figure 69"

4.2, enter the management account root of MySQL and the previous configuration of the root account password set in the MySQL process, click the Execute button, you can log in phpMyAdmin for MySQL management operations. "As shown in Figure 70."

"Figure 70"
at this point, the entire environment configuration is complete.

v. Additional Information

5.1. In order to avoid re-copying the DLL files in the PHP5 directory after reloading the server system to the C:\windows\system32 directory where the system resides, you can 3.1.2Step skip do not operate, then right click on the desktop "My Computer"-Properties-advanced-environment variables-system variables-then find the "Path" variable, click Edit, add ";D: \php\php5" (the character in quotation marks, not including quotation marks), click OK, then click New, Variable name enter "Phpext", variable value enter "D:\PHP\php5\ext", click OK.

5.2, in order to avoid some of the PHP program due to the session configuration can not be used normally, you may 3.1.7Step skip do not operate.

5.3, after the entire configuration process is complete, restart the computer.

5.4, if all the configuration is completed, access to the phpMyAdmin Red interface prompts, please follow 3.6.6-3.6.13 check the phpMyAdmin settings, and then check the permissions according to 3.7.1 settings.
3

Number of ratings

  • Contact Us

    The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

    If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

    A Free Trial That Lets You Build Big!

    Start building with 50+ products and up to 12 months usage for Elastic Compute Service

    • Sales Support

      1 on 1 presale consultation

    • After-Sales Support

      24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.