search
HomeBackend DevelopmentPHP TutorialApache 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)

Apache php Mysql deployment (1) download and installation, apachemysql_PHP tutorial 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:

 Apache php Mysql deployment (1) download and installation, apachemysql_PHP tutorialstep1: 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:

Apache php Mysql deployment (1) download and installation, apachemysql_PHP tutorialstep3: 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.

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/1139955.htmlTechArticleApache php Mysql deployment (1) Download and installation, apachemysql Preface Recently, the company needs to develop a website, but it has special requirements : Java cannot be used and can only be deployed on the Windows platform. No...
Statement
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
How does PHP identify a user's session?How does PHP identify a user's session?May 01, 2025 am 12:23 AM

PHPidentifiesauser'ssessionusingsessioncookiesandsessionIDs.1)Whensession_start()iscalled,PHPgeneratesauniquesessionIDstoredinacookienamedPHPSESSIDontheuser'sbrowser.2)ThisIDallowsPHPtoretrievesessiondatafromtheserver.

What are some best practices for securing PHP sessions?What are some best practices for securing PHP sessions?May 01, 2025 am 12:22 AM

The security of PHP sessions can be achieved through the following measures: 1. Use session_regenerate_id() to regenerate the session ID when the user logs in or is an important operation. 2. Encrypt the transmission session ID through the HTTPS protocol. 3. Use session_save_path() to specify the secure directory to store session data and set permissions correctly.

Where are PHP session files stored by default?Where are PHP session files stored by default?May 01, 2025 am 12:15 AM

PHPsessionfilesarestoredinthedirectoryspecifiedbysession.save_path,typically/tmponUnix-likesystemsorC:\Windows\TemponWindows.Tocustomizethis:1)Usesession_save_path()tosetacustomdirectory,ensuringit'swritable;2)Verifythecustomdirectoryexistsandiswrita

How do you retrieve data from a PHP session?How do you retrieve data from a PHP session?May 01, 2025 am 12:11 AM

ToretrievedatafromaPHPsession,startthesessionwithsession_start()andaccessvariablesinthe$_SESSIONarray.Forexample:1)Startthesession:session_start().2)Retrievedata:$username=$_SESSION['username'];echo"Welcome,".$username;.Sessionsareserver-si

How can you use sessions to implement a shopping cart?How can you use sessions to implement a shopping cart?May 01, 2025 am 12:10 AM

The steps to build an efficient shopping cart system using sessions include: 1) Understand the definition and function of the session. The session is a server-side storage mechanism used to maintain user status across requests; 2) Implement basic session management, such as adding products to the shopping cart; 3) Expand to advanced usage, supporting product quantity management and deletion; 4) Optimize performance and security, by persisting session data and using secure session identifiers.

How do you create and use an interface in PHP?How do you create and use an interface in PHP?Apr 30, 2025 pm 03:40 PM

The article explains how to create, implement, and use interfaces in PHP, focusing on their benefits for code organization and maintainability.

What is the difference between crypt() and password_hash()?What is the difference between crypt() and password_hash()?Apr 30, 2025 pm 03:39 PM

The article discusses the differences between crypt() and password_hash() in PHP for password hashing, focusing on their implementation, security, and suitability for modern web applications.

How can you prevent Cross-Site Scripting (XSS) in PHP?How can you prevent Cross-Site Scripting (XSS) in PHP?Apr 30, 2025 pm 03:38 PM

Article discusses preventing Cross-Site Scripting (XSS) in PHP through input validation, output encoding, and using tools like OWASP ESAPI and HTML Purifier.

See all articles

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 Tools

WebStorm Mac version

WebStorm Mac version

Useful JavaScript development tools

Dreamweaver Mac version

Dreamweaver Mac version

Visual web development tools

ZendStudio 13.5.1 Mac

ZendStudio 13.5.1 Mac

Powerful PHP integrated development environment

PhpStorm Mac version

PhpStorm Mac version

The latest (2018.2.1) professional PHP integrated development tool

EditPlus Chinese cracked version

EditPlus Chinese cracked version

Small size, syntax highlighting, does not support code prompt function