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
