01-12-2010, 02:32 PM
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
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