"Could not set Grant

[Stephen]

Hi
I am new to setting up databases etc but am sure I have set it up correctly including all privileges etc but keep having the error "Could not set Grant" when I try and install ODM. Can anyone help please? Thanks

danlewis79

[Stephen]

It might be helpful to know what you're using for a hosting platform: OS version, database version, etc.

On my Linux systems, I have typically done the following to create and configure the ODM database, while logged into MySQL as the "root" user:

# mysql -u root -p
Enter password: {your_password}
mysql> create database opendocman;
mysql> grant select,insert,update,delete,create,alter,drop on opendocman.* to opendocman@localhost identified by 'opendocman';
mysql> flush privileges;
mysql> exit;

Then run the ODM setup script:

# mysql -u opendocman -p opendocman < database.sql
Enter Password: opendocman

jonathanwminer

[Stephen]

Hello,

I have the same problem of Could not set Grant. Could anyone assist in how to set Grant. I am using Cpanel and have shared hosting. I have tried removing the user from the database and reinstalled it again, but still problem persists.

Any help in this regard will be appreciated.

Kind Regards,

Khawar Khalid

[Stephen]

Hi,

I have the same problem here.
Altough I am migrating from ODM 1.2.4 to ODM 1.2.5, when I installed the previous version I never encountered such a "grant" problem before.

If someone know's a solution I would be very greatfull.

Thanks in advance

Kind regards,

Peter