Thanks Nico grant all privileges on ofbiz.* to 'ofbiz'@'localhost' identified by 'ofbiz';
worked! ________________________________ From: Nico Toerl <nico.to...@virtualvillage.com> To: user@ofbiz.apache.org Sent: Thu, August 26, 2010 2:09:13 PM Subject: Re: Error - Migrating from Derby to MySQL On 08/26/10 16:34, Nico Toerl wrote: > On 08/26/10 16:20, OfBizSuds wrote: >> 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?? >> > Password is a mysql system function that generates a hash from the argument >given. > Just the syntax/typo that caused mysql to produce that error. > > > |its either ....IDENTIFIED BY '/password/String' > > or > | > > PASSWORD('passwordString'); > > cheers > Nico > > sorry for the extra characters, not sure how i managed to type those what i meant to write was: its either ....IDENTIFIED BY 'passwordString' or PASSWORD('passwordString'); cheers Nico -- Nico Toerl SeniorSysadmin / IT-department Virtual Village Tel. +86 21 51718885 ext.7042