Install phpMyAdmin on Centos 7 / Linux Tutorial
phpMyAdmin is a free web application which will make it easier working with MySQL, it will provide simple backup,restore and other MySQL GUI features, in this tutorial i will show you how to install phpMyAdmin on Centos, download phpMyAdmin, and this can be applies to localhost phpMyAdmin too.
Install phpMyAdmin on Centos 7
In this article i will be installing phpMyAdmin on CentOS 7, this can work on RHEL 7 and other flavors too.
Prerequisites:
Be sure that Apache httpd is installed
Latest epel release is installed by running: "EPEL Repository is an additional repo which will provide with a lot of extra packages to be installed with ease using yum"
rpm -iUvh http://dl.fedoraproject.org/pub/epel/...
Or
yum install epel-release
Be sure php 5.6 is installed
rpm -Uvh https://dl.fedoraproject.org/pub/epel...
rpm -Uvh https://mirror.webtatic.com/yum/el7/w...
yum install php56w php56w-opcache
Check if phpMyAdmin is available in your repo
yum search phpmyadmin
Install phpMyAdmin
yum install phpmyadmin -y
Secure and enable phpMyAdmin
Now we need to edit the phpMyAdmin configuration to enable specific IPs or all.
vi /etc/httpd/conf.d/phpMyAdmin.conf
Edit Require ip 127.0.0.1 parts in all sections
Example:
check below link:
https://goo.gl/scpDux
Allow all public access
Replace all "bracket" RequireAny "bracket" tags with:
check below link:
https://goo.gl/scpDux
URL: your-ip/phpmyadmin/
First phpMyAdmin login password
Password to be used with phpMyAdmin is your MySQL password, if you don't have a credentials please follow below steps to create root password
Login to server
Connect to MySQL
Run
use mysql;
update user set password=PASSWORD("mynewpassword") where User='root';
flush privileges ;
Replace above mynewpassword with your desired password.
On this page of the site you can watch the video online Install phpMyAdmin on Centos 7 / Linux Tutorial with a duration of hours minute second in good quality, which was uploaded by the user DotsWay 16 June 2017, share the link with friends and acquaintances, this video has already been watched 44,789 times on youtube and it was liked by 281 viewers. Enjoy your viewing!
