Home php教程 php手册 windows下Apache2+php4+MySql5集成简明教程

windows下Apache2+php4+MySql5集成简明教程

Jun 21, 2016 am 09:11 AM
apache mysql nbsp php phpmyadmin

apache|mysql|window|教程

一、软件下载 1.到www.apache.org下载Apache2的安装文件参考链接:http://mirror.apache.or.kr/httpd/binaries/win32/apache_2.0.55-win32-x86-no_ssl.exe 2.到www.php.net下载php4的zip包参考链接:http://www.php.net/get/php-4.4.2-Win32.zip/from/a/mirror说明:(1)php5已经比较稳定了,但是由于有很多php应用与php5兼容不够好,所以php4是一个比较好的选择。(2)php4有windows下的exe安装文件,但那个版本是一个微缩版,不够全,所以建议下载zip包,但需要手工安装。 3.到www.mysql.com下载MySql5参考链接:http://dev.mysql.com/downloads/mysql/5.0.html 4.下载PhpMyAdmin,用于操作MySql参考链接:http://count.skycn.com/softdownload.php?id=10687&url=http://gztt.driversky.com/down/phpMyAdmin-2.7.0.zip 二、安装配置 1. Apache和MySql的安装比较简单,跟一般windows程序安装没有多大区别,按照默认选项一步往下走即可,需要注意的一点是,最好把安装路径修改一下,不要太长,也不要有空格。比如安装Apache时选择d:\,这样安装后的Root是d:\Apache2。
MySql的安装路径可以写d:\mysql50;安装好了以后,进入d:\mysql50\bin,运行mysqld-nt --install将MySQL安装为系统服务。(mysqld-nt --remove是卸载服务) 安装好Apache2后,打开d:\Apache2\conf\httpd.conf,查找LoadModule,在所有LoadModule语句之后加入#sss added  (这句是注释)
LoadModule php4_module "d:/php4/php4apache2.dll"
AddType application/x-httpd-php .php
PHPIniDir "d:/php4"然后保存退出。 2.至于php: (1)解压zip包到d:\php4,然后把dlls和sapi目录中的dll都拷贝出来放到其父目录,即d:\php4下。 (2)把php.ini-dist(php默认设置)或者php.ini-recommended(php推荐设置)复制到\windows目录下(有的是winnt,视系统安装而定),然后改名为php.ini。 (3)把php4ts.dll复制到\windows\system32目录下。 (4)在环境变量中,把d\:php4加入系统变量的Path。(加在尾部,前面用分号隔开) 3.将PhpMyAdmin解压到d:\Apache2\htdocs\phpmyadmin。 四、运行服务 1.运行MySql:键入net start mysql即可(net stop mysql是停止服务) 2.运行Apache:点击开始菜单->程序->Apache HTTP Server 2.0.55->Control Apache Server->Monitor Apache Servers,会在任务栏右下角出现一个红色羽毛图标,点击右键Open Apache Monitor,然后点击start按钮,如果有配置不正确,会有弹出窗口提示错误。否则会在窗口左下区域看到The Apache2 server is starting字样。 五、测试效果 1.打开浏览器,输入http://localhost,正常会看到一个默认主页。 2.输入http://localhost/phpMyAdmin/index.php,正常会看到phpMyAdmin的主页。 注:如果端口号不是默认的80,而是8080,需要将localhost修改为localhost:8080。 六、写给新手     安装和配置甚至使用的步骤,往往在软件的文档中都已经写的很详细,虽然都是英文,但并不难懂,抓住关键词汇即可。我认为下载完一个好的习惯是首先阅读faq、readme、install等文档,然后再进行下一步。     如果软件的文档不够详细,可以到其官方网站,找相关技术论坛。国内也有很多很好的论坛,但学会阅读英文资料,我想对自己提高技术水平很有帮助。
补充:原来在Windows sp1下安装没有问题,SP2中启动mysql时发现一个1067代号的错误,解决办法如下:
在c:\windows下建立一个my.ini。输入以下内容:
[mysqld]
# set basedir to installation path, e.g., c:/mysql
basedir=D:/MySQL50

# set datadir to location of data directory,
datadir=D:/MySQL50/data

