Database

Database dipake buat nyimpen data yang butuh persistensi terstruktur — plugin (LuckPerms, EssentialsX, CoreProtect), web app, atau bot Discord.

AryaPanel nyediain MariaDB (kompatibel MySQL).

Bikin Database

1. Halaman server → tab Databases.
2. Klik New Database.
3. Isi:
   • Database name — nama pendek, misal survival, web.
   • Connections from — biarin default (%) supaya bisa diakses dari mana aja.
4. Klik Create Database.

Panel bakal ngasih:

Endpoint   : db.aryapanel.xyz:3306
Database   : s5_survival
Username   : u5_x8Kd8sK
Password   : (klik tombol mata untuk lihat)

Pake di Plugin (Contoh Minecraft)

LuckPerms — edit plugins/LuckPerms/config.yml:

storage-method: mysql

data:
  address: db.aryapanel.xyz:3306
  database: s5_survival
  username: u5_x8Kd8sK
  password: 'passwordDari Panel'

EssentialsX — edit plugins/Essentials/config.yml:

mysql:
  enabled: true
  url: jdbc:mysql://db.aryapanel.xyz:3306/s5_survival
  username: u5_x8Kd8sK
  password: 'passwordDariPanel'

Pake dari Bot / App Eksternal

Node.js (mysql2):

const mysql = require('mysql2/promise')

const db = await mysql.createConnection({
  host: 'db.aryapanel.xyz',
  port: 3306,
  user: 'u5_x8Kd8sK',
  password: process.env.DB_PASSWORD,
  database: 's5_survival',
})

Python (mysql-connector):

import mysql.connector

db = mysql.connector.connect(
    host="db.aryapanel.xyz",
    port=3306,
    user="u5_x8Kd8sK",
    password="passwordDariPanel",
    database="s5_survival",
)

Reset Password

Kalau password bocor atau lo lupa, klik tombol ↻ Rotate di sebelah password. Password lama langsung invalid, jangan lupa update di semua plugin/app yang pake.

Hapus Database

Klik ikon 🗑 di baris database yang mau dihapus, konfirmasi.

Gak bisa di-undo

Hapus database = data ilang selamanya. Backup dulu kalau perlu.

Backup Database

Dari SFTP / File Manager cari file .sql — atau pake tools eksternal:

mysqldump:

mysqldump -h db.aryapanel.xyz -P 3306 -u u5_x8Kd8sK -p s5_survival > backup.sql

Restore:

mysql -h db.aryapanel.xyz -P 3306 -u u5_x8Kd8sK -p s5_survival < backup.sql

Limit

Default tiap server dapet 2 database. Butuh lebih? Kontak admin lewat halaman Support.