-- Create a user as root and grant permissions
CREATE USER IF NOT EXISTS 'abcd'@'%' IDENTIFIED WITH mysql_native_password BY 'abcd';
GRANT ALL PRIVILEGES ON *.* TO 'abcd'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;

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

-- Grant permissions to the user for RA database
GRANT ALL PRIVILEGES ON RA.* TO 'abcd'@'%';
FLUSH PRIVILEGES;