We have used the wildcard capability with grants in our current MySQL setup, using grants such as
If we try this with the command line client pointed at a maxscale host, specifying a database gives us an 'access denied' failure.
whereas connecting to one of the Galera nodes directly works
If we explicitly set the grant for a specific database, then the client works
In all cases, connecting without specifying the database and then choosing the database with a use statement works.