Yadda ake Ƙara ƙarin Layer na Tsaro akan Interface Login PhpMyAdmin

MySQL shine tsarin sarrafa tushen tushen tushen bayanai da aka fi amfani dashi a duniya akan yanayin yanayin Linux kuma a lokaci guda sabbin sabbin Linux suna samun wahalar sarrafawa daga saurin MySQL.

An ƙirƙiri PhpMyAdmin, shine tushen yanar gizo na tushen MySQL aikace-aikacen sarrafa bayanai, wanda ke ba da hanya mai sauƙi ga sabbin Linux don yin hulɗa tare da MySQL ta hanyar haɗin yanar gizo. A cikin wannan labarin, za mu raba yadda ake amintar da phpMyAdmin dubawa tare da kariyar kalmar sirri akan tsarin Linux.

Kafin ku ci gaba da wannan labarin, muna ɗauka cewa kun kammala LAMP (Linux, Apache, MySQL/MariaDB, da PHP) da shigarwar PhpMyAdmin akan sabar Linux ɗin ku. Idan ba haka ba, zaku iya bin jagororin mu na ƙasa don shigar da tarin LAMP akan rabe-raben ku.

  1. Saka LAMP da PhpMyAdmin a cikin Cent/RHEL 7
  2. Shigar da LAMP da PhpMyAdmin a cikin Ubuntu 16.04
  3. Saka LAMP da PhpMyAdmin a cikin Fedora 22-24

Idan kuna son shigar da sabon sigar PhpMyAdmin, zaku iya bin wannan jagorar akan shigar da Sabbin PhpMyAdmin akan tsarin Linux.

Da zarar kun gama da waɗannan matakan da ke sama, kun shirya don farawa da wannan labarin.

Kawai ta ƙara waɗannan layukan zuwa /etc/apache2/sites-available/000-default.conf a cikin Debian ko /etc/httpd/conf/httpd.conf a cikin CentOS zai buƙaci ingantaccen tabbaci BAYAN tabbatar da keɓancewar tsaro amma KAFIN samun damar shiga. shafi.

Don haka, za mu ƙara ƙarin tsaro, wanda kuma takardar shaidar ta kare.

Ƙara waɗannan layin zuwa fayil ɗin sanyi na Apache (/etc/apache2/sites-available/000-default.conf ko /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>

Sannan yi amfani da htpasswd don samar da fayil ɗin kalmar sirri don asusun da za a ba da izini don shiga shafin shiga na phpmyadmin. Za mu yi amfani da /etc/apache2/.htpasswd da tecmint a wannan yanayin:

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

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

Shigar da kalmar wucewa sau biyu sannan canza izini da ikon mallakar fayil ɗin. Wannan don hana duk wanda baya cikin www-data ko rukunin apache samun damar karanta .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

Je zuwa http:///phpmyadmin kuma za ku ga maganganun tantancewa kafin shiga shafin shiga.

Kuna buƙatar shigar da takaddun shaidar ingantaccen asusu a /etc/apache2/.htpasswd ko /etc/httpd/.htpasswd don ci gaba:

Idan amincin ya yi nasara, za a kai ku zuwa shafin shiga na phpmyadmin.