Install SIMRS Khanza di server Ubuntu 20.04: Difference between revisions

From Dboswiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 6: Line 6:
  systemctl start apache2
  systemctl start apache2
  systemctl enable mariadb
  systemctl enable mariadb
=Persiapan database=
  mysql_secure_installation
  mysql_secure_installation
  Enter current password for root (enter for none):  
  Enter current password for root (enter for none):  
Line 15: Line 16:
  Remove test database and access to it? [Y/n] y
  Remove test database and access to it? [Y/n] y
  Reload privilege tables now? [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

Revision as of 14:30, 12 August 2024

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