UPDATE mysql.user SET Password=PASSWORD('<%= properties.mysql.root_password %>') WHERE User='root';

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;

FLUSH PRIVILEGES;

SET GLOBAL fast_index_creation=false;

-- For now, provide credentials from this db
-- DROP DATABASE IF EXISTS test;

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
UPDATE mysql.user SET Password=PASSWORD('<%= properties.mysql.root_password %>') WHERE User='root';

FLUSH PRIVILEGES;

SET GLOBAL fast_index_creation=false;

-- For now, provide credentials from this db
-- DROP DATABASE IF EXISTS test;

Create root@'%' before setting password
Create root@'%' before setting password

As it turns out, GRANT creates users!
