1. nano /etc/network/interfaces
auto enp0s3
iface enp0s3 inet dhcp
auto enp0s8
iface enp0s8 inet static
address 192.168.10.200/24
simpan ctrl + x lalu y (enter)
systemctl restart networking
2. apt update
3. apt install openssh-server
(buka terminal di client, dan ketikkan : sudo ssh -l smkmutu 192.168.10.200)
4. apt install mariadb-server
5. mysql_secure_installation
New password : 123456
Tekan y dan enter, begitu seterusnya
6. mysql -u root -p mysql
enter password : 123456
7. UPDATE user SET plugin = ' ' WHERE user = 'root';
8. flush privileges;
exit
9. apt-get install -y php php-cgi php-mysqli php-pear php-mbstring php-gettext libapache2-mod-php php-common php-phpseclib php-mysql
10. apt -y install apache2
11. apt install -y wget
12. export VER="4.9.1"
13. cd /tmp
14. wget
https://files.phpmyadmin.net/phpMyAdmin/${VER}/phpMyAdmin-${VER}-english.tar.gz
15. tar xvf phpMyAdmin-${VER}-english.tar.gz
16. rm phpMyAdmin*.gz
17. mv phpMyAdmin-* /usr/share/phpmyadmin
18. mkdir -p /var/lib/phpmyadmin/tmp
19. chown -R www-data:www-data /var/lib/phpmyadmin
20. mkdir /etc/phpmyadmin/
21. cp /usr/share/phpmyadmin/config.sample.inc.php
/usr/share/phpmyadmin/config.inc.php
22. nano /usr/share/phpmyadmin/config.inc.php
$cfg['blowfish_secret'] = 'H2OxcGXxflSd8JwrwVlh6KW6s2rER63i';
copykan perintah berikut paling bawah :
$cfg['TempDir'] = '/var/lib/phpmyadmin/tmp';
simpan ctrl + x lalu y (enter)
23. nano /etc/apache2/conf-enabled/phpmyadmin.conf
dan paste file berikut :
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>
simpan ctrl + x lalu y (enter)
24. systemctl restart apache2
25. ketik di browser client = 192.168.10.200/phpmyadmin
Lihat Videonya :