+- Community Support for OpenDocMan (Deprecated) (https://forum.opendocman.com)
+-- Forum: OpenDocMan Community Discussion (https://forum.opendocman.com/forum-5.html)
+--- Forum: OpenDocMan Support - Community Based (https://forum.opendocman.com/forum-6.html)
+--- Thread: "Could not set Grant (/thread-14.html)
"Could not set Grant - Stephen - 01-12-2010
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
Re: "Could not set Grant - Stephen - 01-12-2010
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
Re: "Could not set Grant - Stephen - 01-12-2010
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
Re: "Could not set Grant - Stephen - 01-12-2010
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