CREATE DATABASE IF NOT EXISTS user_auth;
USE user_auth;
CREATE TABLE IF NOT EXISTS users (
id INT AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(50) NOT NULL UNIQUE,
email VARCHAR(100) NOT NULL UNIQUE,
password VARCHAR(255) NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
-- Создаем пользователя для доступа к базе (замените 'your_password' на свой пароль)
CREATE USER 'auth_user'@'localhost' IDENTIFIED BY '123123';
GRANT ALL PRIVILEGES ON user_auth.* TO 'auth_user'@'localhost';
FLUSH PRIVILEGES;