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:

How To Install MySQL in Linux

Install MySQL:

1. To install MySQL, open terminal and type below 1st command.
2. Once it is done installing, you can set a root MySQL password using 2nd command.
3. Once it installs, you can start MySQL running using 3rd command.
4. Now run 4th command to ensure run service from boot.

1. #sudo yum install mysqld

2. #sudo /usr/bin/mysql_secure_installation

The prompt will ask you for your current root password. Since you just installed MySQL, you most likely won’t have one, so leave it blank by pressing enter. Then the prompt will ask you if you want to set a root password. Go ahead and choose Y and follow the instructions. It’s easiest just to say Yes to all the options. At the end, MySQL will reload and implement the new changes.

3. #sudo service mysqld start

4. #sudo chkconfig mysqld on

→ Learn More: How To Install Apache (httpd) in Linux
→ Learn More: How To Install and phpMyAdmin in Linux