Occasionally we need to change our SQL database password. In this guide I will teach you step by step how to change your SQL database password of your wordpress on a Synology NAS. Synology provides us with all the tools we need. First of all, open the phpMyAdmin application. Follow the instructions in the image below.
Access your Synology NAS at localhost and click on the phpMyAdmin app.
Now log in with your administrator credentials. Follow the instructions in the image below.
Select the user for which you want to change the password and click “Edit privileges.” Follow the instructions in the image below.
Now click on “User accounts”, then on “Change password”. Follow the instructions in the image below.
You can choose a new password or you can leave it to the system to choose one for you randomly – the password chosen randomly by the system will be a strong one. Follow the instructions in the image below.
Once you have changed the password of your SQL database, remember to change it in the wordpress file called wp-config.php that you will find in the main wordpress folder.
To change it, open the wp-config.php file with text editor and enter the new password which you previously changed in phpMyAdmin directly in the file. Save and you’re done.
If you want to edit the file just like I did, download the “Text Editor” application directly from the Synology Package Center. Double click on your wp-config.php and the file will automatically open in your Synology via the text editor application without having to download it and edit it on your computer.
This post was updated on Thursday / August 6th, 2020 at 3:15 AM