Using your favorite editor, open configuration.php.

Joomla 2.5 look for

public $user = 'database user';

public $password = 'database password';

Change 'database user'; and or 'database password'; to new user and or new password

Save the changes