Shulou(Shulou.com)06/03 Report--

WAMP

Apache+Mysql/MariaDB+Perl/PHP/Python under Windows, a group of open source software commonly used to build dynamic websites or servers, are independent programs themselves, but because they are often used together, they have a higher and higher degree of compatibility and form a powerful Web application platform.

The software used in this construction is: Apache24 + mysql 5.6 + php-5.6 + phpMyadmin Apache download link address: https://www.apachehaus.com/cgi-bin/download.plx mysql download link address: https://downloads.mysql.com/archives/community/ php download link address: https://windows.php.net/download phpMyadmin download link address Https://www.phpmyadmin.net/downloads/

Note: the previous installation steps, the subsequent addition of the problems in the installation process and the solutions.

Installation

Apache installation:

Apache HTTP Server is an open source web server of the Apache Software Foundation, which can run in most computer operating systems. Because of its wide use of multiple platforms and security, Web is one of the most popular server-side software. It is fast, reliable and can compile interpreters such as Perl/Python into the server through a simple API extension. First, download

Download address: http://www.apachehaus.com/cgi-bin/download.plx

II. Configuration

2.1 download the package of the zip suffix, extract it, and put the custom name in the corresponding location. I am in the D root directory of the server, named: Apache, that is, D:\ Apache\, which contains bin, conf, htdocs, lib and other directories and files

2.2 configure the environment variable and add:; D:\ Apache\ bin at the end of the system variable path (note that it is appended, not overwritten)

2.3 configure httpd.conf

Edit the contents of the conf/httpd.conf file in the root program directory:

Define SRVROOT "d:\ Apache24"

Modify to

Define ServerRoot "d:\ Apache"

Options FollowSymLinks

AllowOverride None

Order deny,allow

Allow from all

Note: I simply change two of them. In the production environment, we need to adjust the configuration file according to the actual situation.

III. Installation

Run as administrator to start-run-enter cmd. After entering the DOS window, first change to the program directory of Apache:

C:\ Users\ Administrator > d:

D:\ > cd Apache\ bin

D:\ Apache\ bin > httpd-k install

D:\ Apache\ bin > httpd-k start

Other Command line options:

Stop Apache httpd-k stop

Restart Apache httpd-k restart

Uninstall Apache Service httpd-k uninstall

Test Config Syntax httpd-t

Version Details httpd-V

Command Line Options List httpd-h

IV. Verification

Open the browser and enter: http://localhost/ in the address bar. If you can open the website information normally, it means that it has been successfully deployed.

Reference link: https://blog.51cto.com/westkk/1884740

PHP installation:

First, download

Download address: https://windows.php.net/download

II. Installation

2.1Unpack the PHP and copy it to the installation location. I chose d:/php-5.6 (php-5.6.36-nts-Win32-VC11-x64 has the same name). Then copy and rename the php.ini-development to php.ini, or if you are deploying, copy php.ini-production. 2.2 Edit Apache's httpd.conf to find LoadModule, and add the following configuration after it. If your PHP is on disk C, please change D: to CLoadModule, and pay attention to the path use /. LoadModule php5_module D:/php-5.6/php5apache2_4.dll # without php5apache2_4.dll is downloaded from the wrong version of php. Https://windows.php.net/download downloads PHPIniDir D:/php-5.6 to find AddType on this link and adds the following configuration: AddType application/x-httpd-php .php to find DirectoryIndex Join index.php, and if you want index.php to take precedence over index.html, put it first. DirectoryIndex index.html index.php saves the configuration, runs httpd.exe-t on the command line to check the configuration, and if there is no problem, run httpd.exe-k restart to restart the Apache service. 2.3 create a new phpinfo.php file in the Apache\ htdocs directory and enter the following PHP code: then access http://127.0.0.1/phpinfo.php in the browser; the following interface indicates that the installation is successful.

Reference link: https://www.cnblogs.com/freefalcon/p/3888459.html

MYSQL installation

First, download

Official download address of mysql server: https://downloads.mysql.com/archives/community/

II. Installation

2.1Modify the configuration file, copy the my-default.ini in the installation directory and change it to my.ini. Open the my.ini file to configure basedir and datadir. Take my directory as an example: basedir = C:\ mysql-5.6 datadir = C:\ mysql-5.62.2 run the cmd command as an administrator, and enter the bin layer of the installation directory: cd C:\ mysql-5.6

