Personal - Redhat

SET GLOBAL validate_password_policy = 0;

CREATE USER 'kiwisql'@'%' IDENTIFIED BY '800486kiwi';

GRANT all ON *.* TO 'kiwisql'@'%' WITH GRANT OPTION;

CREATE USER 'kiwisql'@'localhost' IDENTIFIED BY '800486kiwi';

GRANT all ON *.* TO 'kiwisql'@'localhost' WITH GRANT OPTION;

CREATE USER 'kiwilive'@'localhost' IDENTIFIED BY '5541500kiwi';

GRANT all ON *.* TO 'kiwilive'@'localhost';

CREATE USER 'remuser'@'localhost' IDENTIFIED BY '5541500kiwi';

GRANT all ON *.* TO 'remuser'@'localhost' WITH GRANT OPTION;

CREATE USER 'reports'@'%' IDENTIFIED BY 'readonly';

GRANT SHOW DATABASES, SELECT, EXECUTE, PROCESS, SHOW VIEW  ON *.* TO 'reports'@'%';

FLUSH PRIVILEGES;

Quit