login to mysql root
sudo mysql -u root
no password prompt required, if it is using unix socket authentication (used by mariadb provided by distro)
mysql prompt:
use mysql;
update user set plugin='' where User='root';
update user set password=PASSWORD("new password goes here") where User='root';
flush privileges;
exit
it will start working with password authentication.
When the docs say “Install on a clean server”. I now know that means absolutely nothing on the server. I had installed Plesk before I installed ERPNext and it caused issues with root access. I guess because Plesk hijacks the ‘root’ permissions. Making it almost impossible to change my password (My theory).
In the end I was able to install without any issues at all once I removed Plesk, reverted the server to default, and installed ERPNext immediately after.
Now - This brings me to a new issue that I’m looking for help understanding. Is there a way Plesk and ERPNext could live on the same server together or must they be different servers? If not, why? I opened another thread specifically for this - Simple Installation Step Guide
Thanks!