Unable to create user with access from multiple hosts

[worldowner]

host: "{{item.host | default('localhost')}}"
takes only last host found in user definition. It would be very nice to be able to give access to user from multiple hosts.

[soupdiver]

I think you would have to create multiple users with the same attributes and just change the hostname
See: https://dev.mysql.com/doc/refman/5.5/en/adding-users.html

CREATE USER 'monty'@'localhost' IDENTIFIED BY 'some_pass';
CREATE USER 'monty'@'%' IDENTIFIED BY 'some_pass';

They create the user monty one time for host localhost and again for host %