Bii o ṣe le Fikun Layer Afikun ti Aabo lori Ọlọpọọmíwọwọ Wiwọle PhpMyAdmin

MySQL ni agbaye iṣakoso ṣiṣi orisun ṣiṣi orisun agbaye ti o lo julọ lori ilolupo eda abemiyede Linux ati ni akoko kanna Awọn tuntun tuntun Linux nira fun lati ṣakoso lati iyara MySQL.

Ti ṣẹda PhpMyAdmin, jẹ orisun orisun data MySQL ti o ṣakoso wẹẹbu ti o ṣakoso ohun elo, eyiti o pese ọna ti o rọrun fun awọn tuntun Linux lati ṣe ajọṣepọ pẹlu MySQL nipasẹ wiwo wẹẹbu kan. Ninu nkan yii, a yoo pin bi o ṣe le ni aabo wiwo phpMyAdmin pẹlu aabo ọrọigbaniwọle lori awọn eto Linux.

Ṣaaju ki o to lọ siwaju pẹlu nkan yii, a ro pe o ti pari LAMP (Linux, Apache, MySQL/MariaDB, ati PHP) ati fifi sori ẹrọ PhpMyAdmin lori olupin Linux rẹ. Ti kii ba ṣe bẹ, o le tẹle awọn itọsọna isalẹ wa lati fi akopọ LAMP sori awọn pinpin tirẹ ..

  1. Fi atupa ati PhpMyAdmin sii ni Ogorun/RHEL 7
  2. Fi atupa ati PhpMyAdmin sori Ubuntu 16.04
  3. Fi atupa ati PhpMyAdmin sori Fedora 22-24

Ti o ba fẹ lati fi ẹya tuntun ti PhpMyAdmin sori ẹrọ, o le tẹle itọsọna yii lori fifi sori ẹrọ PHpMyAdmin Tuntun lori awọn ọna ṣiṣe Linux.

Lọgan ti o ba ti pari pẹlu gbogbo awọn igbesẹ loke, o ti ṣetan lati bẹrẹ pẹlu nkan yii.

Kan nipa fifi awọn ila wọnyi si /etc/apache2/sites-available/000-default.conf ni Debian tabi /etc/httpd/conf/httpd.conf ni CentOS yoo nilo ijẹrisi ipilẹ LEHIN ti o jẹrisi iyasọtọ aabo ṣugbọn Ṣaaju ki o to wọle si iwọle naa iwe.

Nitorinaa, a yoo ṣe afikun Layer ti aabo, tun ni aabo nipasẹ ijẹrisi naa.

Ṣafikun awọn ila wọnyi si faili iṣeto Apache (/etc/apache2/sites-available/000-default.conf or /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>

Lẹhinna lo htpasswd lati ṣe agbekalẹ faili ọrọigbaniwọle fun akọọlẹ kan ti yoo gba aṣẹ lati wọle si oju-iwe iwọle phpmyadmin. A yoo lo /etc/apache2/.htpasswd ati tecmint ninu ọran yii:

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

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

Tẹ ọrọ igbaniwọle sii lẹẹmeji ati lẹhinna yi awọn igbanilaaye ati nini ti faili sii. Eyi ni lati ṣe idiwọ ẹnikẹni ti ko si ni www-data tabi ẹgbẹ afun lati ni anfani lati ka .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

Lọ si http:// /phpmyadmin ati pe iwọ yoo wo ibanisọrọ ijẹrisi ṣaaju ki o to wọle si oju-iwe iwọle.

Iwọ yoo nilo lati tẹ awọn iwe eri ti akọọlẹ to wulo ni /etc/apache2/.htpasswd tabi /etc/httpd/.htpasswd lati le tẹsiwaju:

Ti ijẹrisi naa ba ṣaṣeyọri, ao mu ọ lọ si oju-iwe iwọle phpmyadmin.