CODE EXAMPLE FOR SQL

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;