Web Hosting & VPS Tips

Unleash Your Server Potential with Expert Insights

Hosting provided by: Cloudways
Free to Try! Up to 40% Off!

Category: VPS Setup

Set up MariaDB—a MySQL fork—on a Fedora VPS—install with
dnf install mariadb-server -y
start with
systemctl start mariadb
and enable with
systemctl enable mariadb
Secure it via
mysql_secure_installation
—set root password (e g M@r1aF3d!) remove test DBs Open port with
firewall-cmd --add-port=3306/tcp --permanent && firewall-cmd --reload
Test with
mysql -u root -p
—expect \"MariaDB [(none)]>\" On Hetzner this powers phpMyAdmin—check version with
mysql -V
(e g \"10 5 22-MariaDB\") Faster than MySQL on writes it ensures uptime—add SSL for security with certbot on Nginx setups

Back to All Tips