mysql如何设置域名访问控制

-- 创建用户并分配权限
CREATE USER 'user1'@'example1.com' IDENTIFIED BY 'password1';
GRANT SELECT, INSERT ON your_database.* TO 'user1'@'example1.com';

CREATE USER 'user2'@'example2.com' IDENTIFIED BY 'password2';
GRANT SELECT ON your_database.* TO 'user2'@'example2.com';

server {
    listen 80;
    server_name example1.com;

    location / {
        proxy_pass http://your_backend_server;
        proxy_set_header Host $host;
        proxy_set_header X-Real-IP $remote_addr;
        proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
        proxy_set_header X-Forwarded-Proto $scheme;

        # 限制只有example1.com可以访问
        allow 192.168.1.0/24;  # 允许的IP范围
        deny all;
    }
}

server {
    listen 80;
    server_name example2.com;

    location / {
        proxy_pass http://your_backend_server;
        proxy_set_header Host $host;
        proxy_set_header X-Real-IP $remote_addr;
        proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
        proxy_set_header X-Forwarded-Proto $scheme;

        # 限制只有example2.com可以访问
        allow 192.168.2.0/24;  # 允许的IP范围
        deny all;
    }
}