Double click on wp-config.php and the file will automatically open in your DSM via the Text Editor application without having to download it and edit it on your computer. If you want to edit the file just like I did, download the Text Editor application directly from the Synology Package Center. To change the password, open the wp-config.php file with Text Editor and enter the new password which you previously changed in phpMyAdmin directly in the file. Once you have changed the password for your SQL database, remember to also change it in the WordPress file called wp-config.php which you will find in the main WordPress folder. Follow the instructions in the image below. Do know that the password chosen randomly by the system will be a strong one. You can choose a new password or you can leave it to the system to choose one for you randomly. Now click on User accounts followed by Change password. Click (+) to expand the database table, and locate 'wpusers' table. Select the user for which you want to change the password and click on Edit privileges. This’ll run the MD5 hashing algorithm on the value we just typed, making it into one that. (Don’t forget it’s case-sensitive.) Click on the dropdown menu on the same line and select MD5. How to Change MySQL Root Password in Ubuntu 20.04 Step 1: Check the version of MySQL on Ubuntu 20.04 Step 2: Stop the MySQL server Step 3: Skip Grant Tables. (This was your old, securely stored, password.) Type in your new password. ![]() Follow the instructions in the image below. Select and delete the long list of numbers and letters next to userpass. Now log in with your administrator credentials. Please Support My work by Making a Donation.Īccess your Synology NAS at localhost and click on the phpMyAdmin app. First of all you will need to open the phpMyAdmin application. Fortunately, Synology provides us with all the tools we need for this. Type the following command: wp user update 1 -userpasspassword. If it’s the site admin, the user ID will be 1, but you can use this method to change other user passwords too. Find the user whose password you want to reset and make a note of their user ID. In this guide I will teach you, step by step, how to change your SQL database password for your WordPress website hosted on a Synology NAS. Get a list of users by typing this command: wp user list. Occasionally you will need or want to change your SQL database password.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |