-- Create database
CREATE DATABASE IF NOT EXISTS acbptxvs_branch_system CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- Create user
CREATE USER IF NOT EXISTS 'acbptxvs_phin'@'localhost' IDENTIFIED BY '5;)8.H8aTG8%p_]';

-- Grant privileges
GRANT ALL PRIVILEGES ON acbptxvs_branch_system.* TO 'acbptxvs_phin'@'localhost';

-- Apply changes
FLUSH PRIVILEGES;

-- Show success message
SELECT 'Database and user created successfully!' AS Status;
