Based only on reading the docs (so caveat lector): host values with wildcards must be quoted within the username, so "applications@%" isn't valid. You need "applications@'%'.
This is according to my reading of https://dev.mysql.com/doc/refman/5.7/en/grant.html ("Object Quoting Guidelines"):
However, quotation marks are necessary to specify a user_name string containing special characters (such as -), or a host_name string containing special characters or wildcard characters such as % (for example, 'test-user'@'%.com'). Quote the user name and host name separately.
little-cartoon-10569
01/26/2022, 7:46 PM
Which I think can be done with
host: "'%'"
little-cartoon-10569
01/26/2022, 7:47 PM
Probably need this in both the grant and the opts objects.
f
fast-easter-23401
01/26/2022, 10:02 PM
This is great @little-cartoon-10569. Gonna try that. Many thanks.
No matter how you like to participate in developer communities, Pulumi wants to meet you there. If you want to meet other Pulumi users to share use-cases and best practices, contribute code or documentation, see us at an event, or just tell a story about something cool you did with Pulumi, you are part of our community.