Install SIMRS Khanza di server Ubuntu 20.04

Persiapan server

apt update
apt install apache2 mariadb-server php phpmyadmin
systemctl enable apache2
systemctl enable mariadb
systemctl start apache2
systemctl enable mariadb

Persiapan database

mysql_secure_installation
Enter current password for root (enter for none): 
Set root password? [Y/n] y
New password: 
Re-enter new password: 
Remove anonymous users? [Y/n] y
Disallow root login remotely? [Y/n] y
Remove test database and access to it? [Y/n] y
Reload privilege tables now? [Y/n] y

Setting database supaya bisa diakses dari komputer lain

nano /etc/mysql/mariadb.conf.d/50-server.cnf
Disable bind-address = 127.0.0.1 dengan cara tambah tanda # di depan barisnya
Kemudian disimpan

Atur user database

mysql -uroot -p
USE mysql
GRANT ALL PRIVILEGES ON *.* TO 'client' IDENTIFIED BY '123456' WITH GRANT OPTION;
FLUSH PRIVILEGES;
exit

Buat database sik

mysql -uroot -p
CREATE DATABASE sik;
exit

Download database dan install di mysql

wget -c https://github.com/mas-elkhanza/SIMRS-Khanza/blob/master/sik.sql