RHELCentOSApacheLAMPMariaDB
I
am new Red Hat Enterprise Linux version 7 user/sysadmin/developer. This version made the big number change for RHEL 7/CentOS 7. How can I install LAMP (Linux, Apache, MariaDB, PHP) stack on a RHEL version 7 or CentOS Linux version 7 using CLI or over ssh based session?Tutorial details | |
---|---|
Difficulty | Easy(rss) |
Root privileges | Yes |
Requirements | CentOS/RHEL v7.x |
Estimated completion time | 20m |
RHEL 7 has been released and CentOS Linux 7 is on its way with many notable changes. This guide explains how to install LAMP server.
More about LAMP
LAMP is nothing but a software bundle or a platform consisting of Linux operating system, Apache web-server, MySQL database server and PHP (or Perl/Python)scripting language. The LAMP stack is used for building heavy-duty dynamic web sites entirely out of free and open-source software. In this tutorial, I'm going to explain how to Linux, Apache, MySQL/MariaDB (drop in replacement for MySQL), PHP (LAMP) stack On CentOS 7 or RHEL 7.
Assumptions
- I'm assuming that you've installed basic RHEL 7 or CentOS 7 server. Open the Terminal app and type the following command as root user.
- You must be familiar with theyum command
- You must know your Server's IP address. Use the following command to find your server's ip address for eth0 interface:
ifconfig eth0
OR
ip a show eth0
OR
ip addr list eth0 | awk '/inet /{sub(///[0-9]+/,"",$2); print $2}'
OR
ifconfig eth0 | awk '/inet /{print $2}'
10.41.143.156 - I'm going to use IP address 10.41.143.156 for testing purpose. Feel free to replace this IP address with your actual private or public IP address.
Enough talk, let's set up LAMP stack.
Step #1: Install Apache on a CentOS 7 / RHEL 7 server
Type the followingyum commandto install Apache web-server:
sudo yum install httpd
Sample outputs:
Loaded plugins: amazon-id, rhui-lbResolving Dependencies--> Running transaction check---> Package httpd.x86_64 0:2.4.6-17.el7 will be installed--> Processing Dependency: httpd-tools = 2.4.6-17.el7 for package: httpd-2.4.6-17.el7.x86_64--> Processing Dependency: /etc/mime.types for package: httpd-2.4.6-17.el7.x86_64--> Running transaction check---> Package httpd-tools.x86_64 0:2.4.6-17.el7 will be installed---> Package mailcap.noarch 0:2.1.41-2.el7 will be installed--> Finished Dependency Resolution Dependencies Resolved ====================================================================================================== PackageArchVersion Repository Size======================================================================================================Installing: httpdx86_642.4.6-17.el7rhui-REGION-rhel-server-releases1.2 MInstalling for dependencies: httpd-toolsx86_642.4.6-17.el7rhui-REGION-rhel-server-releases 77 k mailcapnoarch2.1.41-2.el7rhui-REGION-rhel-server-releases 31 k Transaction Summary======================================================================================================Install1 Package (+2 Dependent packages) Total download size: 1.3 MInstalled size: 3.9 MIs this ok [y/d/N]: yDownloading packages:(1/3): httpd-tools-2.4.6-17.el7.x86_64.rpm |77 kB00:00:00(2/3): httpd-2.4.6-17.el7.x86_64.rpm | 1.2 MB00:00:00(3/3): mailcap-2.1.41-2.el7.noarch.rpm |31 kB00:00:00------------------------------------------------------------------------------------------------------Total 2.0 MB/s | 1.3 MB00:00:00Running transaction checkRunning transaction testTransaction test succeededRunning transactionInstalling : httpd-tools-2.4.6-17.el7.x86_641/3Installing : mailcap-2.1.41-2.el7.noarch2/3Installing : httpd-2.4.6-17.el7.x86_643/3Verifying: mailcap-2.1.41-2.el7.noarch1/3Verifying: httpd-tools-2.4.6-17.el7.x86_642/3Verifying: httpd-2.4.6-17.el7.x86_643/3 Installed:httpd.x86_64 0:2.4.6-17.el7 Dependency Installed:httpd-tools.x86_64 0:2.4.6-17.el7 mailcap.noarch 0:2.1.41-2.el7 Complete!
Enable the httpd service at boot time
To make sure the httpd service start automatically at the boot time, enter:
sudo systemctl enable httpd.service
Sample outputs:
ln -s '/usr/lib/systemd/system/httpd.service' '/etc/systemd/system/multi-user.target.wants/httpd.service'
The following command will disable the httpd service at the boot time:
sudo systemctl disable httpd.service
Sample outputs:
rm '/etc/systemd/system/multi-user.target.wants/httpd.service'
Start the httpd service on a CentOS/RHEL v7.x
sudo systemctl start httpd.service
At this stage, you can point your web-browser to your server's IP address such as http://10.41.143.156). The following page should display on screen:

