WindowsApacheMysqlPHP环境的安装与配置图文教程经典整合版

WindowsApacheMysqlPHP环境的安装与配置图文教程经典整合版所需文件:mysql-essential-5.1.48-win32.msiphp-5.2.6-Win32.zipPECL5.2.6Win32binaries.ZIP配置要求:1、将Apache+PHP+Mysql安装在2、将网页文档文件改为：Apache的安装：单击Iacceptthetermsinthelicenseagreement之后再单击Nextoii^ApacheHTTPServer2_2-InstallationΨi≡aιd lʒ<^lReadThisFirstReadthisBefore用LlnningΛpacheonWindows.ApacheHTTPSer√er ʌS网hatisit?TheApacheHTTPSenrerisəpowerfulandflexibleHTTP∕1.1compliantwet∣server.OriginallydesignedasareplacementfortheNCSAHTTPServer,ithasgrowntobethemostpopularwebserverontheInternet.AsaprojectoftheApacheSoftwareFoundation,thedevelopersaimtocollaborativelydevelopandmaintainarobust,commercial-grade,standards-basedserver∣withfreelyavailablesourcecode.TheLwtBstIwsicinDetailsofthelatestversioncarbefound□r∣theApacheHTTPserverprojectpageunder:httιHhtt口d.a口白Ch曰□r^cιJC vInstaIlShieId <Back Next> Cancelji^ApacheHTTPServer2_2-InstallationTisaidServerInformationPleaseenterγo□rserver'sinformation,NetWorkDomaiπ(e.g.sor∩enet.cor∩)∣yr∣r∣g∣Λ∣ei.l∩∣Zdldr∣rr∣.aiπServerName(e.g.www.s□rr∣eπ):∣yong∣Λ∣ei.IuCdldr∣rr∣ainAdministrator'sEmailAddress(e.g.webma5ter@somenet.con):∣⅛dmiπ@yQ∏gwei.∣QcaldQmaiπInfallApacheHTTPServer2、2programsandshortcutsfar;.(：⅛rAllUsersjonPort80jasaService--Recommended.'ι:onlyFortheCurrentL∣≡erjonPortSOSOjwherstartedManually.InstaIl5hieId<Back][^世曰Xt> [[Cancel服务器信息能够按照默认配置，假如服务器的80端口没被其他服务器程序占据。可选“forAllUsers,onPort80,asaService—ReCommended.”假如仅为当前用户使用，使用8080端口，手动启动，选择“onlyfortheCurrentUser,onPort8080,whenstartedManUally.”。单击“Next”。ApacheHTTPServer2_2-InstallationTisaidSSetupTypeChoosethesetuptypethatbestsuitsyourneeds.Pleaseselectasetuptype.IypicalΓTypicalprogramFeatures冈illbeinstalled.CHeadersandLibraries

ForCorripilingmoduleswillnotbeinstalled.)@tustom：IiIIaiiimiιιιιιιιιifChoosewhichprogramFeaturesFclLlwantinstalledandwherethey

WiIlbeinstalled.Recoπ∩π∩eπdeclforadvancedusers.M艮⅞± ]∣ 世已Xt>Cancel“Typical”为默认安装，“Custom”为用户自定义安装。选择"Custom"，单击"Next”。⅛acheHTTPServer2.2-InstallationTizardCustomSetup5electtheproŋrarnfeaturesyouɪʌɪantinstalled,Clickor∣aniconintheIi丈bθlovʌitocher∣gehowaFeatureisinstalled.~^^ΞΞΓ∙I4p⅞±∣eHTTP5er√crL2.15

