Change password on your SQL database with phpMyAdmin

Change password on your SQL database with phpMyAdmin

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.

login on your phpmyadmin

Now log in with your administrator credentials. Follow the instructions in the image below.

login with your credentials in phpmyadmin

Select the user for which you want to change the password and click “Edit privileges.” Follow the instructions in the image below.

select user account in phpmyadmin and edit privileges

Now click on “User accounts”, then on “Change password”. Follow the instructions in the image below.

now change password in phpmyadmin

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.

final step change password on phpmyadmin

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.

change wp config password

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.

paypal This article is free, but powered by your donations. Updated on