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
--
Nico Toerl
SeniorSysadmin / IT-department
Virtual Village
Tel. +86 21 51718885 ext.7042
