Source code compilation and installation LAMP



1.LAMP introduction and overview


2.1Apache origin

2.2 introduction to Apache


3.1 compiling and installing httpd server

3.2 compiling and installing httpd server

4. Install MYSQL

4.1 installing MYSQL

4.2sql_ The common values of mode are as follows:

4.3 setting environment variables

 5. Install PHP

6. Installation Forum



1. Do you know Apache website service? MySQL service? PHP services? LAMP architecture application real column?  

1.LAMP introduction and overview

(1) Overview of LAMP platform LAMP architecture is one of the mature enterprise website application modes at present. It refers to a whole system and related software working together, which can provide dynamic web site services and its application development environment
LAMP is an abbreviation, including Linux operating system, Apache Web server, MySQL database server, PHP (or perl, Python) web programming language
(2) . sequence of building LAMP platform when building LAMP platform, the installation sequence of each component is Linux, Apache, MySQL and PHP
There is no strict sequence requirement for the installation of Apache and MySQL, while the installation of PHP environment is generally put at the end, which is responsible for communicating the web server and database system to work together
(2) Advantages of compilation and installation 1. It has a large degree of freedom and customizable functions. 2. It can obtain the latest software version in time. 3. It is generally applicable to most Linux versions and is easy to use all the time
(3) Main functions of components
(platform) Linux: as the basis of LAMP architecture, it provides the operating system used to support the Web site, which can provide better stability and compatibility with the other three components (AMP components also support Windows, UNIX and other platforms).  
(front desk) Apache: as the front end of LAMP architecture, it is a powerful and stable Web server program. The server directly provides users with website access, sending Web pages, pictures and other file contents.  
(background) MySQL: as the back end of LAMP architecture, it is a popular open source relational database system. In enterprise websites, business systems and other applications, various account information, product information, customer information and business data can be stored in MySQL database. Other programs can query and change these information through SQL statements.  
(intermediate connection) PHP/Perl/Python: as three programming languages for developing dynamic Web pages, it is responsible for interpreting dynamic Web page files, communicating the Web server and database system to work together, and providing the development and running environment of Web applications. PHP is a widely used open source multi-purpose scripting language, which can be embedded in HTML, especially suitable for Web application development.


2.1Apache origin

Originated from a patch server, the famous open source Web service software, Apache service program version 1.0 was released in 1995. The Apache Software Foundation (ASF) is responsible for maintaining the latest official website named "Apache HTTP Server":  

2.2 introduction to Apache

1. Main features
Open source, cross platform, and timely
Support multiple web programming languages
Modular design, stable operation and good safety
2. Software version
At present, the highest version is 1.3, which runs stably
Downward compatibility is good, but it lacks some newer functions
At present, the highest version is 2.4, which has more functional features and 1.4 Compared with X, the configuration management style is quite different
-----------Install Apache - the following two plug-ins are httpd2 Required for versions after 4-----

tar xf apr-1.6.2.tar.gz
tar xf apr-util-1.6.0.tar.gz
tar xf httpd-2.4.29.tar.bz2
mv apr-1.6.2 httpd-2.4.29/srclib/apr
mv apr-util-1.6.0 httpd-2.4.29/srclib/apr-util
yum -y install \
gcc \							#C language compiler
gcc-c++ \						#C + + compiler
make \							#Source code compiler (source code to binary file)
pcre \							#pcre is a perl function library, including perl compatible regular expression library
pcre-devel \                    #perl interface development package
expat-devel \                   #It is used to support the website to parse HTML and XML files
perl                            #perl compiler

yum -y install \
gcc \
gcc-c++ \
make \
pcre-devel \
expat-devel \
cd httpd-2.4.29
./configure \
--prefix=/usr/local/httpd \		#Specify the installation path of the httpd service program
--enable-so \					#Enable dynamic loading core module support to enable httpd to further expand its functions
--enable-rewrite \				#Enable the web address rewriting function for website optimization, anti-theft chain and directory migration maintenance
--enable-charset-lite \			#Start character set support to support pages encoded with various character sets
--enable-cgi					#Enable CGI (general Gateway Interface) script program support to facilitate the external expansion of application access capability of the website

cd /opt/httpd-2.4.29/
./configure \
--prefix=/usr/local/httpd \
--enable-so \
--enable-rewrite \
--enable-charset-lite \

make && make install

