This message was deleted.
# general
s
This message was deleted.
l
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.
Which I think can be done with
host: "'%'"
Probably need this in both the grant and the opts objects.
f
This is great @little-cartoon-10569. Gonna try that. Many thanks.
👍 1