#!/bin/bash

# 更新系统
sudo apt update && sudo apt upgrade -y

# 安装 MySQL Server
sudo apt install mysql-server -y

# 安全配置
sudo mysql_secure_installation <<EOF

y

y
y
y
y
EOF

# 修改 MySQL 配置以允许外部连接
sudo sed -i "s/bind-address\s*=\s*127.0.0.1/bind-address = 0.0.0.0/" /etc/mysql/mysql.conf.d/mysqld.cnf

# 重启 MySQL 服务
sudo systemctl restart mysql

# 创建数据库和用户
DB_NAME="psd"
DB_USER="cemcoe"
DB_PASS="wodetian2025"

sudo mysql -u root -p'wodetian2025' -e "CREATE DATABASE $DB_NAME;"
sudo mysql -u root -p'wodetian2025' -e "CREATE USER '$DB_USER'@'%' IDENTIFIED BY '$DB_PASS';"
sudo mysql -u root -p'wodetian2025' -e "GRANT ALL PRIVILEGES ON $DB_NAME.* TO '$DB_USER'@'%';"
sudo mysql -u root -p'wodetian2025' -e "FLUSH PRIVILEGES;"

# 配置防火墙
sudo ufw allow 3306/tcp
sudo ufw enable

# 显示状态
sudo ufw status
sudo systemctl status mysql

echo "MySQL 安装和配置完成！"