How do I reset the password for my database? -- Sep 6 2014, 5:47 PM

Log in to your cpanel control panel at http://yourdomainname.co.nz/cpanel
Replace yourdomain.co.nz with your actual domain name

Scrll down to the Databases section

Click on the MySQL Databases icon

Scrll down to the Current Users section

Click on the Set Password icon

Enter your password

Confirm your password

Click the Change Password button

NOTE: 
If you have scripts that connect to a database the password for that user needs to match the password specified in the scipt