Sl“ApacheRuntin∣e区一BuildHeadersandLibrariesFeatureDe5criρ∣]L∣r∣THgFedtLreinstallstheheadersandIibrarfesrequiredtocompile.≡∣r∣dlinkadditionalmodules.QThiξfeatm-ewillbeiiLΞt=dlledon1oc：alhard,⅛ive._JgThisf∈atm'ejandallΞubfeatm-∈Ξjwillb∈inst：±11edonLqgalhard∣lι-ive.Thiξfeatm-ewillnotl∣eaval1able.Installto:Change...InstalShieIdHe∣PSp∣3ceNext>Cancel单击“BuildHeadersandlibraries”，选择“Thisfeaturewillbeinstalledonlocaldirive.ApacheHTTPServer2_2-InstallationTisaid单击“Change…ApacheHTTPServer2_2-InstallationΨi≡aιd区ChangeCurrentDestinationFolderBrowseLqthedestinationfolder,Lookir∣!年Apache2.Ξ¾∣⅛∣Foldername:(NotethatbackslashesarerequiredjuseC:\PathjnotC:/Path)H√⅛pj匚he∖I∏5tall5hieId OK Cancel单击“Next”。i⅝ApacheHTTPServer2_2-InstallationΨi≡aιdReadytoInstalltheProgramThevisardifreadytobegininstdl⅞ti□n.ClickInstaIItobegintheinstallation.Ifyouwanttorevieworchangeanyofyouriπstalldtic∣πsettiπgsjclickBack.ClickCanceItoexitthewizard.I∏5tall5hieId M.aι±# 里逅h 孑I 匚an匚回单击“Install”。ApacheHTTPServer2_2-InstallationTisaidΓ∏InstallingApacheHTTPServer2.2.15ThePrCIgr-ITIFeaturesyouselectedarebeinginstalled.J□]PleasftwaitwhiletheInstallationWizardinstallsApacheHTTPServerZ.Ξ,15.Thismaytakeseveralminutes.5t□tus:InstaIl5hieId<Back.Cancel开始安装。单击“Finish”。Mysql的安装:运行mysql-essential-5.1.48-win32,界面如下：IySQLServer5.1-SetupTizardXWelcometothsSetupWizardforMySQL

Server5.1TheSetupWizardwillinstallM∕5QLServer5.1release5.1.46

