MySQL grant syntax & dynamic database using wildcards
Kedar
The MySQL grant syntax allows you to specify dynamic database names using the wildcard characters. This article explains the usecase of dynamic section of mysql grants.
Browsing Tag
mysql wildcards
1 post
2 responses to “MySQL grant syntax & dynamic database using wildcards”
Putting a \ before the % escapes the wildcard. Your user would only have access to a database named literally `WP%`.
Thanks for pointing it out Tom.