[Koha] change master pw

[Andrew Yager]

The command you need to type is:

update user set password=password("abc123") where user="kohaadmin";

and then restart MySQL.

Andrew

_________________________
Andrew Yager, Managing Director (BCompSc MACS)
Real World Technology Solutions Pty Ltd
ph: 1300 798 718 or (02) 9563 4840
fax: (02) 9563 4848 mob: 0405 152 568
http://www.rwts.com.au/
_________________________

Real World Technology Solutions is an Authorised Apple Reseller,  
Telstra Dealer, Microsoft Small Business Solutions Specialist, Cisco  
Registered Partner and Member of Open Source Industry Australia.


On 21/08/2007, at 6:37 PM, yaser hassan wrote:

> Mr/Rick Welykochy
> I read your message about changing the main password of koha, and  
> did first step butthe second step is not clear,
> I opened the mysql command line with runing "C:\mysql\bin 
> \mysql.exe", and  typed your command :
> mysql-e 'update user set password=password("abc123") where  
> user="kohaadmin"';
> but it gave me syntax error,please try to write the mysql command  
> exactly.
>
> Thanks
>
>
> Be a better Heartthrob. Get better relationship answers from  
> someone who knows.
> Yahoo! Answers - Check it out.
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha