Backend Development
PHP Tutorial
Apache php Mysql deployment (1) download and installation, apachemysql_PHP tutorial
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
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 Framework Performance Comparison: The Ultimate Showdown of Speed vs. Efficiency
Apr 30, 2024 pm 12:27 PM
According to benchmarks, Laravel excels in page loading speed and database queries, while CodeIgniter excels in data processing. When choosing a PHP framework, you should consider application size, traffic patterns, and development team skills.
How to add a server in eclipse
May 05, 2024 pm 07:27 PM
To add a server to Eclipse, follow these steps: Create a server runtime environment Configure the server Create a server instance Select the server runtime environment Configure the server instance Start the server deployment project
How to conduct concurrency testing and debugging in Java concurrent programming?
May 09, 2024 am 09:33 AM
Concurrency testing and debugging Concurrency testing and debugging in Java concurrent programming are crucial and the following techniques are available: Concurrency testing: Unit testing: Isolate and test a single concurrent task. Integration testing: testing the interaction between multiple concurrent tasks. Load testing: Evaluate an application's performance and scalability under heavy load. Concurrency Debugging: Breakpoints: Pause thread execution and inspect variables or execute code. Logging: Record thread events and status. Stack trace: Identify the source of the exception. Visualization tools: Monitor thread activity and resource usage.
Application of algorithms in the construction of 58 portrait platform
May 09, 2024 am 09:01 AM
1. Background of the Construction of 58 Portraits Platform First of all, I would like to share with you the background of the construction of the 58 Portrait Platform. 1. The traditional thinking of the traditional profiling platform is no longer enough. Building a user profiling platform relies on data warehouse modeling capabilities to integrate data from multiple business lines to build accurate user portraits; it also requires data mining to understand user behavior, interests and needs, and provide algorithms. side capabilities; finally, it also needs to have data platform capabilities to efficiently store, query and share user profile data and provide profile services. The main difference between a self-built business profiling platform and a middle-office profiling platform is that the self-built profiling platform serves a single business line and can be customized on demand; the mid-office platform serves multiple business lines, has complex modeling, and provides more general capabilities. 2.58 User portraits of the background of Zhongtai portrait construction
The evasive module protects your website from application layer DOS attacks
Apr 30, 2024 pm 05:34 PM
There are a variety of attack methods that can take a website offline, and the more complex methods involve technical knowledge of databases and programming. A simpler method is called a "DenialOfService" (DOS) attack. The name of this attack method comes from its intention: to cause normal service requests from ordinary customers or website visitors to be denied. Generally speaking, there are two forms of DOS attacks: the third and fourth layers of the OSI model, that is, the network layer attack. The seventh layer of the OSI model, that is, the application layer attack. The first type of DOS attack - the network layer, occurs when a large number of of junk traffic flows to the web server. When spam traffic exceeds the network's ability to handle it, the website goes down. The second type of DOS attack is at the application layer and uses combined
How to deploy and maintain a website using PHP
May 03, 2024 am 08:54 AM
To successfully deploy and maintain a PHP website, you need to perform the following steps: Select a web server (such as Apache or Nginx) Install PHP Create a database and connect PHP Upload code to the server Set up domain name and DNS Monitoring website maintenance steps include updating PHP and web servers, and backing up the website , monitor error logs and update content.
How to implement PHP security best practices
May 05, 2024 am 10:51 AM
How to Implement PHP Security Best Practices PHP is one of the most popular backend web programming languages used for creating dynamic and interactive websites. However, PHP code can be vulnerable to various security vulnerabilities. Implementing security best practices is critical to protecting your web applications from these threats. Input validation Input validation is a critical first step in validating user input and preventing malicious input such as SQL injection. PHP provides a variety of input validation functions, such as filter_var() and preg_match(). Example: $username=filter_var($_POST['username'],FILTER_SANIT
How to leverage Kubernetes Operator simplifiy PHP cloud deployment?
May 06, 2024 pm 04:51 PM
KubernetesOperator simplifies PHP cloud deployment by following these steps: Install PHPOperator to interact with the Kubernetes cluster. Deploy the PHP application, declare the image and port. Manage the application using commands such as getting, describing, and viewing logs.
