granting a user wildcard access to databases

[sfullman]

I thought this would work:

grant all privileges on cpm051%.* to cpm051@localhost;

so that cpm051@localhost would have access to

cpm051
cpm051_roger
cpm051_frank
cpm051_helen
.. etc.

However it does not.

How would I do this query and is it possible?

Thanks
Samuel