Open Source Document Management System | OpenKM

PostPosted:**Sat Mar 04, 2017 10:54 am**

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

PostPosted:**Sat Mar 04, 2017 11:16 am**

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;

Open Source Document Management System | OpenKM

DATABASE

DATABASE

Re: DATABASE