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

Mastering the method of adding MySQL users is crucial for database administrators and developers because it ensures the security and access control of the database. 1) Create a new user using the CREATEUSER command, 2) Assign permissions through the GRANT command, 3) Use FLUSHPRIVILEGES to ensure permissions take effect, 4) Regularly audit and clean user accounts to maintain performance and security.

ChooseCHARforfixed-lengthdata,VARCHARforvariable-lengthdata,andTEXTforlargetextfields.1)CHARisefficientforconsistent-lengthdatalikecodes.2)VARCHARsuitsvariable-lengthdatalikenames,balancingflexibilityandperformance.3)TEXTisidealforlargetextslikeartic

Best practices for handling string data types and indexes in MySQL include: 1) Selecting the appropriate string type, such as CHAR for fixed length, VARCHAR for variable length, and TEXT for large text; 2) Be cautious in indexing, avoid over-indexing, and create indexes for common queries; 3) Use prefix indexes and full-text indexes to optimize long string searches; 4) Regularly monitor and optimize indexes to keep indexes small and efficient. Through these methods, we can balance read and write performance and improve database efficiency.

ToaddauserremotelytoMySQL,followthesesteps:1)ConnecttoMySQLasroot,2)Createanewuserwithremoteaccess,3)Grantnecessaryprivileges,and4)Flushprivileges.BecautiousofsecurityrisksbylimitingprivilegesandaccesstospecificIPs,ensuringstrongpasswords,andmonitori

TostorestringsefficientlyinMySQL,choosetherightdatatypebasedonyourneeds:1)UseCHARforfixed-lengthstringslikecountrycodes.2)UseVARCHARforvariable-lengthstringslikenames.3)UseTEXTforlong-formtextcontent.4)UseBLOBforbinarydatalikeimages.Considerstorageov

When selecting MySQL's BLOB and TEXT data types, BLOB is suitable for storing binary data, and TEXT is suitable for storing text data. 1) BLOB is suitable for binary data such as pictures and audio, 2) TEXT is suitable for text data such as articles and comments. When choosing, data properties and performance optimization must be considered.

No,youshouldnotusetherootuserinMySQLforyourproduct.Instead,createspecificuserswithlimitedprivilegestoenhancesecurityandperformance:1)Createanewuserwithastrongpassword,2)Grantonlynecessarypermissionstothisuser,3)Regularlyreviewandupdateuserpermissions

MySQLstringdatatypesshouldbechosenbasedondatacharacteristicsandusecases:1)UseCHARforfixed-lengthstringslikecountrycodes.2)UseVARCHARforvariable-lengthstringslikenames.3)UseBINARYorVARBINARYforbinarydatalikecryptographickeys.4)UseBLOBorTEXTforlargeuns


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

SublimeText3 Chinese version
Chinese version, very easy to use

mPDF
mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),

SecLists
SecLists is the ultimate security tester's companion. It is a collection of various types of lists that are frequently used during security assessments, all in one place. SecLists helps make security testing more efficient and productive by conveniently providing all the lists a security tester might need. List types include usernames, passwords, URLs, fuzzing payloads, sensitive data patterns, web shells, and more. The tester can simply pull this repository onto a new test machine and he will have access to every type of list he needs.

MinGW - Minimalist GNU for Windows
This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.

SAP NetWeaver Server Adapter for Eclipse
Integrate Eclipse with SAP NetWeaver application server.
