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