一个vps建两个网站怎么弄数据库

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

# 安装Nginx
sudo apt install nginx -y

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

server {
    listen 80;
    server_name sitea.example.com;

    root /var/www/sitea;
    index index.html index.htm;

    location / {
        try_files $uri $uri/ =404;
    }
}

server {
    listen 80;
    server_name siteb.example.com;

    root /var/www/siteb;
    index index.html index.htm;

    location / {
        try_files $uri $uri/ =404;
    }
}

sudo ln -s /etc/nginx/sites-available/sitea /etc/nginx/sites-enabled/
sudo ln -s /etc/nginx/sites-available/siteb /etc/nginx/sites-enabled/
sudo nginx -t # 测试配置文件
sudo systemctl reload nginx # 重新加载Nginx

sudo mysql -u root -p

# 在MySQL shell中
CREATE DATABASE sitea_db;
CREATE USER 'sitea_user'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON sitea_db.* TO 'sitea_user'@'localhost';

CREATE DATABASE siteb_db;
CREATE USER 'siteb_user'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON siteb_db.* TO 'siteb_user'@'localhost';

FLUSH PRIVILEGES;
EXIT;

<?php
$servername = "localhost";
$username = "sitea_user";
$password = "password";
$dbname = "sitea_db";

// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);

// 检测连接
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}
?>

<?php
$servername = "localhost";
$username = "siteb_user";
$password = "password";
$dbname = "siteb_db";

// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);

// 检测连接
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}
?>