美国服务器SQL数据库创建与管理指南

# Ubuntu安装
sudo apt update
sudo apt install mysql-server
sudo mysql_secure_installation  # 安全配置向导

# 创建数据库
mysql -u root -p
CREATE DATABASE app_db CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
GRANT ALL PRIVILEGES ON app_db.* TO 'app_user'@'%' IDENTIFIED BY 'StrongPassword123!';

aws rds create-db-instance \
    --db-instance-identifier mydb \
    --engine mysql \
    --db-instance-class db.t3.micro \
    --allocated-storage 20 \
    --master-username admin \
    --master-user-password yourpassword

-- MySQL逻辑备份
mysqldump -u root -p --single-transaction app_db > backup.sql

-- PostgreSQL物理备份
pg_basebackup -D /backups -Ft -z -P -U replicator

-- AWS RDS快照
aws rds create-db-snapshot --db-instance-identifier mydb --db-snapshot-identifier mydb-snapshot-2024

# 实时查看查询
mysql> SHOW FULL PROCESSLIST;

# PostgreSQL性能分析
SELECT query, calls, total_time FROM pg_stat_statements ORDER BY total_time DESC LIMIT 10;

-- 密码策略设置（MySQL 8.0+）
SET GLOBAL validate_password.policy = STRONG;

-- 禁用远程root登录
DELETE FROM mysql.user WHERE User='root' AND Host NOT IN ('localhost', '127.0.0.1');