Apache + PHP + Mysql configuration instructions: The favorites are all solutions for installing packages

Source: Internet
Author: User
Tags web hosting
Apache + PHP + Mysql configuration instructions: My favorites are all about solution package security in the previous web application, Apache + PHP + Mysql, is a kind of WEB server architecture that is widely used, especially in the source-free application. there are two options for installing this architecture: 1. using integrated tools, there are a lot of tools in this area, recommended XAMPP, Web site: http://www.apachefriend Apache + PHP + Mysql configuration said their favorite is solution package security
In the previous WEB application, Apache + PHP + Mysql is a WEB server architecture that is widely used, this feature is available for source-free access.


There are two options for installing this architecture,
1. using integrated tools, there are a lot of tools on the Internet, XAMPP is recommended, web: http://www.apachefriends.org/zh_cn/xampp-windows.html
In this way, the user does not need to know the specific design and adjustment methods of the above three types of component, which makes it easy to install, however, there are still some problems in the application architectures of different types.
2. self-mounting. you need to adjust the configurations of each component by yourself. after understanding the settings, it will help you manage the application of the website, in this case, the volume must be upgraded or updated for the server component. if you really want to learn how to use Apache + php + MYsql, we recommend this method. in fact, according to the guidance provided by many veterans on the Internet, it is necessary to master security.
The following is a tutorial by Freddy zookeeper, which is concise and easy to use.
Root accounts should use the process and add some samples (in fact, there are not too many samples) for interesting colleagues to take the test.



Customized Windows 2000/XP/2003 + Apache 2.2.4 + PHP 5.2.0 + MySQL 5.0.27 + Zend Optimizer 3.2.0 runtime configuration instructions


Powered by Freddy
In this article, the combined audience: developers who need to develop local programs, templates, plug-ins, and various types of learners.
This article describes how to configure PHP, Mysql, and Apache in different Windows systems. (Similar to Windows 2000 and Windows 2003 server)
This section describes the license parts used.
· Apache 2.2.4 -- www.apache.org
· PHP 5.2.0 -- www.php.net
· MySQL 5.0.27 -- www.mysql.com
· Zend Optimizer 3.2.0 -- www.zend.com
· PhpMyAdmin 2.9.2 -- www.phpmyadmin.net
· Important note: Before performing the following operations, Windows XP should not install IIS, PHP, APACHE, MYSQL, and ZEND.


I prefer the following:
Unnamed 2.JPG (22.75 KB)




Installing Apache 2.2.4

1. open my computer, enter D branch, and create a file named local under it.
2. go to the official site under the apache_2.2.4-win32-x86-no_ssl.msi.
3. the security program requires that your Network Domain (website Domain name), ServerDomain (server Domain name), and website administrator's E-mail be imported according to the Next statement three times, some of them are just like filling in the example. This article describes the local self-built environment, so just click here, fill in the localhost for the first two, and upload your own copy.
4. after entering Next, the default security path is "C:/program FilesApache Software FoundationApache2.2". change the path to "D: localApache2" as described earlier ".
5. continue until the end of the server guard. at this time, open the local file under D branch and you will see a file named Apache2.
6. open IE, and then enter "http: // localhost" or "http: // 127.0.0.1" in the response address to the success of Apache Security; the location of the subsequent website is in "D:/local/Apache2/htdocs.
7. generally, it is set according to the web port 80. if you need to complete the configuration, you can manually complete httpd after the security protection is complete. conf file. Note that a total of two parts are required.
8. add one point: check the settings of the XP fire prevention system and open the port used by the WEB server (usually port 80 will be used when we use SKYPE, if the WEB hosting uses port 8080, you need to configure the port in the XP fireproof firewall)




Alibaba PHP 5.2.0 security protection
1. to the official site under the php-5.2.0-Win32.zip solution (here do not download and use its Installer, this method is very self-dynamic, very intelligent, but there are also many restrictions, because we don't recommend them .)
2. decompress the php file to a project. the Project address is "D: localphp ".
3. set PHP under php (D: localphp. ini-dist was downloaded to windows (some systems are winnt targets) and renamed php. ini.
4. Upload mongod: all dll files under the localphp project to the windows system file zookeeper, that is, C: \ windows \ system32. (Note that there is a file under Windows 2003 server that will be re-uploaded, and Windows self-contained images are new and can be used without overwriting)


Installing MySQL 5.0.27
1. open my computer, enter D: local, and create a new file named mysql.
2. click Mysql 5.0.27 Installer under the official site.
3. press Next and then select Custom security mode.
4. click Change to Change the security path. the original path is "C: \ program Files \ MySQL Server 5.0", which is changed to "D: localmysql ".
5. when the security condition is loaded, a Sign Up direction appears. this parameter is not necessary. select the Skip Sign-Up at the bottom of the parameter, next, there is a "Configure the MySQL Server now" on it, which is checked. do not remove it. click Finish directly.
6. now start the last Configuration of the Server guard, click Next, select Detailed Configuration, and then select the second Server Machine.
7. Next, select Non-Transactional Database Only.
8. Next, choose Manual Setting. the number of connections is 200 to 300. this is because the local machine is used, so this operation is not important.
9. Next, set the port to 3306. do not touch it.
10. Next, select Manual Selected Default Character Set/Collation, and select gbk in the Character Set below. (Pay attention to the use of the internal scripts after the root scripts to select the correct ones. after installing the internal scripts, run the scripts in MySQL. ini can be changed, but there is a lot of trouble) (note. because we often need to use UTF8 for traditional users, we recommend that UTF8 be used for all internal platforms, here, changing the MYSQL internal configuration to UTF8 will be convenient for later use)
11. Next, check before Include Bin Directory in Windows PATH.
12. Next, cancel the check before Modify Security Settings, because it is a local environment, a non-server and a dedicated host.
13. add Execute to the last Next step. you can see that all the above steps are completed.
14. MySQL has the following metadata: root, and the password is empty. (It is suggested that the website should be a good example, and the website volume should be encrypted)
15. when using MySQL, Win + R of zookeeper, export the transportation line dialog box, enter cmd, return to the car, enter the command prompt, and then enter: "mysql-uroot-p", after the car is returned, the password should be entered. because the password is empty, you can simply press the car back. Now you can see the following success prompt:
Welcome to the MySQL monitor. Commands end with; or g.
Your MySQL connection id is 1 to server version: 5.0.27-community-nt
Type 'help; 'or 'H' for help. Type 'C' to clear the buffer.
It indicates that all the hosts are successfully installed.
16. the operator is changed to "mysql>", and you can exit after exiting.


Installing zookeeper for Zend Optimizer 3.2.0
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.