If you have changed your database password in ServerPilot, you will also need to change it in WordPress's code for your app to run correctly.
First, open your WordPress app's wp-config.php file, located at
apps/APPNAME/public/wp-config.php
Near the top of the file, you should see the line that begins
define('DB_NAME',
Here you'll see where to edit your database credentials.