6 months ago
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.
Any help how to reset the password and get it working without data loss?
I have already tried via CLI, MARIADBAUTOUPGRADE variable, etc… but to no avail.
Here is a log from last re-deploy:
7 Replies
6 months ago
Can you connect to the database using something like DBeaver?
6 months ago
Also did you change those variables on wordpress too?
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.
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.
6 months ago
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
The issue is, as stated above, that it's all user that are not working.
Because of the variables changes, nor normal user nor root currently work.