#Optimize the configuration file path, and put the executable program file of httpd service into the directory of path environment variable for system identification
ln -s /usr/local/httpd/conf/httpd.conf /etc/
ln -s /usr/local/httpd/bin/* /usr/local/bin/ 
#Convenient for service management
cp /usr/local/httpd/bin/apachectl /etc/init.d/httpd
vim /etc/init.d/httpd 
#chkconfig: 35 85 21 //35 level automatic operation 85th startup 21st shutdown
#description: Apache is a World Wide Web server
chkconfig --add httpd / / add httpd to the system manager
#You can use service or systemctl for management
vi /usr/local/httpd/conf/httpd.conf
#– line 52 – modified
– line 197 – uncomment, modify
– line 221 – default home page storage path
DocumentRoot "/usr/local/httpd/htdocs"
– line 255 – default home page file name setting directoryindex html
#Check syntax
httpd -t or apachectl -t
cat /usr/local/httpd/htdocs/index.html 
service httpd restart
netstat -anpt | grep 80











3.1 compiling and installing httpd server

1. The advantages of compilation and installation have a large degree of freedom, the functions can be customized, and the latest software version can be obtained in time. It is generally applicable to most Linux versions and easy to transplant
Source code reference of Apache server:  

3.2 compiling and installing httpd server

1. Preparation
Uninstall httpd and related dependent packages

[root@www ~]# rpm -e httpd --nodeps
[root@www~]# yum install -y apr-util-devel pcre-devel

2. Source code compilation and installation

[root@www~]# tar zxf httpd-2.4.25.tar.gz -C lusrlsrc
[root@www ~]# cd /usr/src/httpd-2.4.25/
[root@www httpd-2.4.25]# ./configure --prefix=/usr/local/httpd--enable-so --enable-rewrite --enable-charset-lite --enable-cgi
[root@www httpd-2.4.25]# make && make install

4. Install MYSQL

4.1 installing MYSQL

yum -y install \
gcc \
gcc-c++ \
ncurses \				#Dynamic library of graphic interactive function under character terminal
ncurses-devel \			#ncurses development kit
bison \					#Parser
cmake					#mysql needs to be compiled and installed with cmake

yum -y install gcc gcc-c++ ncurses ncurses-devel bison cmake

#Create program user management
useradd -s /sbin/nologin mysql

tar zxvf mysql-5.7.17.tar.gz -C /opt
tar zxvf boost_1_59_0.tar.gz -C /usr/local/
mv /usr/local/boost_1_59_0 /usr/local/boost
cd /opt/mysql-5.7.17/
cmake \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \		#Specify the installation path of mysql
-DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock \ #Specify the storage path of mysql process listening socket file (database connection file)
-DSYSCONFDIR=/etc \                             #Specify the storage path of the configuration file
-DSYSTEMD_PID_DIR=/usr/local/mysql \            #Specify the storage path of the process file
-DDEFAULT_CHARSET=utf8  \                       #Specifies the character set encoding used by default, such as utf8
-DDEFAULT_COLLATION=utf8_general_ci \			#Specifies the default character set collation rule to use
-DWITH_EXTRA_CHARSETS=all \						#Specifies that other character set encodings are supported
-DWITH_INNOBASE_STORAGE_ENGINE=1 \              #Install INNOBASE storage engine
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \               #Installing the ARCHIVE storage engine 
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \             #Installing the BLACKHOLE storage engine 
-DWITH_PERFSCHEMA_STORAGE_ENGINE=1 \            #Install FEDERATED storage engine 
-DMYSQL_DATADIR=/usr/local/mysql/data \         #Specify the storage path of the database file
-DWITH_BOOST=/usr/local/boost \          #Specify the path of boost. If MySQL boost integration package is used for installation, - DWITH_BOOST=boost
-DWITH_SYSTEMD=1								#Generate files for systemctl management

Storage engine options:
MYISAM,MERGE,MEMORY and cSv The engine is compiled into the server by default and does not need to be explicitly installed. Statically compile a storage engine to the server, using-DWITH engine STORAGE ENGINE= 1
Available storage engine values are:ARCHIVE,BLACKHOLE,EXAMPLE,FBDERATBD,IMNOBASB(InnoDB),PARTTTON(partitioning support),and PERFSCHEMA(Performance schema)
make && make install

Note: if an error is reported in the process of CMAKE, after the error is solved, you need to put cmakecache in the source directory Txt file is deleted, and then CMAKE is again. Otherwise, the error remains the same

make -j 3 && make install
#Create ordinary user management mysql
useradd -s /sbin/nologin mysql
chown -R mysql:mysql /usr/local/mysql/
#Change management master / group
chown mysql:mysql /etc/my.cnf

#Modify profile
vim /etc/my.cnf								#Delete the original configuration item and add the following content again
[client]									#Client settings
port = 3306

[mysqld]									#Service global settings
user = mysql       							#Set management user
basedir=/usr/local/mysql					#Specify the installation directory of the database
datadir=/usr/local/mysql/data				#Specify the storage path of the database file
port = 3306									#Specify port
character-set-server=utf8					#Set the encoding format of the server character set to utf8
pid-file = /usr/local/mysql/		#Specify pid process file path
socket=/usr/local/mysql/mysql.sock			#Specify database connection file
bind-address =						#Set the listening address. means that all IP addresses are allowed. If multiple IP addresses are allowed, they should be separated by spaces
skip-name-resolve							#Disable DNS resolution
max_connections=2048						#Set the maximum number of mysql connections
default-storage-engine=INNODB				#Specify the default storage engine
max_allowed_packet=16M						#Set the maximum packet size received by the database
server-id = 1								#Specify service ID number

port = 3306

port = 3306

user = mysql 
port = 3306	
pid-file = /usr/local/mysql/
bind-address =
server-id = 1

4.2sql_ The common values of mode are as follows:

 If the required storage engine is disabled or not compiled,Then throw an error. When this value is not set,Replace with default storage engine,And throw an exception

 In this mode,If a value cannot be inserted into a transaction table,Then interrupt the current operation,No restrictions on non transaction tables

 Ban Zheng GRANT Create a user with a blank password

mysql The self growing column in can be O Start. By default, the self growth column starts from 1. If you insert data with a value of 0, an error will be reported

 Zero date and month are not allowed

mysql Zero date insertion is not allowed in the database,Inserting a zero date throws an error instead of a warning

 stay INSERT or UPDATE In the process, if the data is divided by zero, an error is generated instead of a warning. By default, when the data is divided by zero MysQL return NULL

 take"||"Treat as a concatenation operator of a string rather than an or operator, which is similar to Oracle The database is the same as the string splicing function Concat Similar

 Enable ANSI_QUOTES You cannot use double quotation marks to refer to a string after, because it is interpreted as an identifier

4.3 setting environment variables

#Set environment variables and declare / declare mysql commands for system recognition
echo "PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile
source /etc/profile

#Initialize database
cd /usr/local/mysql/bin/
./mysqld \
--initialize-insecure \				#Generation initialization password is null
--user=mysql \                      #Specify administrative users
--basedir=/usr/local/mysql \        #Specify the installation directory of the database
--datadir=/usr/local/mysql/data		#Specify the storage path of the database file

cd /usr/local/mysql/bin/
./mysqld \
--initialize-insecure \
--user=mysql \
--basedir=/usr/local/mysql \

cp /usr/local/mysql/usr/lib/systemd/system/mysqld.service /usr/lib/systemd/system/
systemctl daemon-reload         #Refresh recognition     
systemctl start mysqld.service  #Open service
systemctl enable mysqld         #Power on self start
netstat -anpt | grep 3306       #View port

#Set password for root account
mysqladmin -u root -p password "123456" 
-->Direct enter




 5. Install PHP

yum -y install \
gd \
libjpeg libjpeg-devel \
libpng libpng-devel \
freetype freetype-devel \
libxml2 libxml2-devel \
zlib zlib-devel \
curl curl-devel \
openssl openssl-devel
 install GD Library and GD Library Association program, which is used to process and generate pictures
cd /opt
tar zxvf php-7.1.24.tar.gz

cd /opt/php-7.1.24/
./configure \
--prefix=/usr/local/php7 \							#Specify the path where the PHP program will be installed
--with-apxs2=/usr/local/httpd/bin/apxs \			#Specifies the file location of the apxs module support program provided by the Apache httpd service
--with-mysql-sock=/usr/local/mysql/mysql.sock \		#Specify the storage path of mysql database connection file
--with-config-file-path=/usr/local/php7				#Set the configuration file for PHP Where ini will be stored
--with-mysqli \										#add to MySQL Extended support #mysqli extension technology can not only call MySQL stored procedures and handle MySQL transactions, but also make accessing the database more stable
--with-zlib \										#Support zlib function and provide data compression
--with-curl \										#Enable curl extension function to realize HTTP Get download and Post request
--with-gd \											#Activate gd library support
--with-jpeg-dir \									#Activate jpeg support
--with-png-dir \									#Activate png support
--with-freetype-dir \
--with-openssl \
--enable-mbstring \									#Enable multi byte string function to support Chinese and other codes
--enable-xml \										#Open extensible markup language module
--enable-session \									#conversation
--enable-ftp \										#Text transfer protocol
--enable-pdo \										#function library
--enable-tokenizer \								#Token interpreter
--enable-zip										#ZIP compression format
make && make install
#Copy the template file and modify it
cp /opt/php-7.1.10/php.ini-development /usr/local/php7/php.ini
vim /usr/local/php7/php.ini
--1170 that 's ok--modify
mysqli.default_socket = /usr/local/mysql/mysql.sock
--939 that 's ok--Uncomment, modify
date.timezone = Asia/Shanghai

#Optimization: put PHP executable program files into the directory of path environment variables for system identification
ln -s /usr/local/php7/bin/* /usr/local/bin/
#Modify Apache configuration file to make Apache support PHP
vi /etc/httpd.conf 
#Add index php
255 <IfModule dir_module>
256     DirectoryIndex index.html index.php
257 </IfModule>
#Insert something below line 392 so that Apache can support it php web page file
AddType application/x-httpd-php .php
AddType application/x-httpd-php-source .phps
##Check whether the module supporting php7 by default exists in line 156
LoadModule php7_module	   modules/

#Create and edit php page files
rm -rf /usr/local/httpd/htdocs/index.html
vim /usr/local/httpd/htdocs/index.php

systemctl restart httpd.service

Test on Web“"


6. Installation Forum

.Create a database
mysql -u root -p 

#Grant the permissions of all tables in the bbs database to bbsuser and set the password

mysql> GRANT all ON bbs.* TO 'bbsuser'@'%' IDENTIFIED BY 'admin123';

#Refresh database
mysql>flush privileges; 

#Unzip the forum zip
unzip -d /opt/dis

cd /opt/dis
#Upload site update package
cp -r upload/ /usr/local/httpd/htdocs/bbs

#Switch forum directory
cd /usr/local/httpd/htdocs/bbs

#Change forum directory owner
chown -R daemon ./config
chown -R daemon ./data
chown -R daemon ./uc_client
chown -R daemon ./uc_server/data

Database server: localhost # is used for local erection. How to fill in the IP address and port number instead of on the local machine
Database name: bbs
Database user name: bbsuser
Database password: admin123
Administrator account: admin
Administrator password: admin123

In case of error, the information is as follows
Fatal error: Uncaught Error: Call to undefined function set_magic_quotes_runtime() in /data/www/install/index.php:12 Stack trace: #0 {main} thrown in /data/www/install/index.php on line 12
#Fatal error: uncapped error: call set of undefined function_ magic_ quotes_ Runtime (), in the 12th line of this file, find the index PHP open this file and find set_magic_quotes_runtime

#Switch directory
cd /usr/local/httpd/htdocs/bbs/install
vim index.php Edit

//Substitute into 

The problem has been solved

The test results are normal and the forum website can be opened normally





grant all on bbs.* to 'bbsuser'@' %' identified by 'admin123 ' ;

grant It refers to the permission range (including operation permission) that can be used in the database:Add, delete, modify and query+Database objects that can be managed)
all:Refers to all operation permissions
on bbs.* :Refers to manageable"database.Scope of data table
to 'bbsuser' @'$' : to Endowed"User object@Source ", the user logging in the database@Source restrictions for this user
identified by 'admin123'; :The user interaction mode is password, and the password is specified as admin123


#attend to each one 's own duties
L  linux Distribution centos 7  #Host operating system
A  Apache   #Processing static requests
M  Mysql 5.7  #data storage 
P  php-7.1.10  #Processing dynamic requests

Apache ->Docking PHP ->php Docking Mysql

apache So fpm/fast cGⅠ Interface form docking and compatible php Static page processing completed by module+Forward dynamic pages php And Apache After docking, docking is required MySQL database﹐The core is the use of mysql.sock Communication document as carrier MysQL:provide mysql.sock Communication documents+ mysql_modules (mysql.cnf )



1.Apache website service
2.MySQL service
3.PHP services
4.LAMP architecture application example
5. Find the correct docking method, find the right version, and be able to use Baidu, Google, csdn and blog park

Keywords: Linux MySQL Apache

Added by busnut on Thu, 24 Feb 2022 14:19:56 +0200