MySQL syntax HELP please

[burlington]

I have driven myself mad tonight trying to give full privileges to a user on MySQL.
I thought that the following syntax was OK but apparently not:

GRANT ALL PRIVILEGES ON cmsdb TO ‘cppadmin’@'localhost’;

I am not used to working with syntaxes. Can anyone please tell me what I am doing wrong?

Many thanks

Martin

[JohnnyB]

if 'cmsdb' is the name of your database, I think you have to use:
cmsdb.*
to get all the tables in it.

Next, change the name of the database and user if that is your actual names being used... shouldn't really advertise that information.

[burlington]

Thanks but this does not work either. I am still getting the message to check the syntax.

[velden]

Remove PRIVILEGES from the statement

[burlington]

Sorry but this does not work either.
However, this site is now going to be mounted on another server with a less obtuse hosting company, which does not need the use of phpMyAdmin to set the permissions.
Thanks everyone for your help.
Martin