mysql_create_user.sql

CREATE USER 'newuser'@'%' IDENTIFIED BY 'user_password';

DROP user 'qor'@'localhost';

CREATE USER 'qor'@'%' IDENTIFIED BY 'qor';

CREATE DATABASE qor_test;

GRANT ALL ON qor_test.* TO 'qor'@'localhost';
GRANT ALL ON qor_test.* TO 'qor'@'%';

ALTER USER 'qor'@'localhost' IDENTIFIED BY 'qor';

FLUSH PRIVILEGES;

UPDATE mysql.user
SET authentication_string = PASSWORD('qor')
WHERE User = 'qor' AND Host = 'localhost';

FLUSH PRIVILEGES;