-- Create admin user with a secure password
CREATE USER 'admin_niota'@'%' IDENTIFIED BY '*****';

-- Grant all privileges on schemas matching 'niota%'
GRANT ALL PRIVILEGES ON `niota%`.* TO 'admin_niota'@'%';

-- Grant SELECT privilege on the 'sys' schema
GRANT SELECT ON `sys`.* TO 'admin_niota'@'%';

-- to all this user also backup / restore
GRANT PROCESS ON *.* TO 'admin_niota'@'%';

GRANT SUPER ON *.* TO 'admin_niota'@'%';
FLUSH PRIVILEGES;


-- Apply changes
FLUSH PRIVILEGES;