VPS Guide: Your Go-To for VPS, Ubuntu & Command Line Success

Install Arch Linux MariaDB

Category: VPS Setup

Set up MariaDB—a MySQL alternative—on an Arch Linux VPS—update with

pacman -Syu

install with

pacman -S mariadb

and initialize with

mariadb-install-db --user=mysql --basedir=/usr

Start with

systemctl start mariadb

enable with

systemctl enable mariadb

Secure with

mysql_secure_installation

—set root password (e g M@r1aArch!) Open port with

iptables -A INPUT -p tcp --dport 3306 -j ACCEPT

On Vultr test with

mysql -u root -p

—expect \"MariaDB>\" Add phpMyAdmin with Nginx—ensures uptime with lean resource use (~30MB)