


Apache php Mysql deployment (1) download and installation, apachemysql_PHP tutorial
Apache php Mysql deployment (1) download and installation, apachemysql
Foreword
Recently, the company needs to develop a website, but it has special requirements: it cannot use Java and can only be deployed on the Windows platform. There is no other way but to choose the Apache php Mysql solution.
I don’t know if there is anything better. Golang is quite good, but our project has been started for nearly 3 months and there are only two people working on it, so it is quite slow (⊙﹏⊙)b
Okay, before we develop, we first need to have a development environment. At the beginning, I chose the xammp synthesis package https://www.apachefriends.org/zh_cn/index.html. This installation package is very Simple, just click install and you can use it after the installation is completed.
But what I need is my own installation package, and I need to clearly understand the configuration.
Server composition
1. Apache: http://www.apachelounge.com/download/VC11/
2. PHP: http://windows.php.net/download#php-5.6-ts-VC11-x86
3. Mysql: http://dev.mysql.com/downloads/windows/installer/5.7.html
Apache installation
step1: Open the Apache download address mentioned above, find httpd-2.4.20-win32-VC11.zip, click to download, the latest The version is: Apache 2.4.20. Since the Apache we downloaded is compiled by visual studio 2012 (VC11), the corresponding vs running environment is required. If the corresponding operating environment has not been installed, you can find vcredist_x64/86.exe on this webpage, click to download and install it. There is also this version of the application module modules-2.4-win32-VC11.zip on this page, which can be downloaded if necessary. For module addition, please refer to the corresponding module addition instructions.
step2: Create a My Server folder on the C drive (you can name it whatever you want), and extract the Apache installation package to this directory. Name Apache24 Apache (for convenience of future version upgrades and replacements)
step3: Apache is now installed, but it cannot be started yet. It needs to be configured to start. The configuration will be discussed later.
PHP installation
step1: Open the php download page above and select the zip downloaded by VC11 x86 Thread Safe (2016-Jun-22 21:49:59): php-5.6.23-Win32-VC11-x86.zip, because our Apache selects 32-bit VC11, so php also selects the corresponding version.
step2: Extract the installation package to C:My Serverphp, as shown in the figure:
step1: Open the mysql download page, select Windows (x86, 32-bit), MSI Installer, and click mysql-installer-community-5.7. 13.0.msi, download.
step2: Click the exe to install, you only need to modify one configuration, and use the default installation for the others, as shown in the figure:
step3: The installation is complete. Use services.msc to open the service window. You can see the MySQL57 service, indicating that the installation is successful, and then stop the service.
step4: Copy the folder C:ProgramDataMySQLMySQL Server 5.7 to C:My Server and rename it to MySQL_Data . (data folder of database)
step5: Copy the folder C:Program Files (x86)MySQLMySQL Server 5.7 to C:My Server and rename it to MySQL. (mysql installation path)
step6: Copy my.ini in C:My ServerMySQL_Data to C:My ServerMySQL Table of contents
step7: Open my.ini for editing, add default-character-set=utf8 in the [client] item; find datadir in [mysqld] and modify its value to: "C:/My Server/MySQL_Data/Data",i.e.datadir="C:/My Server/MySQL_Data/Data"
Also modify secure-file-priv to secure-file-priv="C:/My Server/MySQL_Data/Uploads"
step8: Create a text document in the folder C:My ServerMySQL, and then rename it to mysql install.bat, Open editing with text and insert the following:
<span>"</span><span>%~dp0\bin\mysqld.exe</span><span>"</span> --<span>install</span><span> reg add HKLM\SYSTEM\CurrentControlSet\services\MYSQL </span>/v DisplayName /t REG_SZ /d MYSQL /<span>f reg add HKLM\SYSTEM\CurrentControlSet\services\MYSQL </span>/v Description /t REG_SZ /d <span>"</span><span>mysql database service register</span><span>"</span> /<span>f reg add HKLM\SYSTEM\CurrentControlSet\services\MYSQL </span>/v ErrorControl /t REG_DWORD /d <span>1</span> /<span>f reg add HKLM\SYSTEM\CurrentControlSet\services\MYSQL </span>/v ImagePath /t REG_SZ /d <span>"</span><span>\"%~dp0\bin\mysqld.exe\" --defaults-file=\"%~dp0\my.ini\" MYSQL</span><span>"</span> /<span>f reg add HKLM\SYSTEM\CurrentControlSet\services\MYSQL </span>/v ObjectName /t REG_SZ /d LocalSystem /<span>f reg add HKLM\SYSTEM\CurrentControlSet\services\MYSQL </span>/v Start /t REG_DWORD /d <span>2</span> /<span>f reg add HKLM\SYSTEM\CurrentControlSet\services\MYSQL </span>/v Type /t REG_DWORD /d <span>16</span> /<span>f net start mysql</span>
step9: Uninstall the mysql you just installed.
step10: Run the mysql install.bat script to install mysql. Use services.msc to open the service window and you can see the MySQL service, then the mysql installation is successful. .
Now all the software is installed successfully, but the network server has not been started yet. The next section will explain how to configure it.

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

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

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

To set up a CGI directory in Apache, you need to perform the following steps: Create a CGI directory such as "cgi-bin", and grant Apache write permissions. Add the "ScriptAlias" directive block in the Apache configuration file to map the CGI directory to the "/cgi-bin" URL. Restart Apache.

Apache connects to a database requires the following steps: Install the database driver. Configure the web.xml file to create a connection pool. Create a JDBC data source and specify the connection settings. Use the JDBC API to access the database from Java code, including getting connections, creating statements, binding parameters, executing queries or updates, and processing results.

When the Apache 80 port is occupied, the solution is as follows: find out the process that occupies the port and close it. Check the firewall settings to make sure Apache is not blocked. If the above method does not work, please reconfigure Apache to use a different port. Restart the Apache service.

There are 3 ways to view the version on the Apache server: via the command line (apachectl -v or apache2ctl -v), check the server status page (http://<server IP or domain name>/server-status), or view the Apache configuration file (ServerVersion: Apache/<version number>).

How to view the Apache version? Start the Apache server: Use sudo service apache2 start to start the server. View version number: Use one of the following methods to view version: Command line: Run the apache2 -v command. Server Status Page: Access the default port of the Apache server (usually 80) in a web browser, and the version information is displayed at the bottom of the page.

How to configure Zend in Apache? The steps to configure Zend Framework in an Apache Web Server are as follows: Install Zend Framework and extract it into the Web Server directory. Create a .htaccess file. Create the Zend application directory and add the index.php file. Configure the Zend application (application.ini). Restart the Apache Web server.

Apache cannot start because the following reasons may be: Configuration file syntax error. Conflict with other application ports. Permissions issue. Out of memory. Process deadlock. Daemon failure. SELinux permissions issues. Firewall problem. Software conflict.

To delete an extra ServerName directive from Apache, you can take the following steps: Identify and delete the extra ServerName directive. Restart Apache to make the changes take effect. Check the configuration file to verify changes. Test the server to make sure the problem is resolved.
