I need to change my database password, and I understand that it is contained in sites/default/settings.php.

Two questions:

1. Is the password that shows in settings.php encrypted? ie do I put exactly the same password there as the new one I put in my cpanel?
2. Are there any other database connection settings that I need to change?

Thanks very much.

Comments

rishav-1’s picture

Its not encrypted ,

1.the "$db_url" variable and its format is given in the settings.php file so see that either create the something similar or change it as per whatever db u create using your cpanel.

2.no you don't need to change anything else as far as db config is concerned

Anonymous’s picture

Thank you very much - that's changed and working now.

I find changing database passwords very nerve-wracking!

Please speak slowly and clearly - bear with me, I'm learning all the time.

cippian’s picture

if the password is no longer encrypted, what are the steps necessary to encrypt it? I've been testing moving my drupal site from one server to another, and the settings.php file has an encrypted password that does not work once I transfer. If I type in the plain text new db password it works, so how does one encrypt this password in the new settings.php file?

It would seem easier if drupal allowed an administrator to access the database configuration screen post install. Is this something that can be done? If the db settings need changed it seems as though the db configuration screen should still be accessible.

Thanks.