onyourcomputer.TcIc□ntiπuejclick.Next.WARNING:Thisprogrami≡protectedbγcopyright值仲,E 逅jjf、…….j∣ CancelSetupTypeChoosethesetuptypethatbestsuitsyourneeds.Pleaseselectasetuptype.OTypicalUCommonprogramFeaturesMIlbeinstalled.R.ecommendedForgeneraluse.■\CompleteAllprogramfeatures刚beinstalled.(Requiresthemostdiskspace.)@fcu5tom：∣∙-√ιΞehɔosewhichprogramfeaturesyouwantinstalled∙aπdwherethey囿illbeinstalled.Recommendedforadvancedusers.MRmik-1[ 旦E壮[ 匚.Γ∣【吟ITypical”为默认安装，“Complete”为完全安装，“Custom为用户自定义安装。选择“Custom”，单击“Next”IySQLServer5.1-SetupVizard.CustomSetupSelecttheprogramfeaturesyouwantinstalled.XClickonaniconinthelistbelowtochangehowafeatureisinstalled.EΓ∙m，IMV三QL三日%它rOlIrllMySQLServerD-at-afilesClientPrograms[匚IncludeFilesfLibFilesFeatureE⅛≤criρtioπInstallstheC-Headerfilesandnecessarylib-filesfordevelopingCjC++applicationsthatc□rr∣muπic-c∣tewithaThiξfeatɔɪewiLlbeiτι≡t=alledOn1oeaɪhardɪit-ive.∣^□Thi≡ieatɪs,.=u~ιdill≡ubfeatιJj'e≡.lwillbeir∣≡1a=dal⅞d。口工如:：式h：Hda±'ivs.@Tkfeaturewillbein≡t⅞llsdYrhEnrequited.InstallIcXThiξteat∏ιrewiLlnotIj已available.Change...HelpNext>Cancel单击“CIncludeFiles/LibFiles”，选择“Thisfeaturewillbeinstalledonlocaldirve.单击“Change..”。单击“Next”。IySQLServer5.1-SetupTizard×ReadytoInstallth«ProgramThewizardisreadytobegininstallation.Ifyouwanttorevieworchangeanyofyouriπstal⅛tic∣πsettiπgsjclickBack.ClickCanceIto

exitthewizard.CurrentSettings;5etupType:CustomDe5tiπatiαπFolder;E：W5QL\DataFolder;C:∖Dc∣cun∩eπtsandSettiπgs∖AllUsers\AppIicationData∖Mγ5QL∖M∕5QLServer5,1^^kg.创j∣I 匚.Γ∣⅛∣单击“Install”。InstallingMySQLServer5.1ThePrclgraITIFeaturesyouselectedarebeinginstalled.J0]PleasftwaitwhiletheSetupW⅛ardinstallsMySQLServer5.1.Thismaytak⅛f√Tseveralminutes.5⅛tU5:<BackIlNeκt>Cancel开始安装。JySQLEnteτpri≡eAMySQLEfiterprisesubsCfEptforiFstheE(ME

coπ∩pre⅛&ns⅛eof⅛rtπgofMySQLdatabase

software,Servlces,and5iιρρorttoensureyotιr

businessachievesthehfg⅛e5fIeveIsOfrellabilityr

5ecurtτy,anduptime-.AnEnterprise5ubscrlipdαπIncludes1,TheMySQLEntorprls∣qServer-Tfiemɑsifeliable,secure,≡∏dup-to-dateVPTHOnofthewortd⅛mostpopulιropensourcedatabjs⅛2÷MySQLEnterpriseMonitorServke-Anautomatedvlπu⅛ld⅛tabaseaiss⅛taπt.3∏MySOLProduction5upport-TechnicalandconsultativesupportwhenyouneedmHCngw3thservlcepacks,hot-tes,andmorelMore...[More.u]orv-⅛ltwww.π∩ysq/en⅛rprlse.<Back JeX1? Cancel单击“Next”。KySQI.Enterpri≡eXTheMySQLEnterpriseMonitorService-Quick⅛identifiesyourmostexpensiveSQLcodeacrossaEFyoursevere.■MySQLAdv⅛ɔrsand125+

BesiPracticeRulesensure

5.ecur⅛yandp⅛ri⅛>m‰aιπ七二.-AlertsantfE¾pertAdviceonhswtc∙ħxρrob⅛nns⅛ndtuneforpeakpeFfomance.Ilck[Mq⅛;.]orvisitVVWWmy5矶£口m∕eπterpriseMore...<BackNext>Cancel单击“Next”。My5Server5.1-SetupTizardWizardCompleted5etuphasΓinishedinstallingMy5QLServer5,1,ClickFinishtoexitthewizard.0ConfiguretheMV弓QL5ervernowUsethis□ρti∣Ξ∣ntugenerateanOptirriizedM∕5QL匚口r∣Figfile.,eetupal>⅛liπd∩i'l'∣sberι√i∣zerunningonadedicatedportandtosettheρass∣Λ∣L∣rdFortheror∣t印h□li口匕FinishCancel选择“ConfiguretheMySQLServernow"，单击“Finish”。IySQLServerInstanceConfigurationTizardXWelcometotheMySQLServerInstanceConfigurationWizardTheConHgurationWizardwillallowycutocoπNgurethe

M⅛∕5QL5erver5.1serverinstance.ToContinuejclick

Neκt,MySQL；^Next'>^Cancel单击“Next”。IySQLServerInstanceConfigurationTizardXMySQLServerI∏ft-anceConfigurationCunFiguretheMySQLServerS.1serverinstance.Pleaseselectaconfigurationtype.DetailedConfigurationChoosethisConFigurationtypetocreatetheoptimalserversetupFor

thismachine.StandardConfigurationL、；UsethisonlyCInmachinesthatdonotalreadyhaveaMySQLserverJinstallation.Thiswilluseageneralpurposeconfigurationfortheserverthatcanbetunedmanually.<BackjNj戢F5 [ICancel选择配置方式："DetailedConfiguration（手动精确配置）"、"StandardConfiguration（标准配置）"，选择“DetailedConfiguration^,单击“Next”。选择服务器类型，"DeveloperMachine（开发测试类，mysql占用很少资源）"、“ServerMachine（服务器类型，mysql占用较多资源）"、“DedicatedMySQLServerMachine（专门的数据库服务器，mysql占用所有可用资源）”,通常选择“ServerMaChine”。单击“Next”。IySQLServerIn≡tonceConfigurationTizard ×MySQLServerI∏5t-anceConfigurationConfiguretheMySQLServer5.1serverinstance.Pleaseselectthedatabaseusage.MultiΓuncti□nalDatabase§Generalpurposedatabases.This付illoptimizetheserverFortheuse

ofthefasttransactionalInnoDBstorageengineandthehighspeed

Γvl⅛,I5ΛΓvlstorageengine,（*≡transacti□naiDatabaseOnly!Optimized⅛rapplicationserversandtransactionalv∖ιebapplications.

ThiswillmakeI∏∏□DE∣themainstorageengine.Notethatthe■.ʃNy[5ΛMenginecanstillbeused.Non-TransactionalDatabaseOnlySuitedforsimplewebapplic□tio∏5jrπoπitc∣riπgorloggingapplications

aswellasanalysisprograms.Orlythenor-traπ≡acti□nalMFIW口M

storageengine同illbeactivated.<BackIP⅛t:ICancel选择mysql数据库的大致用途，“MultifunctionalDatabase（通

用多功能型，好）"、“TransactionalDatabaseOnly（服务器类

型，专注于事务处理，通常）”、“Non-TransaCtionalDatabase

Only（非事务处理型，较简单，要紧做一些监控，记数用，

对MySAM数据类型的支持仅限于non-transactional）"，选择

“TransactionalDatabaseOnly”，单击“Next”。对InnoDBTablespace进行配置，就是为InnoDB数据库文件选择一个存储空间，假如修改了，要记住位置，重装的时候要选择一样的地方，否则可能会造成数据库损坏，当然，对数据库做个备份就没问题了。使用默认位置，单击“Next”。选择网站的一半mysql访问量，同时连接的数目，“DecisionSUPPort(DSS)/OLAP(20个左右)”、“OnlineTransactionPrOCessing(OLTP)(500个左右)”、“ManualSetting(手动设置，自己输一个数)"，选择“OnlineTransactionPrOCessing(OLTP)”，单击“Next”。IySQLServerInstanceConfigurationTizardXMySQLServerI∏5t-anceConfigurationConfiguretheMySQLServer5.1serverinstance.Pleasesetthenetworkingoptions.[√EnableTCP/IPNetworkingEnablethistoallowTCP/IPconnections.Whendisabledjonlylocal

connectionsthroughnamedpipesareallowed.PortNumber;306▼I*Addfirewall已工匚已pUdnforthisportPleasesettheserver5QLmode.“EnableStrictModeThisoptionForcestheservertobehavemorelikeatraditionaldatabaseserver.Itisrecommendedtoenablethisoption.<BackNext>Cancel是否启用TCP/IP连接，设定端口,假如不启用，就只能在自己的机器上访问mysql数据库，选择“EnableTCP/IPNetWOrking"，单击"Next”。设置数据库语言编码，"StandardCharacterSeJ为西文编码、“BestSupportForMultilingualism为RTF-8编码、“ManualSelectedDefaultCharacterSet∕Collation^为手动设置编码，gbk、gb2312为中文编码，选择"BestSupportForMultilingualism单击“Next”。选择"IncludeBinDirectoryinWindowsPATH”，单击“Next”。选择"ModifySecuritySettingS”（重装MySQL是不选），填两次密码，选上“Enablerootaccessfromremotemachines”以便能够从其他机器上访问。单击“Next”。IySQLServerInstanceConfigurationVizard XMySQLServerI∏ft-anceConfigurationConF