Overview
You can change a MySQL user's password from the MySQL Databases page in your DreamHost panel — but you must also update your site's application config file, or the site will not load. This article explains both steps.
How do I change a MySQL user's password?
You can change the password for a MySQL user by visiting the panel. You must also update the config file within the third-party application.
How do I change the database password?
- Navigate to the MySQL Databases page.
- To the right of your database, click your username.
- At the bottom of the page, enter your new password and save it.
How do I update my site's config file?
When you change the database user password you must also change the config file for your website application. If you do not, your website will not load. The config file is different for each site, and a few common examples are listed below:
| Software | Config file name | Config file location |
|---|---|---|
| Concrete CMS | database.php | application/config/ |
| Joomla | configuration.php | In the site's main directory |
| MediaWiki | Localsettings.php | In the site's main directory |
| phpBB | config.php | In the site's main directory |
| WordPress | wp-config.php | In the site's main directory |
| Zen Cart | configure.php | includes/ |
You can update your site's config file by logging into the server via FTP or SSH. Consult online documentation for your specific app for instructions on how to adjust this config file.