Install SIMRS Khanza di server Ubuntu 20.04

From Dboswiki
Revision as of 14:30, 12 August 2024 by Smpdbos (talk | contribs)
Jump to navigation Jump to search

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