Hey there! We've found the following might help you get unblocked faster:

• 🧵 Failing to see connected db
• 🧵 Prisma: "Authentication failed against database server"
• 🧵 migration failed error in MySQL

If you find the answer from one of these, please let us know by solving the thread!

Time for the great guide of all time

⠀

Before you do any of this, disable all public access domains. Just in case.

⠀

1. Install the Railway CLI. You can do so here: https://docs.railway.com/guides/cli
2. Copy the SSH command by right clicking the PostgreSQL service
3. Once you're in, type in the following command: (Copy paste this EXACTLY as written.) sed -i 's/host all all all scram-sha-256/host all all ::\/0 trust/' /var/lib/postgresql/data/pgdata/pg_hba.conf
4. Redeploy your database.
5. Use the SSH command again, and once you're in, type psql.
6. Type the following SQL command. my_password should be replaced with whatever it actually says in your variables tab for your password (Probably under the PGPASSWORD variable.) ALTER USER postgres with password 'my_password';
7. Type exit
8. Reset your authentication settings with the following command: sed -i 's/host all all ::\/0 trust/host all all all scram-sha-256/' /var/lib/postgresql/data/pgdata/pg_hba.conf
9. Redeploy your database once again. You have now changed the password.

⠀

Let me know if this works!

do you have handy a flavor of this guide for MySQL instead of Postgre?