How to change your WordPress database password
If you’ve installed WordPress or you are using our WordPress hosting, simply follow the steps listed below.
Let’s get started…
Changing the password
- Login to your LCN account and move your Control Panel.
- Click the domain you wish to perform a change to.
- Click Hosting Settings followed by MySQL
- You will now see your MySQL Databases for that domain. Click the Database name for the one you wish to update.
- Next click on the Username being used to access the Database by your WordPress site.
- Enter a New Password in the first box.
- Followed by Confirm Password in the second box.
- You can adjust the other settings if needed, other wise scroll down to the bottom and click Save.
Success! You’ve changed your WordPress database password. Making this change will cause your website to display an Error establishing a database connection message until you’ve completed the steps listed in the second half of this guide.
Updating the WordPress configuration file
Now you’ll need to update the password in the WordPress configuration file.
The below instructions will cover how to make this change via FTP.
- Using your FTP client, navigate to the Web folder
- Right-click the wp-config.php file and select View/Edit
- Select Use default editor for text files and click OK
- Once the file has opened, find the section below:
- Replace the password inside the quotation marks with the new database password you chose earlier
- Click the X in the top right of your text editor to close it
- You’ll be prompted to save the file you’ve just edited, click Save
- A box will appear notifying you that A file previously opened has been changed. Click Yes.
That’s it! You’ve changed your WordPress database password and updated your WordPress configuration file.