hi @pee
Instructions to change the root password for Mysql/Maria-DB:
1.) Stop MySQL service using sudo service mysql stop
2.) Then execute sudo mysqld_safe --skip-grant-table & command to start the mysql in safe mode and [Hit Enter]
3.) After hitting enter execute mysql -u root command. [You don’t need to enter any password here]
4.) New MariaDB console will be open.
5.) On MariaDB Console execute use mysql and hit enter.
6.) Now you can change the root password using UPDATE user SET password=PASSWORD() WHERE user=‘root’; and hit enter.
7.) Exit from MariaDB console using exit command.
8.) Now stop the mysqld_safe service by killing mysqld_safe service using process id.
9.) Ensure you PID of mysqld_safe by executing ps -aux | grep mysqld_safe command.
10.) Again restart your mysql server using sudo service mysql restart
To Verify use mysql -u root -p. if you redirect to mysql/MariaDB console then congrats you’ve changed the password successfully.
NOTE:
You have to stop the mysql_safe service for Installing ERPNext on your system.
If Your System still throwing the same error while installation then try to reinstall Mysql/MariaDB.
NavdeepGhai