After entering, run: mysqld-install, and then run: net start mysql start the service after the command is successful.

Login: cmd enters the bin layer of the installation directory and runs mysql-u root-p to prompt you to enter the password and log in successfully again (after the initial installation, the root user password is empty).

Change the root password

Run the cmd command as an administrator and enter the bin tier cd C:\ mysql-5.6 of the installation directory

Run after entering: mysqladmin-uroot-p password redhat

Enter because the current password is empty

Set the new password (redhat) successfully! Use redhat to log in to the database later!

PhpMyadmin installation

First, download

Download link address: https://www.phpmyadmin.net/downloads/

II. Installation

2.1 put the extracted phpmyadmin in an accessible web directory (if it is a virtual space, you can unzip it and upload it to the web directory via ftp, etc.). Of course, you can modify the name of the extracted file.

2.2 configure config File Open the config.default.php file under libraries, find the following items in turn, and follow the instructions to configure: a. Access URL reference: $cfg ['PmaAbsoluteUri'] =''; here fill in the access URL of phpmyadmin, for example: $cfg ['PmaAbsoluteUri'] =' / / localhost/phpmyadmin'; B.mysql host information reference: $cfg ['Servers'] [$I] [' host'] = 'localhost' / / MySQL hostname or IPaddress enter the ip address of the server where the localhost or mysql resides. If the mysql and the phpmyadmin are on the same server, press the default localhost $cfg ['Servers'] [$I] [' port'] ='' / / MySQL port-leave blank fordefault port mysql port. If the default is 3306, leave it blank for C.mysql username and password reference: $cfg ['Servers'] [$I] [' user'] = 'root'; / / MySQL user to access the mysql username used by phpmyadmin fg [' Servers'] [$I] ['password'] ='' / / MySQL password (onlyneeded corresponds to the password of the above mysql user name D. Reference to authentication method: $cfg ['Servers'] [$I] [' auth_type'] = 'http'; has four modes to choose from here. In cookie,http,HTTP,config config mode, you can enter the URL of phpmyadmin directly without entering a user name and password. It is not safe and is not recommended. When this item is set to cookie,http or HTTP, login to phpmyadmin requires data username and password for authentication, as follows: PHP installation mode is Apache, you can use http and cookie; PHP installation mode to CGI, and you can use cookie E. Reference to the setting of the phrase password (blowfish_secret): $cfg ['blowfish_secret'] =''; if the authentication method is set to cookie, you need to set the phrase password, which is up to you to decide why to set the password, but you cannot leave it blank, otherwise you will be prompted with an error when logging in to phpmyadmin. All right, you have successfully installed phpmyadmin.

Reference link: https://blog.csdn.net/weixin_38312383/article/details/79244200

At this point, the installation of apache + mysql + php + phpmyadmin is complete. When the browser accesses http://localhost/phpmyadmin, the following interface indicates a successful completion.

Problems and solutions:

1. Problem: installing apache under windows 2008 to execute D:\ Apache\ bin > httpd-k install appears "cannot start this program because VCRUNTIME140.dll is missing from the computer".

Solution: download vc++2015 and install it; link: https://www.microsoft.com/zh-cn/download/confirmation.aspx?id=48145

2. Problem: after installing php under windows 2008 and configuring LoadModule php5_module D:/php-5.5.15/php5apache2_4.dll, the cmd interface httpd.exe-t checks syntax errors and "syntax error cannot load php5apache2_4.dll" appears.

Solution: cause of error: the VC11 runtime is missing on the computer, because all 5.6environments are generated under vc11-based compilation scripts, and the related component msvcr110.dll needs to be installed.

Two 64-bit versions of the runtime are shared here, one is VC2012, one is VC2015 for PHP5.6;, and the other is PHP7. It is recommended that no matter which version of PHP is installed, install both! After VC2015-> http://pan.baidu.com/s/1gfIaLgR VC2012-> http://pan.baidu.com/s/1pKXJrVd installation is complete, restart apache!

3. Problem: install phpmyadmin, and the "missing mysqli" extension appears when accessing through the browser. Please check the PHP configuration information. Refer to this link file: http://www.jb51.net/article/36459.htm

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.