在 Linux VPS 上安装 MariaDB

MariaDB 适用于 Linux VPS 上的 Web 应用。

📋 前提条件

• Ubuntu 22.04+ or Debian 11+ Linux VPS with sudo
• At least 1 GB RAM (2 GB recommended for production)
• Open app ports in UFW if remote DB access is needed

Install MariaDB

Bash
1sudo apt update
2sudo apt install -y mariadb-server
3sudo systemctl enable --now mariadb

Secure the install

Set root password, remove anonymous users, disable remote root, drop test DB if unused.

Bash
1sudo mariadb-secure-installation

Create database and user

Bash
1sudo mariadb -e "CREATE DATABASE myapp CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;"
2sudo mariadb -e "CREATE USER 'myapp'@'localhost' IDENTIFIED BY 'StrongPassword!';"
3sudo mariadb -e "GRANT ALL PRIVILEGES ON myapp.* TO 'myapp'@'localhost';"
4sudo mariadb -e "FLUSH PRIVILEGES;"

Verify

Bash
1sudo mariadb -u myapp -p myapp -e "SHOW TABLES;"

---

祝部署顺利！🚀