Database

Setup MySQL / MariaDB di VPS

Install database MySQL/MariaDB, amankan instalasi, dan buat database + user pertama Anda.

MySQL MariaDB SQL Ubuntu

1 Install

bash

sudo apt update
sudo apt install -y mariadb-server
sudo systemctl enable --now mariadb

2 Amankan Instalasi

bash

sudo mysql_secure_installation

Set password root, hapus user anonim, dan nonaktifkan login root jarak jauh.

3 Buat Database & User

sql

CREATE DATABASE aplikasi;
CREATE USER 'appuser'@'localhost' IDENTIFIED BY 'password_kuat';
GRANT ALL PRIVILEGES ON aplikasi.* TO 'appuser'@'localhost';
FLUSH PRIVILEGES;