Prerequisites (Prasyarat) Topologi Jaringan Gambar Topologi Jaringan   Konfigurasi Server dan Client Konfigurasi Server : ————————————————– – Sistem Operasi : Linux Debian (10/11) – IP Address NIC 1 : DHCP Internet – Gateway : DHCP Internet – Hostname : ns100 (Gantilah angka 100 dengan nomer absen anda masing-masing) – Domain : sekolah100.sch.id (Gantilah angka 100 dengan nomer absen anda masing-masing) – IP Address NIC 2 : 192.168.100.1/24 (Gantilah angka 100 dengan nomer absen anda masing-masing) Konfigurasi Client : ————————————————– – Sistem Operasi : Windows – IP Address : DHCP   Seting Server DHCP Server Pastikan instalasi dan konfigurasi DHCP server sudah berjalan dengan baik DNS Server Pastikan instalasi dan konfigurasi DNS server sudah berjalan dengan baik WEB Server Pastikan instalasi dan konfigurasi WEB server sudah berjalan dengan baik   Instalasi dan Konfigurasi Database Server Install paket Database Server Login sebagai user root login as: root root@192.168.100.1’s password: Linux ns100 4.19.0-17-amd64 #1 SMP Debian 4.19.194-3 (2022-01-12) x86_64 The programs included with the Debian GNU/Linux system are free software; the exact distribution terms for each program are described in the individual files in /usr/share/doc/*/copyright. Instal paket Database server root@ns100:~# apt install mariadb-server mariadb-client php-mysql Reading package lists… Done Building dependency tree Reading state information… Done The following additional packages will be installed: galera-3 gawk libaio1 libcgi-fast-perl libcgi-pm-perl libconfig-inifiles-perl libdbd-mysql-perl libdbi-perl libencode-locale-perl libfcgi-perl libhtml-parser-perl libhtml-tagset-perl libhtml-template-perl libhttp-date-perl libhttp-message-perl libio-html-perl liblwp-mediatypes-perl libmariadb3 libmpfr6 libreadline5 libsigsegv2 libsnappy1v5 libterm-readkey-perl libtimedate-perl liburi-perl mariadb-client-10.3 mariadb-client-core-10.3 mariadb-common mariadb-server-10.3 mariadb-server-core-10.3 mysql-common php7.3-mysql rsync socat Suggested packages: gawk-doc libclone-perl libmldbm-perl libnet-daemon-perl libsql-statement-perl libdata-dump-perl libipc-sharedcache-perl libwww-perl mailx mariadb-test netcat-openbsd tinyca The following NEW packages will be installed: galera-3 gawk libaio1 libcgi-fast-perl libcgi-pm-perl libconfig-inifiles-perl libdbd-mysql-perl libdbi-perl libencode-locale-perl libfcgi-perl libhtml-parser-perl libhtml-tagset-perl libhtml-template-perl libhttp-date-perl libhttp-message-perl libio-html-perl liblwp-mediatypes-perl libmariadb3 libmpfr6 libreadline5 libsigsegv2 libsnappy1v5 libterm-readkey-perl libtimedate-perl liburi-perl mariadb-client mariadb-client-10.3 mariadb-client-core-10.3 mariadb-common mariadb-server mariadb-server-10.3 mariadb-server-core-10.3 mysql-common php-mysql php7.3-mysql rsync socat 0 upgraded, 37 newly installed, 0 to remove and 0 not upgraded. Need to get 22.5 MB of archives. After this operation, 171 MB of additional disk space will be used. Do you want to continue? [Y/n]y Get:1 http://mirror.smkn1klaten.sch.id/debian buster/main amd64 libmpfr6 amd64 4.0.2-1 [775 kB] Get:2 http://mirror.smkn1klaten.sch.id/debian buster/main amd64 libsigsegv2 amd64 2.12-2 [32.8 kB] Get:3 http://mirror.smkn1klaten.sch.id/debian buster/main amd64 gawk amd64 1:4.2.1+dfsg-1 [660 kB] Setting up libcgi-fast-perl (1:2.13-1) … Setting up mariadb-server (1:10.3.31-0+deb10u1) … Processing triggers for libapache2-mod-php7.3 (7.3.31-1~deb10u1) … Processing triggers for systemd (241-7~deb10u8) … Processing triggers for man-db (2.8.5-2) … Processing triggers for libc-bin (2.28-10) … root@ns100:~#   Konfigurasi MySQL Seting Database MySQL (User, Password, Database) Memberikan Privileges (hak akses) kepada user root untuk dapat mengelola seluruh database.user login : rootpassword : paswdroot root@ns100:~# mysql -u root Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 49 Server version: 10.3.31-MariaDB-0+deb10u1 Debian 10 Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement. MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY “paswdroot”; Query OK, 0 rows affected (0.001 sec) MariaDB [(none)]> quit   Instalasi dan Konfigurasi phpMyAdmin Download phpMyAdmin Versi 5.1.2 root@ns100:~# wget https://files.phpmyadmin.net/phpMyAdmin/5.1.2/phpMyAdmin-5.1.2-all-languages.zip –2022-01-28 19:10:21– https://files.phpmyadmin.net/phpMyAdmin/5.1.2/phpMyAdmin-5.1.2-all-languages.zip Resolving files.phpmyadmin.net (files.phpmyadmin.net)… 89.187.162.142, 89.187.162.137, 89.187.162.133, … Connecting to files.phpmyadmin.net (files.phpmyadmin.net)|89.187.162.142|:443… connected. HTTP request sent, awaiting response… 200 OK Length: 13805161 (13M) [application/zip] Saving to: ‘phpMyAdmin-5.1.2-all-languages.zip’ phpMyAdmin-5.1.2-all-languages.z 100%[=========================================================] 13.17M 1.87MB/s in 8.2s 2022-01-28 19:10:36 (1.60 MB/s) – ‘phpMyAdmin-5.1.2-all-languages.zip’ saved [13805161/13805161]   Install aplikasi unzip root@ns100:~# apt install unzip Reading package lists… Done Building dependency tree Reading state information… Done Suggested packages: zip The following NEW packages will be installed: unzip 0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded. Need to get 172 kB of archives. After this operation, 580 kB of additional disk space will be used. Get:1 http://mirror.smkn1klaten.sch.id/debian buster/main amd64 unzip amd64 6.0-23+deb10u2 [172 kB] Fetched 172 kB in 10s (16.8 kB/s) Selecting previously unselected package unzip. (Reading database … 30006 files and directories currently installed.) Preparing to unpack …/unzip_6.0-23+deb10u2_amd64.deb … Unpacking unzip (6.0-23+deb10u2) … Setting up unzip (6.0-23+deb10u2) … Processing triggers for mime-support (3.62) … Processing triggers for man-db (2.8.5-2) …   Ekstrak file phpMyAdmin hasil download menggunakan apliaksi unzip root@ns100:~# unzip phpMyAdmin-5.1.2-all-languages.zip inflating: phpMyAdmin-5.1.2-all-languages/vendor/williamdes/mariadb-mysql-kbs/README.md inflating: phpMyAdmin-5.1.2-all-languages/vendor/williamdes/mariadb-mysql-kbs/composer.json creating: phpMyAdmin-5.1.2-all-languages/vendor/williamdes/mariadb-mysql-kbs/dist/ inflating: phpMyAdmin-5.1.2-all-languages/vendor/williamdes/mariadb-mysql-kbs/dist/merged-ultraslim.json creating: phpMyAdmin-5.1.2-all-languages/vendor/williamdes/mariadb-mysql-kbs/src/ inflating: phpMyAdmin-5.1.2-all-languages/vendor/williamdes/mariadb-mysql-kbs/src/KBDocumentation.php inflating: phpMyAdmin-5.1.2-all-languages/vendor/williamdes/mariadb-mysql-kbs/src/KBEntry.php inflating: phpMyAdmin-5.1.2-all-languages/vendor/williamdes/mariadb-mysql-kbs/src/KBException.php inflating: phpMyAdmin-5.1.2-all-languages/vendor/williamdes/mariadb-mysql-kbs/src/Search.php inflating: phpMyAdmin-5.1.2-all-languages/vendor/williamdes/mariadb-mysql-kbs/src/SlimData.php inflating: phpMyAdmin-5.1.2-all-languages/yarn.lock root@ns100:~#   Pindahkan folder hasil ekstrak phpMyAdmin ke folder default dari http (dari folder phpMyAdmin-5.1.2-all-languages menjadi folder phpmyadmin). Serta Copy file config.sample.inc.php menjadi config.inc.php root@ns100:~# mv phpMyAdmin-5.1.2-all-languages /var/www/html/http/phpmyadmin root@ns100:~# cp /var/www/html/http/phpmyadmin/config.sample.inc.php /var/www/html/http/phpmyadmin/config.inc.php   Masukan kode blowfish_secret  ‘RfMd2oX7L7vT9Ls6fkuM0KwY;9gcho3C’   ke dalam file config.inc.php root@ns100:~# nano /var/www/html/http/phpmyadmin/config.inc.php $cfg[‘blowfish_secret’] = ‘RfMd2oX7L7vT9Ls6fkuM0KwY;9gcho3C’; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */   Buat folder tmp di dalam folder phpmyadmin kemudian rubah kepemilkannya ke user www-data root@ns100:~# mkdir /var/www/html/http/phpmyadmin/tmp root@ns100:~# chown -R www-data:www-data /var/www/html/http/phpmyadmin   Restart service apache2 root@ns100:~# /etc/init.d/apache2 restart [ ok ] Restarting apache2 (via systemctl): apache2.service.   Pengujian di client Gbr.01 Akses phpMyAdmin   Gbr.01 Akses phpMyAdmin menggunakan user root     Kesimpulan Selamat! akhirnya kita telah belajar dan berhasil melakukan instalasi dan konfigurasi Database Server    

phpMyAdmin  phpMyAdmin adalah aplikasi web untuk mengelola database MySQL dan database MariaDB dengan lebih mudah melalui antarmuka (interface)grafis.

Hampir semua perusahaan, organisasi, instansi dan industri menggunakan database sebagai penunjang aplikasi dan sistim bisnis mereka. Begitu pentingnya database sehingga hampir semua Aplikasi menggunakannya. Beberapa fungsi dari database antara lain :

Terdapat 12 tipe database, antara lain yaitu : Operational database Database ini menyimpan data rinci yang diperlukan untuk mendukung operasi dari seluruh organisasi. Mereka juga disebut subject-area databases (SADB), transaksi database, dan produksi database.

Manfaat utama dalam pengelolaaan database adalah agar dapat menemukan kembali data yang dicari dengan mudah dan cepat. Beberapa keunggulan dari pemanfaatan database adalah sebagai berikut: