To prevent your database to be accessed by unathorized people, it is highly recommended to change the password of your SQL database.
IMPORTANT: When you change the database password, you need to change also in your wp-config file. I will show how to this in the tutorial, but until you have done the changes in both places, your website will not be accessible.
To do this, access phpMyadmin, by clicking on the icon in your Synology:
Once inside phpMyAdmin, click on “Users”
Click on the User “root” whose Host is “localhost” and click on “Edit Privileges”
Scroll down until you see the Change Password section. Enter your new password and click “Go”.
If you have done everything correctly, you will see the following message:
At this point, your wordpress site will not be able to access the contents of the database until you have updated the password on your wp-config file. Let’s do that:
There are many ways you can access your files:
- Access and map Synology NAS DS713+ files inside your network
- Access and map Synology NAS DS713+ files outside your network
- or you can use FileStation.
The wp-config file is located under your Web folder>Name of your site>wp-config. An example:
Open it with your text editor, I use Note++, add your new password between the brackets ex. ‘password’ and upload it back:
Now your website will go back online.