There may be a period when you need to make modifications to your site's database through phpMyAdmin or perhaps you need to perform an import via ImportBuddy. In order to do this, you need to retrieve your database password. There are two methods which you can use to get your database password.
Retrieve DB Pass via wp-config.php
The easiest and least invasive way to retrieve that password is to simply check your wp-config.php file and get the listed password from there. To do this you will first want to login to your site via SFTP.
Once you've logged into your site via SFTP, you will go to the /web/content/ folder and look for the wp-config.php file.
You will then want to right-click on the file and select View/Edit from the menu that opens. This will open the wp-config.php file into a text editor where you can then look for the section titled MySQL Database Password.
You will want to copy the password which is located in between the ' '. Now you've got the database password!
Reset Database Password
The second way you can get the database password is to simply reset it. This process is a bit more involved as you will need to update your database password within the wp-config.php file in order for your site to function properly. If you are planning to perform an import of a new database via the importbuddy.php script, you can skip the part where you add the database password to the wp-config.php file as the importbuddy.php process will handle that for you.
You will want to login to your site via your iThemes Hosting Sync panel, navigate to the Hosting section and select the drop-down to display your hosting information. From there, under the Database Information section, you will find the Edit DB Password option.
You will see the following window pop up where you can edit the password to whatever you like as long as it meets the listed criteria.
Once you save the new password, you will need to update your wp-config.php file to use the new password, otherwise, your WordPress site will not be able to connect to the database and will remain offline. If you are using ImportBuddy to perform a restore or migration, you can skip this step and move on to the restore or migrate instructions.
From here you will need to login to your site via SFTP and navigate to the /web/content folder and look for the wp-config.php file.
You will then want to right-click the file and select View/Edit from the menu that opens. This will open the wp-config.php file into a text editor where you can then look for the section titled MySQL Database Password.
You will want to delete the password currently showing which is located in between the ' '. Once deleted, you will add the password you set between the ' ' and then save the file and re-upload it to your site. Now you've reset and updated your database password!