#!/bin/bash
# Ripristina bind-address MariaDB dopo upgrade (solo ascolto rete).
# Uso: sudo bash /var/www/html/server-ops/ego/fix-mariadb-remote-access.sh

set -euo pipefail

if [[ "${EUID:-0}" -ne 0 ]]; then
	echo "Esegui come root: sudo bash $0" >&2
	exit 1
fi

SERVER_CNF="/etc/mysql/mariadb.conf.d/50-server.cnf"

sed -i 's/^\s*bind-address\s*=.*/bind-address            = 0.0.0.0/' "$SERVER_CNF"
grep 'bind-address' "$SERVER_CNF"

systemctl restart mariadb
systemctl is-active mariadb
ss -tlnp | grep 3306