Unable to create user with access from multiple hosts
Opened this issue · 1 comments
worldowner commented
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 commented
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 %