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
Or
yum install epel-release
Be sure php 5.6 is installed
rpm -Uvh
rpm -Uvh
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:
Allow all public access
Replace all “bracket” RequireAny “bracket” tags with:
check below link:
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.
Tag: phpmyadmin centos 7, install phpmyadmin on linux, phpmyadmin, install phpmyadmin, install phpmyadmin ubuntu, phpmyadmin install, linux phpmyadmin, install phpmyadmin linux, linux install phpmyadmin, localhost phpmyadmin, install phpmyadmin centos 7, install phpmyadmin centos, how to use phpmyadmin, phpmyadmin download, how to install phpmyadmin, what is phpmyadmin, download phpmyadmin, 127.0 0.1 phpmyadmin, tutorial, how to, phpmyadmin tutorial
Xem Thêm Bài Viết Về Mobile Khác: https://thoidaicongnghe.com/mobile
Nguồn: https://thoidaicongnghe.com