I have a query that looks like this:

GRANT select, insert, update, delete
ON content.*
TO audio-occasion_qc_ca_-_content@localhost identified by 'password';

And it keeps crashing on the first '-' character it hits.... it there a way to use another character or enclose the words somehow to fix this?

I cannot unfortunately rename my db prefix .

Thanks!

this: "audio-occasion_qc_ca_-_content" must be user not dbname

Check the MySQL GRANT documentation. I think what you want is:-PatP