--
-- create root password
--

FLUSH PRIVILEGES;
CREATE USER 'root'@'%' IDENTIFIED BY 'Fake_Password_Here';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
FLUSH PRIVILEGES;

--
-- Check which root accounts exists
-- Check HOSTNAME
--

ALTER USER 'root'@'localhost' IDENTIFIED BY 'Fake_Password_Here';
ALTER USER 'root'@'HOSTNAME' IDENTIFIED BY 'Fake_Password_Here';
ALTER USER 'root'@'127.0.0.1' IDENTIFIED BY 'Fake_Password_Here';
ALTER USER 'root'@'::1' IDENTIFIED BY 'Fake_Password_Here';
ALTER USER 'root'@'%' IDENTIFIED BY 'Fake_Password_Here';

GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'HOSTNAME';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'::1';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';

FLUSH PRIVILEGES;