#!/bin/bash

# 安全读取密码（不显示、不记录history）
read -s -p "请输入MySQL密码: " MYSQL_PASS
echo -e "\n开始执行..."

# 执行MySQL命令
mysql -u root -p"$MYSQL_PASS" -e "
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
ALTER USER 'root'@'%' IDENTIFIED BY '${MYSQL_PASS}';
FLUSH PRIVILEGES;
"

if [ $? -eq 0 ]; then
    echo -e "\n✅ 开启远程mysql成功"
else
    echo -e "\n❌ 开启远程mysql失败"
fi

# 清空变量，防止残留
unset MYSQL_PASS