Yadda ake Sanya Sabbin PhpMyAdmin a cikin RHEL, CentOS & Fedora


Sarrafa MySQL ta hanyar layin umarni a cikin Linux aiki ne mai wahala ga kowane mai gudanar da tsarin sabonbie ko mai gudanar da bayanai, saboda yana ƙunshe da umarni da yawa waɗanda ba za mu iya tunawa a rayuwarmu ta yau da kullun ba.

Don sauƙaƙe gudanarwar MySQL muna gabatar da kayan aikin sarrafa MySQL na yanar gizo mai suna PhpMyAdmin, tare da taimakon wannan kayan aikin zaku iya sarrafawa da sarrafa sarrafa bayanan ku ta hanyar burauzar yanar gizo cikin sauƙi.

PhpMyAdmin shine tushen yanar gizo don sarrafa bayanan MySQL/MariaDB wanda ake amfani dashi azaman maye gurbin abubuwan amfani-layi.

An rubuta shi a cikin harshen PHP, ta wannan aikace-aikacen za ku iya yin ayyuka daban-daban na gudanarwa na MySQL kamar su ƙirƙira, sauke, canza, sharewa, shigo da kaya, bincike, bincike, gyara, ingantawa da gudanar da sauran umarnin sarrafa bayanai ta hanyar browser.

Kamar yadda sauran sanannun musaya na tushen yanar gizo don gudanar da ayyukan tsarin, kayan aikin samar da bulogi, ko tsarin sarrafa abun ciki (CMSs), sau da yawa maharan da ke neman yin amfani da rashin matakan tsaro na yau da kullun ne ke kaiwa hari.

A cikin wannan labarin za mu nuna muku yadda ake shigar da sabon ingantaccen sigar PhpMyAdmin don Apache ko Nginx akan rarraba RHEL, CentOS da Fedora.

Anan mun samar da shigarwar PhpMyAdmin don duka sabar yanar gizo ta Apache ko Nginx. Don haka, ya rage gare ku wace sabar gidan yanar gizo za ku zaɓi don shigarwa.

Amma ka tuna cewa, dole ne ka shigar da saitin LAMP (Linux, Apache, PHP da MySQL/MariaDB) ko LEMP (Linux, Nginx, PHP da MySQL/MariaDB) saitin tsarin aikin ku.

Idan ba ku da LAMP ko LEMP mai aiki, kuna iya bin labaran mu na ƙasa don saitawa.

  1. Shigar da Tarin LAMP akan RHEL/CentOS 7/6 & Fedora 28-24

  1. Saka Tarin LEMP akan RHEL/CentOS 7/6 & Fedora 28-24

Mataki 1: Sanya EPEL da Remi Repositories

1. Don shigar da mafi kwanan nan na PhpMyAdmin (watau 4.8), kuna buƙatar shigar da kunna EPEL da Remi ma'ajiyar a kan rarraba Linux ɗin ku kamar yadda aka nuna:

# yum install epel-release
# rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-7.rpm 
-------------- On RHEL/CentOS 6 - 32-bit --------------
# yum install epel-release
# rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm

-------------- On RHEL/CentOS 6 - 64-bit --------------
# yum install epel-release
# rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm
# rpm -Uvh http://rpms.famillecollet.com/fedora/remi-release-28.rpm   [On Fedora 28]
# rpm -Uvh http://rpms.famillecollet.com/fedora/remi-release-27.rpm   [On Fedora 27]
# rpm -Uvh http://rpms.famillecollet.com/fedora/remi-release-26.rpm   [On Fedora 26]
# rpm -Uvh http://rpms.famillecollet.com/fedora/remi-release-25.rpm   [On Fedora 25]
# rpm -Uvh http://rpms.famillecollet.com/fedora/remi-release-24.rpm   [On Fedora 24]

2. Da zarar kun shigar a sama da ma'ajiyar, yanzu lokaci ya yi da za ku shigar da PhpMyAdmin tare da taimakon bin umarni kamar yadda aka nuna.

# yum --enablerepo=remi install phpmyadmin

Lura: Idan kuna amfani da PHP 5.4 akan tsarin RHEL/CentOS/Fedora, to kuna buƙatar aiwatar da umarnin da ke ƙasa don shigar da shi.

# yum --enablerepo=remi,remi-test install phpmyadmin

A cikin Apache ba kwa buƙatar saita wani abu don phpMyAdmin, saboda zaku sami aiki phpMyAdmin ta atomatik a adireshin http:///phpmyadmin.

Babban fayil ɗin sanyi yana ƙarƙashin /etc/httpd/conf.d/phpMyAdmin.conf, tabbatar da Bukatar duk umarnin da aka bayar (Don Apache 2.4) kuma An ƙara Ba da izini daga adireshin ip a cikin Directory /usr/share/ phpmyadmin toshe.

A ƙarshe, sake kunna Apache don aiwatar da canje-canje.

-------------- On RHEL/CentOS 7 and Fedora 28-24 --------------
# systemctl restart httpd

-------------- On RHEL/CentOS 6 --------------
# service httpd restart

A kan uwar garken gidan yanar gizo na Nginx, za mu ƙirƙiri hanyar haɗi ta alama zuwa fayilolin shigarwa na PhpMyAdmin zuwa tushen tushen takaddun gidan yanar gizon mu na Nginx (watau /usr/share/nginx/html) ta hanyar aiwatar da umarni mai zuwa:

# ln -s /usr/share/phpMyAdmin /usr/share/nginx/html

A ƙarshe, sake kunna Nginx da PHP-FPM don aiwatar da canje-canje.

-------------- On RHEL/CentOS 7 and Fedora 28-24 --------------
# systemctl restart nginx
# systemctl restart php-fpm

-------------- On RHEL/CentOS 6 --------------
# service nginx restart
# service php-fpm restart

Bude burauzar ku kuma ku nuna burauzar ku zuwa http:///phpmyadmin. Ya kamata ya buɗe phpmyadmin interface (kamar yadda aka nuna a hoton da ke ƙasa).

A cikin kasidu masu zuwa, za mu raba wasu nasihohi don tabbatar da shigar phpmyadmin ɗinku a kan ɗimbin LAMP ko LEMP akan mafi yawan hare-haren da mugayen mutane ke kaiwa.