MENGIZINKAN AKSES PHP MY ADMIN DARI IP TERTENTU

 

Untuk meningkatkan keamanan server dan mysql kadang kita perlu membatasi akses ke phpmyadmin hanya dari ip tertentu saja, Cara ini sudah saya praktekkan di server ubuntu 24.04 dengan PHP 8, apache 2 dan mysql Ver 8.0.43-0ubuntu0.24.04.1, berikut cara mengkonfigurasinya, tambahkan kode ini setelah baris AllowOverride All, lihat yang berwarna merah

Order Deny,Allow
 Deny from All
 Allow from 10.10.1.130, 110.136.86.170

sudo nano /etc/apache2/conf-available/phpmyadmin.conf

Alias /phpmyadmin /usr/share/phpmyadmin
<Directory /usr/share/phpmyadmin>
    Options SymLinksIfOwnerMatch
     DirectoryIndex index.php
       AllowOverride All
        Order Deny,Allow
          Deny from All
           Allow from 10.10.1.130, 110.136.86.170

    # limit libapache2-mod-php to files and directories necessary by pma
    <IfModule mod_php7.c>
        php_admin_value upload_tmp_dir /var/lib/phpmyadmin/tmp
         php_admin_value open_basedir /usr/share/phpmyadmin/:/usr/share/doc/phpmyadmin/:/etc/phpmyadmin/:/var/lib/phpmyadmin/:/usr/share/php/:/usr/sha>    </IfModule>
    # PHP 8+
    <IfModule mod_php.c>
        php_admin_value upload_tmp_dir /var/lib/phpmyadmin/tmp
         php_admin_value open_basedir /usr/share/phpmyadmin/:/usr/share/doc/phpmyadmin/:/etc/phpmyadmin/:/var/lib/phpmyadmin/:/usr/share/php/:/usr/sha>    Require ip 10.10.12.11
    </IfModule>
</Directory>

# Disallow web access to directories that don't need it
   <Directory /usr/share/phpmyadmin/templates>
      Require all denied
       </Directory>

<Directory /usr/share/phpmyadmin/libraries>
    Require all denied
    </Directory>