I’m trying to change the user passwords for my MySQL databases in the Dreamhost webpanel (under “My MySQL Databases”, selecting the user, and then entering the new password twice). However, for some reason, I’m unable to do so without causing an “Error establishing a database connection” when I visit the associated blogs and wiki online in a web-browser.
I have four dbs and two users:
 user1 – with access to all four dbs
 user2 – with access to only one
Changing the user password for “user2” does not impact the connection; changing it on “user1” means that I can’t visit any of the Wordpress blogs or my Mediawiki wiki through the course of normal web-browsing.
I had believed that the password controlled direct access to the MySQL db; I’m surprised that it has an impact on the functionality of the software.
I’m having trouble finding out where I’m screwing up (other than just leaving the password alone) in the Dreamhost troubleshooting wiki. All I can find is:
Neither of which seems to help.
I’d be very grateful is someone could tell me how to fix this – but a link to the correct wiki page/ forum thread would also be appreciated. The password on User1 is pretty old by now and due for a change.
And, yes, this is all very embarrassing.