mysql grant user privileges to database that has suffix and prefix code example
Example: mysql grant user privileges to database that has suffix and prefix
GRANT ALL PRIVILEGES ON `PREFIX\_%_\SUFFIX`.* TO 'USER'@'HOST' IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;