Purge MariaDB from Ubuntu 24.04 and Re-Install Scripts

setup-mariadb-10.6.sh

#!/bin/bash

set -e

echo "🚨 Stopping and removing existing MariaDB..."
sudo systemctl stop mariadb || true
sudo apt remove --purge mariadb-server mariadb-client mariadb-common mariadb-server-core-* mariadb-client-core-* -y
sudo apt autoremove -y
sudo apt autoclean -y

echo "🧹 Removing residual config/data (optional)..."
sudo rm -rf /etc/mysql /var/lib/mysql /var/log/mysql /var/log/mysql.*

echo "🔑 Installing dependencies..."
sudo apt install -y software-properties-common dirmngr gnupg curl

echo "🔑 Adding MariaDB 10.6 repo (using jammy for Ubuntu 24.04)..."
sudo curl -LsS https://mariadb.org/mariadb_release_signing_key.asc | gpg --dearmor | sudo tee /etc/apt/trusted.gpg.d/mariadb.gpg > /dev/null
echo "deb [signed-by=/etc/apt/trusted.gpg.d/mariadb.gpg] https://mirror.xtom.com.hk/mariadb/repo/10.6/ubuntu jammy main" | sudo tee /etc/apt/sources.list.d/mariadb.list

echo "🔄 Updating package list..."
sudo apt update

echo "📦 Installing MariaDB 10.6..."
sudo apt install mariadb-server mariadb-client -y

echo "✅ Enabling and starting MariaDB..."
sudo systemctl enable mariadb
sudo systemctl start mariadb

echo "🔐 Running mysql_secure_installation..."
sudo mysql_secure_installation

echo "✅ MariaDB installed successfully:"
mysql --version

echo "🚀 You can now run 'bench new-site yoursite.com' again!"