Windows 2008 Configuration Run php5.5.x

Source: Internet
Author: User
Tags iis administration phpinfo

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&NBSP;THIS&NBSP;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

Related Article

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.