Create user and grant privileges

CREATE USER '[username]'@'%' IDENTIFIED BY '[password]';
GRANT ALL ON [database].* TO '[username]'@'%';
FLUSH PRIVILEGES;