Otu esi agbakwunye nchekwa nchekwa na PhpMyAdmin Login Interface

MySQL bụ sistemụ njikwa nchekwa data mepere emepe nke ụwa kachasị na sistemụ Linux yana n'otu oge ahụ ọ na-esiri ndị ọhụrụ Linux ike ijikwa site na MySQL ozugbo.

Emepụtara PhpMyAdmin, bụ ngwa njikwa nchekwa data MySQL dabere na weebụ, nke na-enye ụzọ dị mfe maka Linux newbies iji soro MySQL na-emekọrịta ihe site na interface webụ. N'isiokwu a, anyị ga-ekekọrịta otu esi echekwa phpMyAdmin interface na paswọọdụ chebe na sistemụ Linux.

Tupu ịga n'ihu na edemede a, anyị na-eche na ịmechaala LAMP (Linux, Apache, MySQL/MariaDB, na PHP) na ntinye PhpMyAdmin na sava Linux gị. Ọ bụrụ na ọ bụghị, ị nwere ike soro ntuziaka anyị dị n'okpuru ka ịwụnye ngwugwu LAMP na nkesa gị.

  1. Wụnye LAMP na PhpMyAdmin na Cent/RHEL 7
  2. Wụnye LAMP na PhpMyAdmin na Ubuntu 16.04
  3. Wụnye LAMP na PhpMyAdmin na Fedora 22-24

Ọ bụrụ na ịchọrọ ịwụnye ụdị PhpMyAdmin kachasị ọhụrụ, ị nwere ike iso ntuziaka a maka ịwụnye PhpMyAdmin kacha ọhụrụ na sistemụ Linux.

Ozugbo ịmechara usoro ndị a niile dị n'elu, ị dịla njikere ịmalite edemede a.

Naanị site n'ịgbakwunye ahịrị ndị a na /etc/apache2/sites-available/000-default.conf na Debian ma ọ bụ /etc/httpd/conf/httpd.conf na CentOS ga-achọ nkwenye bụ isi MGBE ekwenyesiri na nchekwa nchekwa mana tupu ịbanye na nbanye. ibe.

Yabụ, anyị ga na-agbakwunye nchekwa nchekwa, nke asambodo ahụ na-echekwa ya.

Tinye ahịrị ndị a na faịlụ nhazi Apache (/etc/apache2/sites-available/000-default.conf ma ọ bụ /etc/httpd/conf/httpd.conf):

<Directory /usr/share/phpmyadmin>
    AuthType Basic
    AuthName "Restricted Content"
    AuthUserFile /etc/apache2/.htpasswd
    Require valid-user
</Directory>

 
<Directory /usr/share/phpmyadmin>
    AuthType Basic
    AuthName "Restricted Content"
    AuthUserFile /etc/httpd/.htpasswd
    Require valid-user
</Directory>

Wee jiri htpasswd mepụta faịlụ paswọọdụ maka akaụntụ nke a ga-enye ikike ịnweta ibe nbanye phpmyadmin. Anyị ga-eji /etc/apache2/.htpasswd na tecmint na nke a:

---------- On Ubuntu/Debian Systems ---------- 
# htpasswd -c /etc/apache2/.htpasswd tecmint

---------- On CentOS/RHEL Systems ---------- 
# htpasswd -c /etc/httpd/.htpasswd tecmint

Tinye paswọọdụ ugboro abụọ wee gbanwee ikike na nwe faịlụ ahụ. Nke a bụ iji gbochie onye ọ bụla na-anọghị na www-data ma ọ bụ otu apache inwe ike ịgụ .htpasswd:

# chmod 640 /etc/apache2/.htpasswd

---------- On Ubuntu/Debian Systems ---------- 
# chgrp www-data /etc/apache2/.htpasswd 

---------- On CentOS/RHEL Systems ---------- 
# chgrp apache /etc/httpd/.htpasswd

Gaa na http:///phpmyadmin ma ị ga-ahụ mkparịta ụka nyocha tupu ịbanye na ibe nbanye.

Ị ga-achọ itinye nzere nke akaụntụ ziri ezi na /etc/apache2/.htpasswd ma ọ bụ /etc/httpd/.htpasswd iji gaa n'ihu:

Ọ bụrụ na nyocha ahụ aga nke ọma, a ga-akpọrọ gị gaa na ibe nbanye phpmyadmin.