GRANT ALL PRIVILEGES ON *.* TO '<%= properties.admin_username %>'@'%' WITH GRANT OPTION;
UPDATE mysql.user SET Password=PASSWORD('<%= properties.admin_password %>'), Plugin='' WHERE User='<%= properties.admin_username %>';
DELETE FROM mysql.user WHERE User='';

FLUSH PRIVILEGES;

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

GRANT ALL PRIVILEGES ON *.* TO '<%= properties.admin_username %>'@'%' WITH GRANT OPTION;
UPDATE mysql.user SET Password=PASSWORD('<%= properties.admin_password %>') WHERE User='<%= properties.admin_username %>';
UPDATE mysql.user SET Plugin='';
DELETE FROM mysql.user WHERE User='';

FLUSH PRIVILEGES;

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

Change mysql.user plugin to '' for all users not just root
Change mysql.user plugin to '' for all users not just root

[#71062154]
