You can change the password for a database on your 123-reg hosting package through your 123-reg control panel:
Scroll down to the Web hosting section.
Select the relevant domain name from the drop down box and click on the Manage button.
Click on the Database link in the Web Tools section of your hosting control panel.
In the Manage Databases section enter the new password in the empty field and press the Modify button.