Fig.01: Check if Apache is Running on CentOS/RHEL 7 server
Stop the httpd service on a CentOS/RHEL v7.x
sudo systemctl stop httpd.service
Restart the httpd service on a CentOS/RHEL v7.x
sudo systemctl restart httpd.service
Finding the httpd service status on a CentOS/RHEL v7.x
To verify that the httpd service is running, enter:
systemctl is-active httpd.service
Sample outputs:
active
Gracefully restart the httpd service on a CentOS/RHEL v7.x
sudo apachectl graceful
Test httpd/Apache configuration file for errors on a CentOS/RHEL v7.x
sudo apachectl configtest
Sample outputs:
Syntax OK
httpd service default configuration
- Default config file: /etc/httpd/conf/httpd.conf
- Configuration files which load modules : /etc/httpd/conf.modules.d/ directory (e.g. PHP)
- Select MPMs (Processing Model) as loadable modules [worker, prefork (default)] and event: /etc/httpd/conf.modules.d/00-mpm.conf
- Default ports: 80 and 443 (SSL)
- Default log files: /var/log/httpd/{access_log,error_log}
Step #2: Install MariaDB on a CentOS 7 / RHEL 7 server
MariaDB An enhanced, drop-in replacement for MySQL server. RHEL/CentOS v7.x shifts from MySQL to MariaDB for its database management system needs. Type the followingyum commandto install MariaDB server:
sudo yum install mariadb-server mariadb
To start mariadb, type:
sudo systemctl start mariadb.service
To make sure the mariadb service start automatically at the boot time, enter:
sudo systemctl enable mariadb.service
Sample outputs:
ln -s '/usr/lib/systemd/system/mariadb.service' '/etc/systemd/system/multi-user.target.wants/mariadb.service'
To stop/restart and disable mariadb service use the following commands:
sudo systemctl stop mariadb.service #<h3 id="Securing-MariaDB">Securing MariaDB</h3> <p>Type the following command:</p> <code>sudo /usr/bin/mysql_secure_installation</code> <p>Sample outputs:</p><pre class="brush:php;toolbar:false">NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDBSERVERS IN PRODUCTION USE!PLEASE READ EACH STEP CAREFULLY!In order to log into MariaDB to secure it, we'll need the currentpassword for the root user.If you've just installed MariaDB, andyou haven't set the root password yet, the password will be blank,so you should just press enter here.Enter current password for root (enter for none): <strong>PRESS-ENTER-KEY</strong>OK, successfully used password, moving on...Setting the root password ensures that nobody can log into the MariaDBroot user without the proper authorisation.Set root password? [Y/n] YNew password: <strong>YOUR-NEW-PASSWORD-HERE</strong>Re-enter new password: <strong>YOUR-NEW-PASSWORD-HERE</strong>Password updated successfully!Reloading privilege tables.. ... Success!By default, a MariaDB installation has an anonymous user, allowing anyoneto log into MariaDB without having to have a user account created forthem.This is intended only for testing, and to make the installationgo a bit smoother.You should remove them before moving into aproduction environment.Remove anonymous users? [Y/n] <strong>Y</strong> ... Success!Normally, root should only be allowed to connect from 'localhost'.Thisensures that someone cannot guess at the root password from the network.Disallow root login remotely? [Y/n] <strong>Y</strong> ... Success!By default, MariaDB comes with a database named 'test' that anyone canaccess.This is also intended only for testing, and should be removedbefore moving into a production environment.Remove test database and access to it? [Y/n] <strong>Y</strong> - Dropping test database... ... Success! - Removing privileges on test database... ... Success!Reloading the privilege tables will ensure that all changes made so farwill take effect immediately.Reload privilege tables now? [Y/n] <strong>Y</strong> ... Success!Cleaning up...All done!If you've completed all of the above steps, your MariaDBinstallation should now be secure.Thanks for using MariaDB!
Test MariaDB installation
Type the following command
mysql -u root -p
Sample outputs:

Fig.02: Mariadb test connection on a CentOS / RHEL Linux v7.x
Step #3: Install PHP on a CentOS/RHEL v7.x
To install PHP and modules such as gd/msyql type the followingyum command:
sudo yum install php php-mysql php-gd php-pear
You must restart the httpd (Apache) service, enter:
sudo systemctl restart httpd.service
To search all other php modules, type:
sudo yum search php-
Sample outputs:
php-cli.x86_64 : Command-line interface for PHPphp-common.x86_64 : Common files for PHPphp-gd.x86_64 : A module for PHP applications for using the gd graphics libraryphp-ldap.x86_64 : A module for PHP applications that use LDAPphp-mysql.x86_64 : A module for PHP applications that use MySQL databasesphp-odbc.x86_64 : A module for PHP applications that use ODBC databasesphp-pdo.x86_64 : A database access abstraction module for PHP applicationsphp-pear.noarch : PHP Extension and Application Repository frameworkphp-pecl-memcache.x86_64 : Extension to work with the Memcached caching daemonphp-pgsql.x86_64 : A PostgreSQL database module for PHPphp-process.x86_64 : Modules for PHP script using system process interfacesphp-recode.x86_64 : A module for PHP applications for using the recode libraryphp-soap.x86_64 : A module for PHP applications that use the SOAP protocolphp-xml.x86_64 : A module for PHP applications which use XMLphp-xmlrpc.x86_64 : A module for PHP applications which use the XML-RPC protocol
To find more info about a module type:
sudo yum info php-pgsql
To install php module called php-pgsql type:
sudo yum install php-pgsql
Test PHP on your server
Create a file called /var/www/html/test.php as follows:
sudo vi /var/www/html/test.php
Append the following code:
<?php phpinfo(INFO_GENERAL);?>
Save and close the file. Point your web-browser to your server's IP address such as http://10.41.143.156/info.php (feel free to replace the 10.41.143.156 with your actual IP address):
http://10.41.143.156/info.php

ACID屬性包括原子性、一致性、隔離性和持久性,是數據庫設計的基石。 1.原子性確保事務要么完全成功,要么完全失敗。 2.一致性保證數據庫在事務前後保持一致狀態。 3.隔離性確保事務之間互不干擾。 4.持久性確保事務提交後數據永久保存。

MySQL既是數據庫管理系統(DBMS),也與編程語言緊密相關。 1)作為DBMS,MySQL用於存儲、組織和檢索數據,優化索引可提高查詢性能。 2)通過SQL與編程語言結合,嵌入在如Python中,使用ORM工具如SQLAlchemy可簡化操作。 3)性能優化包括索引、查詢、緩存、分庫分錶和事務管理。

MySQL使用SQL命令管理數據。 1.基本命令包括SELECT、INSERT、UPDATE和DELETE。 2.高級用法涉及JOIN、子查詢和聚合函數。 3.常見錯誤有語法、邏輯和性能問題。 4.優化技巧包括使用索引、避免SELECT*和使用LIMIT。

MySQL是一種高效的關係型數據庫管理系統,適用於存儲和管理數據。其優勢包括高性能查詢、靈活的事務處理和豐富的數據類型。實際應用中,MySQL常用於電商平台、社交網絡和內容管理系統,但需注意性能優化、數據安全和擴展性。

SQL和MySQL的關係是標準語言與具體實現的關係。 1.SQL是用於管理和操作關係數據庫的標準語言,允許進行數據的增、刪、改、查。 2.MySQL是一個具體的數據庫管理系統,使用SQL作為其操作語言,並提供高效的數據存儲和管理。

InnoDB使用redologs和undologs確保數據一致性和可靠性。 1.redologs記錄數據頁修改,確保崩潰恢復和事務持久性。 2.undologs記錄數據原始值,支持事務回滾和MVCC。

EXPLAIN命令的關鍵指標包括type、key、rows和Extra。 1)type反映查詢的訪問類型,值越高效率越高,如const優於ALL。 2)key顯示使用的索引,NULL表示無索引。 3)rows預估掃描行數,影響查詢性能。 4)Extra提供額外信息,如Usingfilesort提示需要優化。

Usingtemporary在MySQL查詢中表示需要創建臨時表,常見於使用DISTINCT、GROUPBY或非索引列的ORDERBY。可以通過優化索引和重寫查詢避免其出現,提升查詢性能。具體來說,Usingtemporary出現在EXPLAIN輸出中時,意味著MySQL需要創建臨時表來處理查詢。這通常發生在以下情況:1)使用DISTINCT或GROUPBY時進行去重或分組;2)ORDERBY包含非索引列時進行排序;3)使用複雜的子查詢或聯接操作。優化方法包括:1)為ORDERBY和GROUPB


熱AI工具

Undresser.AI Undress
人工智慧驅動的應用程序,用於創建逼真的裸體照片

AI Clothes Remover
用於從照片中去除衣服的線上人工智慧工具。

Undress AI Tool
免費脫衣圖片

Clothoff.io
AI脫衣器

AI Hentai Generator
免費產生 AI 無盡。

熱門文章

熱工具

MantisBT
Mantis是一個易於部署的基於Web的缺陷追蹤工具,用於幫助產品缺陷追蹤。它需要PHP、MySQL和一個Web伺服器。請查看我們的演示和託管服務。

SAP NetWeaver Server Adapter for Eclipse
將Eclipse與SAP NetWeaver應用伺服器整合。

VSCode Windows 64位元 下載
微軟推出的免費、功能強大的一款IDE編輯器

SublimeText3 英文版
推薦:為Win版本,支援程式碼提示!

ZendStudio 13.5.1 Mac
強大的PHP整合開發環境