MariaDB root password not updating

[waxen lance]

Hello, I'm using WordPress template with MariaDB.

During recent hardening of security, I have decided to use stronger root and base user password, so I have changed the passwords inside the variables.

However, the database didn't update even after several restarts and re-deploying and now I'm stuck with my website and access to database not working.

Project: https://railway.com/project/61eb0561-69f2-4f0e-9df4-9162b177aa0c?environmentId=97a8f559-7c05-4137-a893-dfd5c1c71751

Any help how to reset the password and get it working without data loss?

I have already tried via CLI, MARIADB_AUTO_UPGRADE variable, etc... but to no avail.

Here is a log from last re-deploy:

[quiet bay]

New reply sent from Help Station thread:

Can you connect to the database using something like DBeaver?

You're seeing this because this thread has been automatically linked to the Help Station thread.

New reply sent from Help Station thread:

Also did you change those variables on wordpress too?

You're seeing this because this thread has been automatically linked to the Help Station thread.

[waxen lance]

Tried using phpMyAdmin service that I have deployed, but to no avail.

It looks like the variable was changed, but internally remain the previous password, which I forgot to note down.

[waxen lance]

No, because WordPress is taking the password from dynamically set variables, which have direct reference to the MariaDB variables.

I have tried to set the password in wp-config.php as fallback one directly, but that didn't solve it either.

[quiet bay]

New reply sent from Help Station thread:

a better solution would be to create a new user for the db with the user/pass you need, and keep the one created by railway as root user

You're seeing this because this thread has been automatically linked to the Help Station thread.