[WinMySQLadmin]
Server=D:/MySQL50/bin/mysqld-nt.exe
user=root
password=
保存退出。然后再运行服务,应该没有问题了。



Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Roblox: Bubble Gum Simulator Infinity - How To Get And Use Royal Keys
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Nordhold: Fusion System, Explained
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Mandragora: Whispers Of The Witch Tree - How To Unlock The Grappling Hook
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Hot Topics

Java Tutorial
1665
14
PHP Tutorial
1269
29
C# Tutorial
1249
24
MySQL: The Database, phpMyAdmin: The Management Interface MySQL: The Database, phpMyAdmin: The Management Interface Apr 29, 2025 am 12:44 AM

MySQL and phpMyAdmin can be effectively managed through the following steps: 1. Create and delete database: Just click in phpMyAdmin to complete. 2. Manage tables: You can create tables, modify structures, and add indexes. 3. Data operation: Supports inserting, updating, deleting data and executing SQL queries. 4. Import and export data: Supports SQL, CSV, XML and other formats. 5. Optimization and monitoring: Use the OPTIMIZETABLE command to optimize tables and use query analyzers and monitoring tools to solve performance problems.

Composer: Aiding PHP Development Through AI Composer: Aiding PHP Development Through AI Apr 29, 2025 am 12:27 AM

AI can help optimize the use of Composer. Specific methods include: 1. Dependency management optimization: AI analyzes dependencies, recommends the best version combination, and reduces conflicts. 2. Automated code generation: AI generates composer.json files that conform to best practices. 3. Improve code quality: AI detects potential problems, provides optimization suggestions, and improves code quality. These methods are implemented through machine learning and natural language processing technologies to help developers improve efficiency and code quality.

How to uninstall MySQL and clean residual files How to uninstall MySQL and clean residual files Apr 29, 2025 pm 04:03 PM

To safely and thoroughly uninstall MySQL and clean all residual files, follow the following steps: 1. Stop MySQL service; 2. Uninstall MySQL packages; 3. Clean configuration files and data directories; 4. Verify that the uninstallation is thorough.

What is the significance of the session_start() function? What is the significance of the session_start() function? May 03, 2025 am 12:18 AM

session_start()iscrucialinPHPformanagingusersessions.1)Itinitiatesanewsessionifnoneexists,2)resumesanexistingsession,and3)setsasessioncookieforcontinuityacrossrequests,enablingapplicationslikeuserauthenticationandpersonalizedcontent.

Steps to add and delete fields to MySQL tables Steps to add and delete fields to MySQL tables Apr 29, 2025 pm 04:15 PM

In MySQL, add fields using ALTERTABLEtable_nameADDCOLUMNnew_columnVARCHAR(255)AFTERexisting_column, delete fields using ALTERTABLEtable_nameDROPCOLUMNcolumn_to_drop. When adding fields, you need to specify a location to optimize query performance and data structure; before deleting fields, you need to confirm that the operation is irreversible; modifying table structure using online DDL, backup data, test environment, and low-load time periods is performance optimization and best practice.

An efficient way to batch insert data in MySQL An efficient way to batch insert data in MySQL Apr 29, 2025 pm 04:18 PM

Efficient methods for batch inserting data in MySQL include: 1. Using INSERTINTO...VALUES syntax, 2. Using LOADDATAINFILE command, 3. Using transaction processing, 4. Adjust batch size, 5. Disable indexing, 6. Using INSERTIGNORE or INSERT...ONDUPLICATEKEYUPDATE, these methods can significantly improve database operation efficiency.

How to use MySQL functions for data processing and calculation How to use MySQL functions for data processing and calculation Apr 29, 2025 pm 04:21 PM

MySQL functions can be used for data processing and calculation. 1. Basic usage includes string processing, date calculation and mathematical operations. 2. Advanced usage involves combining multiple functions to implement complex operations. 3. Performance optimization requires avoiding the use of functions in the WHERE clause and using GROUPBY and temporary tables.

How to configure the character set and collation rules of MySQL How to configure the character set and collation rules of MySQL Apr 29, 2025 pm 04:06 PM

Methods for configuring character sets and collations in MySQL include: 1. Setting the character sets and collations at the server level: SETNAMES'utf8'; SETCHARACTERSETutf8; SETCOLLATION_CONNECTION='utf8_general_ci'; 2. Create a database that uses specific character sets and collations: CREATEDATABASEexample_dbCHARACTERSETutf8COLLATEutf8_general_ci; 3. Specify character sets and collations when creating a table: CREATETABLEexample_table(idINT

See all articles