-- 1. Create the database
CREATE DATABASE consultation_db;

-- 2. Create the user 
-- (Change 'strong_password_here' to your actual password)
CREATE USER 'consultation_db_user'@'localhost' IDENTIFIED BY 'Strong$Password;123';

-- 3. Grant access to the user on the new database
GRANT ALL PRIVILEGES ON consultation_db.* TO 'consultation_db_user'@'localhost';

-- 4. Apply the changes
FLUSH PRIVILEGES;