#!/bin/bash

###############################################################################
# Check MySQL Root Password on NEW Server
# Run this on: NEW server (vps2.scala4.com)
###############################################################################

echo "=========================================="
echo "Checking MySQL Root Password on NEW Server"
echo "=========================================="
echo ""

# Check if running as root
if [ "$EUID" -ne 0 ]; then 
    echo "ERROR: Please run as root (use sudo)"
    exit 1
fi

echo "Method 1: Try to login without password..."
mysql -u root -e "SELECT 1;" 2>&1 | head -3
echo ""

echo "Method 2: Check for password files..."
if [ -f /root/.my.cnf ]; then
    echo "Found /root/.my.cnf:"
    cat /root/.my.cnf
else
    echo "No /root/.my.cnf found"
fi
echo ""

if [ -f /etc/mysql/debian.cnf ]; then
    echo "Found /etc/mysql/debian.cnf:"
    cat /etc/mysql/debian.cnf | grep -v "^#" | grep -v "^$"
else
    echo "No /etc/mysql/debian.cnf found"
fi
echo ""

echo "Method 3: Check MySQL version and status..."
systemctl status mariadb | head -5
echo ""

echo "=========================================="
echo "Summary:"
echo "=========================================="
echo ""
echo "If Method 1 worked (no password error), you can use:"
echo "  mysql -u root"
echo ""
echo "If Method 1 failed, you may need to:"
echo "  1. Use the password from /root/.my.cnf (if exists)"
echo "  2. Reset MySQL root password"
echo "  3. Use debian-sys-maint user from /etc/mysql/debian.cnf"
echo ""