Windows 2008 Configuration Run php5.5.x

1. Install the web5.0 platform installation program. web5.0 Platform installation program: Http://www.iis.net/downloads

2. Open the Web Platform Installer, search for "fastcgi", install IIS 7.0 fastcgi update

3. Download the PHP Zip package (non-thread-safe VC9 x86 Non thread safe)

4.

The IIS administration interface---Handler mappings---add module mappings

Request Path: *.php

Module: Fastcgimodule

Executable: Path to Php-cgi.exe

Name: Whatever (example: PHP)

5. Default Document---Add index.php

6. root directory, create phpinfo.php file, content

<?php phpinfo ();? >

Visit http://127.0.0.1/phpinfo.php

7. Install MySQL

Download: http://dev.mysql.com/downloads/mysql/

Download version of MySQL Community Server X64 (. Zip,msi without X64)

Unzip to E:\MySQL (path Custom)

Create a new My.ini configuration file under E:\MySQL, as follows

# MySQL Server Instance Configuration File #----------------------------------------------------------------------# Generated by the MySQL Server Instance Configuration Wizard # # # Installation Instructions #--------------------------- -------------------------------------------# # # CLIENT Section #-------------------------------------------------- --------------------# # the following options will be read by  mysql client applications. # note that only client applications  Shipped by mysql are guaranteed # to read this section. if  you want your own MySQL client program to # honor  These values, you need to specify it as an option during  the # mysql client library initialization. # [client]port=3306[mysql]default-character-set=gbk# server section # ----------------------------------------- ----------------------------- # # the following options will be read  by the MySQL Server. Make sure that # you have  installed the server correctly  (See above)  so it reads this  # file. # [mysqld]  # the tcp/ip port the mysql server  will listen on port=3306    #Path  to installation directory.  all paths are usually resolved relative to this. basedir= "E:\ Mysql\ "  #Path  to the database root datadir=" E:\MySQL\Data " [winmysqladmin]  server= "E:\MySQL\bin\mysqld.exe" user=root [email protected]## the default  character set that will be used when a new schema or table is #  created and no character set is defined default-character-set=gbk   # The default storage engine that will be used when  create new tables when default-storage-engine=innodb  # set the  Sql mode to strict sql-mode= "Strict_trans_tables,no_auto_create_user,no_engine_ SUBSTITUTION " # The maximum amount of concurrent sessions the  Mysql server will # allow. one of these connections will be  reserved for a user with # SUPER privileges to allow  the administrator to login even if the # connection limit  Has been reached. max_conNections=100# query cache is used to cache select results and  later return them # without actual executing the same query  once again. having the query # cache enabled may result  in significant speed improvements, if your # have a lot  of identical queries and rarely changing tables. see the #   "Qcache_lowmem_prunes"  status variable to check if the current  Value # is high enough for your load. # note: in case  your tables change very often or if your queries are #  textually different every time, the query cache may result  In a # slowdown instead of a performance improvement. query_cache_size=0# the  Number of open tables for all threads. increasing this value  # increases the number of file descriptors that mysqld  requires. # therefore you have to make sure to set the  Amount of open files # allowed to at least 4096 in the  variable  "Open-files-limit"  in # section [mysqld_safe] table_cache=256#  Maximum size for internal  (in-memory)  temporary tables. if a  table # grows larger than this value, it is automatically  converted to disk # based table this limitation is for  a single table. there can be many # of them. tmp_table_size=26m# how many  threads we should keep in a cache for reuse. when a  Client # disconnects, the client ' s threads are put in the  Cache if there aren ' T # more than thread_cache_size threads from  before.  This greatly reduces # the amount of thread  Creations needed if you have a lot of new # connections.   (NORMALLY THIS DOESN ' t give a notable performance # improvement  if you have a good thread implementation.)  thread_cache_size=8  #*** MyISAM Specific options  # The  Maximum size of the temporary file mysql is allowed to use while # recreating the index  (during repair, alter table or load data infile.# If the file-size would be Bigger than this, the index would be created # through the key cache (which is slower). myisam_max_sort_file_size=100g# If The temporary file used for fast index creation would bes bigger # than using the key CA  Che by the amount specified and then prefer the # Key cache method.  This is mainly used to force long character keys on # Large tables to use the slower key, cache method to create the index. myisam_sort_buffer_size=52m# size of the Key buffer, used to cache index blocks for MyISAM tables. # do not set it larger than 30% of your available memory, as some memory # are also required by the OS to cache rows. Even if you ' re not using # MyISAM tables, you should still set it to 8-64m as it'll also be # used for internal Temporar Y disk tables. key_buffer_size=40m# SiZe of the buffer used for doing full table scans of MyISAM tables. # Allocated per thread, if a full scan is needed. read_buffer_size=64kread_rnd_buffer_size=256k# This buffer was allocated when MySQL needs to rebuild the index in # REPAIR , Optimze, ALTER table statements as well as in LOAD DATA INFILE # to an empty table. It is allocated per thread so being careful with # large settings. sort_buffer_size=256k#*** INNODB Specific Options * * * innodb_data_home_dir= "e:\MySQL\Data\INNODB\" # Use this option if Y The OU has a MySQL server with InnoDB support enabled # and you don't plan to use it. This would save memory and disk space # and speed up some things.  #skip-innodb # Additional memory pool that's used by InnoDB to store metadata # information.  If InnoDB requires more memory for this purpose it would # start to allocate it from the OS. As this is the fast enough on the most # recent operating systems, you normally does not need the change of this # value. SHOW INNODB STATUS would display the Current amount used. INNODB_ADDITIONAL_MEM_POOL_SIZE=2M # If set to 1, InnoDB'll flush (fsync) The transaction logs to the # disk at each COM MIT, which offers full ACID behavior. If you is # willing to compromise this safety, and you is running small # transactions, you could set this to 0 or 2 to R Educe disk I/O to the # logs. Value 0 means that the log was only written to the log file and # The log file flushed to disk approximately once per Secon D. Value 2 # means the log is written to the log file at each commit, but the log # file was only flushed to disk Approxima Tely once per second. Innodb_flush_log_at_trx_commit=1 # The size of the buffer InnoDB uses for buffering log data. As soon as # It's full, InnoDB'll has to flush it to disk. As it is flushed # once per second anyway, it does does sense to has it very large # (even with long transactions). INNODB_LOG_BUFFER_SIZE=1M # InnoDB, unlike MyISAM, uses a buffer pool to cache both indexes and # row data. The bigger YouSet this less disk I/O is needed to # Access data in tables. On a dedicated database server, the set this # parameter-80% of the machine physical memory size.  Do not set it # too large, though, because competition of the physical memory could # cause paging in the operating system. Note that in 32bit systems you # might is limited to 2-3.5g of the user level memory per process, so does not # set it too high  . innodb_buffer_pool_size=77m # Size of each log file in a log group.  You should set the combined size # of logs files to about 25%-100% of your buffer pool size to avoid # unneeded buffer pool Flush activity on log file overwrite.  However, # Note that a larger logfile size would increase the time needed for the # recovery process. innodb_log_file_size=39m # Number of threads allowed inside the InnoDB kernel. The optimal value # depends highly on the application, hardware as well as the OS # Scheduler properties. A too high value may leads to thread thrashing. Innodb_threaD_concurrency=8 

View Code

8. Add the following to the Windows System environment variable (to facilitate command-line commands)

New

Mysql_home= "D:\MySQL\"

Add %mysql_home%\bin to the user variable's path

9. Register MySQL as a Windows system service. The exact action is to execute the following command on the cmd command line:

Mysqld Install MySQL--defaults-file= "E:\MySQL\my.ini"

5

Will

Mysql

Registered as

Windows

System services. The specific action is to execute the following command on the command line:

Mysqld Install MySQL--defaults-file= "D:\MySQL\my.ini"

Remove Service for mysqld remove

10. Start MySQL:net start MySQL

11. Change the root password to 62386997

Method One:

C:>mysql

–

Uroot

Mysql>show databases;

Mysql>use MySQL;

mysql> UPDATE user SET Password=password ("62386997") WHERE user= ' root ';

mysql> FLUSH privileges;

Mysql> QUIT

Method Two:

Leverage third-party management tools

Navicat8 for Mysql

Make changes