• DATABASE

  • We tried to make OpenKM as intuitive as possible, but an advice is always welcome.
We tried to make OpenKM as intuitive as possible, but an advice is always welcome.
Forum rules: Please, before asking something see the documentation wiki or use the search feature of the forum. And remember we don't have a crystal ball or mental readers, so if you post about an issue tell us which OpenKM are you using and also the browser and operating system version. For more info read How to Report Bugs Effectively.
 #43339  by virgo29
 
Hi,

Any one could help me, I accidentally drop my database "okmdb" without backup on it.

actually im doing this procedure HSQLdb to MySQLdb but when i get in this Steps "CREATE USER openkm@localhost IDENTIFIED BY '*secret*';" it shows error "error 1064(42000): You have an error in your SQL syntax; check the manual that corresponds to your MYSQL server version for the right syntax to use near '8080/OpenKM with grant option' at line 1"

what i imputed here is "CREATE USER openkm@121.58.251.214 IDENTIFIED BY '*secret*';

so when i shows the table it says empty then i cannot access already the openKM.


Urgent need your assistance.

Thanks
 #43343  by jllort
 
Should be something like it ( must be execute from mysql database client not from OpenKM database client, you are still not connected to MySQL from there):
Code: Select all
CREATE DATABASE okmdb DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_bin;
CREATE USER openkm@localhost IDENTIFIED BY 'password';
GRANT ALL ON okmdb.* TO openkm@localhost WITH GRANT OPTION;

About Us

OpenKM is part of the management software. A management software is a program that facilitates the accomplishment of administrative tasks. OpenKM is a document management system that allows you to manage business content and workflow in a more efficient way. Document managers guarantee data protection by establishing information security for business content.