How To Install and phpMyAdmin in Linux

Step One — Install a LAMP Stack

Before we can install phpMyAdmin, we need to install Apache, MySQL, and PHP on our server. Together, along with the underlying operating system, this is known as a LAMP stack (Linux, Apache, MySQL, PHP). We can go ahead and install the necessary components from the default yum repositories by typing:

# sudo yum install httpd mysql-server php php-mysql

A web server, database server, and dynamic processing language will be installed on your server and ready to use.

Check More:  How To Install Apache (httpd) in Linux

Check More:  How To Install MySQL in Linux

Step Two — Check the LAMP Stack

Next, we need to check all the components that we have just installed. Start the Web Server and MySQL server and Check all of them using below commands

#service httpd status

#service mysqld status

Step Three — Install phpMyAdmin

Now, we are ready to install the phpMyAdmin package. This software is not available in the CentOS 6 default repositories. However, it is avialable in the EPEL repos (Extra Packages for Enterprise Linux). We can add access to the EPEL repositories to our system by typing:

#sudo yum install epel-release

After accepting the new repository, you can install the phpMyAdmin package by typing:

#sudo yum install phpmyadmin

This will install phpMyAdmin. We still must configure it though.

Step Four — Configure phpMyAdmin

Configure Apache Files: The phpMyAdmin package installs an Apache Virtual Host file that is used to configure web access. Open the file with the following command:

#vim /etc/httpd/conf.d/phpMyAdmin.conf

.....
Require ip your_workstation_IP_address
.....
Allow from your_workstation_IP_address
.....
Require ip your_workstation_IP_address
.....
Allow from your_workstation_IP_address

Save and close the file. You need to restart the server with the following command:

#sudo service httpd restart

Point your web browser to your VPS IP address followed by "/phpmyadmin"

#http://VPS_IP_address/phpmyadmin

After you provide the requested credentials, you will have access to the phpMyAdmin interface:

Details: Red Hat Certified System Administrator

An IT professional who has earned the Red Hat Certified System Administrator (RHCSA®) is able to perform the core system administration skills required in Red Hat Enterprise Linux environments. The credential is earned after successfully passing the Red Hat Certified System Administrator (RHCSA) Exam (EX200).

Certification details

Skill: Prove your skills and knowledge

1. A Red Hat® Certified System Administrator (RHCSA) is able to perform the following tasks:
2. Understand and use essential tools for handling files, directories, command-line environments, and documentation
3. Operate running systems, including booting into different run levels, identifying processes, starting and stopping virtual machines, and controlling services
4. Configure local storage using partitions and logical volumes
5. Create and configure file systems and file system attributes, such as permissions, encryption, access control lists, and network file systems
6. Deploy, configure, and maintain systems, including software installation, update, and core services
7. Manage users and groups, including use of a centralized directory for authentication
8. Manage security, including basic firewall and SELinux configuration

Audience: The RHCSA certification is designed for:

1. Experienced Red Hat Enterprise Linux system administrators seeking validation of their skills
2. Students who have attended Red Hat System Administration I and II and are on the path to earn RHCSA certification
3. Experienced Linux system administrators who require a certification either by their organization or based on a mandate (DOD 8570 directive)
4. IT professionals who are on the path to earn a Red Hat Certified Engineer (RHCE®) certification
5. RHCEs who are non-current or who are about to become non-current and wish to re-certify as RHCEs

Exam: Test your skills and knowledge

EX200 - Red Hat Certified System Administrator (RHCSA) examThe performance-based Red Hat Certified System Administrator (RHCSA) exam (EX200) tests your knowledge and skill in areas of system administration common across a wide range of environments and deployment scenarios. You must be an RHCSA to earn a Red Hat Certified Engineer (RHCE®) certification.

Training: The best way to learn is to do

In preparation to earn the Red Hat Certified System Administrator (RHCSA), Red Hat recommends the following:
For Windows system administrators

1. Red Hat System Administration I (RH124)
2. Red Hat System Administration II (RH134)

For Linux or UNIX administrators

1. RHCSA Rapid Track Course (RH199)

→ More Details: https://www.redhat.com/en/services/certification/rhcsa