I am trying to get ofbiz to work with MySQL DB instead of the default Derby db. Tried following instructions given in the Production setup & that in the llnk http://www.flagword.net/2010/06/29/how-to-migrate-ofbiz-from-derby-to-mysql-db/
Has anyone tried this? I exported the data to XML thru webtools. Then created a Mysql db called ofbiz & one more called ofbizolap as per instructins given. I can see the 2 databases created also in mySQL (thru Netbeans IDE) When I try the line grant all privileges on ofbiz.* to 'ofbiz'@'localhost' identified by password 'ofbiz'; OR grant all privileges on ofbizolap.* to 'ofbiz'@'localhost' identified by password 'ofbizolap'; I get the error "Password hash should be a 41-digit hexadecimal number" Any ideas how to fix this?? -- View this message in context: http://ofbiz.135035.n4.nabble.com/Error-Migrating-from-Derby-to-MySQL-tp2339328p2339328.html Sent from the OFBiz - User mailing list archive at Nabble.com.