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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha