How To Install Phpmyadmin On Centos 7

In terms of practicality, managing MySQL data on a console is not recommended. Overotodo if you handle a lot of records and tables. For this, there are many professional solutions that can get us out of the problem, however, if the project is personal or is something small, you can use PhpMyAdmin. A solution well known in Linux và that fulfills its objective in an efficient and simple way. With this in mind, I will teach you how khổng lồ install the lademo PhpMyAdmin on a server using CentOS 7.

Bạn đang xem: How to install phpmyadmin on centos 7

PhpMyAdmin is an open source tool created with PHPhường to visualize & manage the data of a MySQL server in a graphical way. It has the tư vấn of a large community behind it & you can persize multiple operations on MySQL such as executing sentences, importing or exporting databases. Ahy vọng other things.

So, let us start.

1. Install Apache web VPS và PHP

Being a website tool, the first thing we have lớn vày is install the Apabịt web hệ thống. PhpMyAdmin also works with Ngnix quite efficiently. However, Apache is the easiest lớn use & works just as well.

- Advertisement -

So, open a terminal và run:

:~$ su:~# yum install httpd1.- Install apache

After that, it is necessary khổng lồ install PHPhường. Obviously, PHP.. is available in the official CentOS 7 repositories, the problem is that it is a very old version và PhpMyAdmin requires at least PHP 7.1. Then, you need to lớn install a recent version of PHP.

You can install PHP 7.2 on CentOS 7 easily using the steps shown in this post.

Then, you need khổng lồ install the PHP.. modules lớn work with PhpMyAdmin.

2.- Install PHP

Next, enable and start the Apache service.

:~# systemctl enable httpd:~# systemctl start httpdThen, enable Apađậy on the Firewall lớn allow access.

:~# firewall-cmd --add-service=http --permanent:~# firewall-cmd --reload3.- Firewall settings

To chạy thử if PHP is working, create a file called kiểm tra.php on /var/www/html/ with this content:

:~# yum install nano:~# nano /var/www/html/test.php

4.- PHPhường. info

So, open your website browser and go khổng lồ http://SERVER_IP/demo.php.

5.- PHPhường và Apache are working

So, Apache và PHPhường are working.

Xem thêm: Ldl Cholesterol, Hdl Là Gì ? &Bull; Hello Bacsi Chỉ Số Hdl Là Gì

2. Install và configure MariaDB

The next step is to lớn install MariaDB from the repositories. So it is pretty easy lớn vì.

:~# yum install mariadb-server6.- Install MariaDB

After that, enable & start it.

:~# systemctl enable mariadb:~# systemctl start mariadb7.- Start MariaDB

Next, configure MariaDB using the mysql_secure_installation script to phối a root password.

:~# mysql_secure_installation8.- Using mysql_secure_installation

You can answer the questions that come up as you lượt thích. However, I recommover that you read them properly lớn establish the best configuration for your server. In this case, I will respond as follows: Y, N, Y, Y.

3. Install PhpMyAdmin

At the time of writing this post, the lachạy thử stable version of PhpMyAdmin is 4.8.5 the easiest way khổng lồ install it is through the REXiaoMi MI repository.

So, install it.

:~# yum --enablerepo=rengươi install phpmyadmin9.- Install the lakiểm tra PhpMyAdmin

After that, open the PhpMyAdmin configuration tệp tin for apabít khổng lồ allow the connections khổng lồ it.

:~# nano /etc/httpd/conf.d/phpMyAdmin.confIn the IfModule mod_authz_core.c section, add

Require all granted.

10.- Edit the phpmyadmin configuration tệp tin for apache

Next, restart Apabịt.

:~# systemctl restart httpdAfter that, open your website browser & go to lớn http://SERVER_IP/phpmyadmin

11.- PHPMyAdmin

Log in with your user & enjoy!

12.- PhpMyAdmin start screen

That’s it.


PhpMyAdmin is a very useful tool to lớn manage MySQL data in a very simple way. It is không lấy phí, open source & perfectly compatible with your web servers.