Where can I get My sql root password?

1

Hello !!

I am restoring my backup but while taking backup it asks for My SQL root password.
How to get a Database password?

I am using ERPNEXT on bitnami stack.

2

Hope this will help.

change mariadb password

sudo /etc/init.d/mysql stop

sudo mysqld_safe --skip-grant-tables &

mysql -u root

use mysql;

update user set authentication_string=PASSWORD(“admindb”) where User=‘root’;

flush privileges;

quit

sudo /etc/init.d/mysql stop

sudo /etc/init.d/mysql start
1 Like