Otu esi etinye PhpMyAdmin kacha ọhụrụ na RHEL, CentOS & Fedora


Ọchịchị MySQL site na ahịrị iwu na Linux bụ ọrụ siri ike maka onye nchịkwa sistemụ ọhụrụ ọ bụla ma ọ bụ onye nchịkwa nchekwa data, n'ihi na ọ nwere ọtụtụ iwu nke anyị enweghị ike icheta na ndụ anyị kwa ụbọchị.

Iji mee ka nchịkwa MySQL dịkwuo mfe, anyị na-ewebata ngwa ọrụ nchịkwa MySQL nke a na-akpọ PhpMyAdmin, site n'enyemaka nke ngwá ọrụ a ị nwere ike ijikwa ma jikwaa nchịkwa nchekwa data gị site na ihe nchọgharị weebụ n'ụzọ dị mfe.

PhpMyAdmin bụ ntanetị dabere na webụ maka ijikwa ọdụ data MySQL/MariaDB nke ejiri dị ka nnọchi maka ngwa-akara iwu.

Edere ya n'asụsụ PHP, site na ngwa a ị nwere ike ịrụ ọrụ nchịkwa MySQL dị iche iche dị ka ịmepụta, dobe, gbanwee, ihichapụ, mbubata, mbupụ, chọọ, ajụjụ, nrụzi, bulie ma na-agba ọsọ njikwa nchekwa data ndị ọzọ site na ihe nchọgharị.

Dị ka ebe nrụọrụ weebụ ndị ọzọ ama ama maka ijikwa ọrụ sistemụ, ngwaọrụ okike blọọgụ, ma ọ bụ sistemụ njikwa ọdịnaya (CMS), ndị na-awakpo obi ọjọọ na-achọkarị iji enweghị usoro nchekwa na-emebu.

N'isiokwu a, anyị ga-egosi gị otu esi etinye PhpMyAdmin siri ike maka Apache ma ọ bụ Nginx na nkesa RHEL, CentOS na Fedora.

N'ebe a, anyị enyela ntinye nke PhpMyAdmin maka Apache ma ọ bụ Nginx nke sava weebụ. Yabụ, ọ dịịrị gị nke sava webụ ị ga-ahọrọ maka nrụnye.

Mana cheta na, ị ga-enwerịrị LAMP na-arụ ọrụ (Linux, Apache, PHP na MySQL/MariaDB) ma ọ bụ LEMP (Linux, Nginx, PHP na MySQL/MariaDB) ntọlite na sistemụ arụ ọrụ gị.

Ọ bụrụ na ịnweghị LAMP ma ọ bụ LEMP na-arụ ọrụ, ị nwere ike soro akụkọ anyị dị n'okpuru iji hazie.

  1. Wụnye ngwugwu LAMP na RHEL/CentOS 7/6 & Fedora 28-24

  1. Wụnye ngwugwu LEMP na RHEL/CentOS 7/6 & Fedora 28-24

Kwụpụ 1: Wụnye EPEL na Remi Repositories

1. Iji wụnye ụdị PhpMyAdmin kachasị ọhụrụ (ya bụ 4.8), ịkwesịrị ịwụnye ma mee ka EPEL na Remi repositories na nkesa Linux gị dị ka egosiri:

# 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. Ozugbo ị wụnyere n'elu repositories, ugbu a ọ bụ oge iji wụnye PhpMyAdmin na enyemaka nke na-esonụ iwu dị ka egosiri.

# yum --enablerepo=remi install phpmyadmin

Mara: Ọ bụrụ na ị na-eji PHP 5.4 na sistemụ RHEL/CentOS/Fedora, ị ga-agbarịrị iwu dị n'okpuru iji wụnye ya.

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

Na Apache ịkwesighi ịhazi ihe ọ bụla maka phpMyAdmin, n'ihi na ị ga-arụ ọrụ phpMyAdmin na-akpaghị aka na adreesị http:///phpmyadmin.

Isi faịlụ nhazi dị n'okpuru /etc/httpd/conf.d/phpMyAdmin.conf, jide n'aka na achọrọ ntụziaka niile enyere (Maka Apache 2.4) na Kwe ka agbakwunye adreesị IP n'ime ndekọ /usr/share/ phpmyadmin ngọngọ.

N'ikpeazụ, malitegharịa Apache ka itinye mgbanwe.

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

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

Na Nginx sava weebụ, anyị ga-emepụta njikọ ihe atụ na faịlụ nwụnye PhpMyAdmin na akwụkwọ ndekọ mgbọrọgwụ Nginx anyị (ya bụ /usr/share/nginx/html) site n'ịgba iwu na-esonụ:

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

N'ikpeazụ, malitegharịa Nginx na PHP-FPM ka itinye mgbanwe.

-------------- 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

Mepee ihe nchọgharị gị wee tụọ ihe nchọgharị gị na http:///phpmyadmin. Ọ kwesịrị imepe interface phpmyadmin (dị ka egosiri na foto dị n'okpuru).

N'isiokwu na-esote, anyị ga-ekekọrịta ụfọdụ ndụmọdụ iji chekwaa ntinye phpmyadmin gị na ngwugwu LAMP ma ọ bụ LEMP megide mwakpo ndị mmadụ na-emekarị.