CMS Made Simple Forums

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

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.

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

Remove PRIVILEGES from the statement

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