windows下Apache2+php4+MySql5集成简明教程
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=
保存退出。然后再运行服务,应该没有问题了。

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics



PHP and Python each have their own advantages, and the choice should be based on project requirements. 1.PHP is suitable for web development, with simple syntax and high execution efficiency. 2. Python is suitable for data science and machine learning, with concise syntax and rich libraries.

MySQL is an open source relational database management system. 1) Create database and tables: Use the CREATEDATABASE and CREATETABLE commands. 2) Basic operations: INSERT, UPDATE, DELETE and SELECT. 3) Advanced operations: JOIN, subquery and transaction processing. 4) Debugging skills: Check syntax, data type and permissions. 5) Optimization suggestions: Use indexes, avoid SELECT* and use transactions.

不同数据库系统添加列的语法为:MySQL:ALTER TABLE table_name ADD column_name data_type;PostgreSQL:ALTER TABLE table_name ADD COLUMN column_name data_type;Oracle:ALTER TABLE table_name ADD (column_name data_type);SQL Server:ALTER TABLE table_name ADD column_name data_

The future of PHP will be achieved by adapting to new technology trends and introducing innovative features: 1) Adapting to cloud computing, containerization and microservice architectures, supporting Docker and Kubernetes; 2) introducing JIT compilers and enumeration types to improve performance and data processing efficiency; 3) Continuously optimize performance and promote best practices.

MySQL and SQL are essential skills for developers. 1.MySQL is an open source relational database management system, and SQL is the standard language used to manage and operate databases. 2.MySQL supports multiple storage engines through efficient data storage and retrieval functions, and SQL completes complex data operations through simple statements. 3. Examples of usage include basic queries and advanced queries, such as filtering and sorting by condition. 4. Common errors include syntax errors and performance issues, which can be optimized by checking SQL statements and using EXPLAIN commands. 5. Performance optimization techniques include using indexes, avoiding full table scanning, optimizing JOIN operations and improving code readability.

Building an SQL database involves 10 steps: selecting DBMS; installing DBMS; creating a database; creating a table; inserting data; retrieving data; updating data; deleting data; managing users; backing up the database.

PHP is not dying, but constantly adapting and evolving. 1) PHP has undergone multiple version iterations since 1994 to adapt to new technology trends. 2) It is currently widely used in e-commerce, content management systems and other fields. 3) PHP8 introduces JIT compiler and other functions to improve performance and modernization. 4) Use OPcache and follow PSR-12 standards to optimize performance and code quality.

SQL (Structured Query Language) is a programming language used to create, manage, and query databases. The main functions include: creating databases and tables, inserting, updating and deleting data, sorting and filtering results, aggregating functions, joining tables, subqueries, operators, functions, keywords, data manipulation/definition/control language, connection types, query optimization, security, tools, resources, versions, common errors, debugging techniques, best practices, trends and row locking.
