MariaDB root password reset

Keywords: Redmine - Virtual Machines - How to - Other

Description:
I followed the guide here (Approach A) https://docs.bitnami.com/general/apps/redmine/administration/change-reset-password-mariadb/

but the root password is not getting reset.
after i follow the instructions, i still get this message

‘ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: YES)’

I’m running redmine as a VM on ESXI version 4.2.2-5

Hello @MasterYoda,

You are right. These steps don’t work with Mariadb 10.4. The team will review it and update the documentation accordingly.

Regards

i think this is true for OVA as you cannot set the root password for Mariadb

Thanks @davidg

the README is also misleading for OVA deployment

https://bitnami.com/stack/redmine/README.txt#:~:text=The%20Redmine%20administrative%20user%20and,its%20password%20is%20also%20bitnami.

Finally figured out that the root password for MariaDB in OVA deployments, is the password displayed in the VM console. Not sure how to change that, but will live with that for now

hi @MasterYoda

Let me review the documentation. Thanks a lot for notifying this this and for your time

Álvaro

hi @MasterYoda

I think that I found the solution. I am going to update the documentation.

If you want to test it, please follow the same steps explained in our guide (section Reset the MariaDB root password) but you need to create the mysql-init file with this content:

ALTER USER root@'%' IDENTIFIED VIA mysql_native_password USING PASSWORD("NEW_PASSWORD");
FLUSH PRIVILEGES;

Using this mysql-init, you will be able to change the root password.

Let me know if you have any problem

Thanks a lot

Álvaro