Install Mariadb dan phpmyadmin di Debian 10

Assalamualaikum Wr Wb.

phpMyAdmin adalah perangkat lunak bebas yang ditulis dalam bahasa pemrograman PHP yang digunakan untuk menangani administrasi MySQL melalui website Jejaring Jagat Jembar (World Wide Web) . phpMyAdmin mendukung berbagai operasi MySQL, diantaranya (mengelola basis data, tabel-tabel, bidang (fields), relasi (relations), indeks, pengguna (users), perizinan (permissions), dan lain-lain).^[1]

1.Install PHP.

#sudo apt-get install -y php php-cgi php-mysqli php-pear php-mbstring php-gettext 

libapache2-mod-php php-common php-phpseclib php-mysql

2.Install Mariadb.

#sudo apt -y install mariadb-server mariadb-client 

3.Masuk ke mariadb

#mysql -u root -p

#CREATE USER 'nama_user' IDENTIFIED BY 'password' ; //untuk membuat akun login ke phpmyadmin 

4.Install Apache.
#sudo apt install apache2

5.Install PHPMYADMIN: 

#sudo apt-get install -y wget
#export VER="4.9.0.1"
#cd /tmp 

#wget https://files.phpmyadmin.net/phpMyAdmin/${VER}/phpMyAdmin-${VER}-all-languages.tar.gz

6.Ekstrak file tersebut dengan perintah.

#tar xvf phpMyAdmin-${VER}-all-languages.tar.gz 

7.Pindahkan folder yang dihasilkan ke folder / usr / share / phpmyadmin

#rm phpMyAdmin*.gz
#sudo mv phpMyAdmin-* /usr/share/phpmyadmin

#sudo mkdir -p /var/lib/phpmyadmin/tmp
#sudo chown -R www-data:www-data /var/lib/phpmyadmin 

8.Copy file.

#sudo cp /usr/share/phpmyadmin/config.sample.inc.php  /usr/share/phpmyadmin/config.inc.php

9.Edit File config.inc.php

$cfg['blowfish_secret'] = 'H2OxcGXxflSd8JwrwVlh6KW6s2rER63i';  

$cfg['TempDir'] = '/var/lib/phpmyadmin/tmp';

10.Buat file untuk phpmyadmin di apache2

#sudo nano /etc/apache2/conf-enabled/phpmyadmin.conf

11. Isi dengan :

-----------------------------------------------------------------------------------
Alias /phpmyadmin /usr/share/phpmyadmin

<Directory /usr/share/phpmyadmin>
    Options SymLinksIfOwnerMatch
    DirectoryIndex index.php

    <IfModule mod_php5.c>
        <IfModule mod_mime.c>
            AddType application/x-httpd-php .php
        </IfModule>
        <FilesMatch ".+\.php$">
            SetHandler application/x-httpd-php
        </FilesMatch>

        php_value include_path .
        php_admin_value upload_tmp_dir /var/lib/phpmyadmin/tmp
        php_admin_value open_basedir /usr/share/phpmyadmin/:/etc/phpmyadmin/:/var/lib/phpmyadmin/:/usr/share/php/php-gettext/:/usr/share/php/php-php-gettext/:/usr/share/javascript/:/usr/share/php/tcpdf/:/usr/share/doc/phpmyadmin/:/usr/share/php/phpseclib/
        php_admin_value mbstring.func_overload 0
    </IfModule>
    <IfModule mod_php.c>
        <IfModule mod_mime.c>
            AddType application/x-httpd-php .php
        </IfModule>
        <FilesMatch ".+\.php$">
            SetHandler application/x-httpd-php
        </FilesMatch>

        php_value include_path .
        php_admin_value upload_tmp_dir /var/lib/phpmyadmin/tmp
        php_admin_value open_basedir /usr/share/phpmyadmin/:/etc/phpmyadmin/:/var/lib/phpmyadmin/:/usr/share/php/php-gettext/:/usr/share/php/php-php-gettext/:/usr/share/javascript/:/usr/share/php/tcpdf/:/usr/share/doc/phpmyadmin/:/usr/share/php/phpseclib/
        php_admin_value mbstring.func_overload 0
    </IfModule>

</Directory>

# Authorize for setup
<Directory /usr/share/phpmyadmin/setup>
    <IfModule mod_authz_core.c>
        <IfModule mod_authn_file.c>
            AuthType Basic
            AuthName "phpMyAdmin Setup"
            AuthUserFile /etc/phpmyadmin/htpasswd.setup
        </IfModule>
        Require valid-user
    </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>
<Directory /usr/share/phpmyadmin/setup/lib>
    Require all denied
</Directory>

-----------------------------------------------------------------------------------------------------

12.


13.Restart apache2.

#sudo systemctl restart apache2

Beri IP dan hostname debian ke hosts di laptop

14.Cek Ke browser.

 

 
15.Done....

Referensi:

https://computingforgeeks.com/install-phpmyadmin-with-apache-on-debian-10-buster/ 

https://www.duniailkom.com/tutorial-belajar-mysql-cara-membuat-dan-menghapus-user-mysql-create-user/