Facing this issue when I create a new site in frappe.
asking MySQL root password. I tried “frappe”, “admin”, “root”, blank
tried re-installing xamp.
still facing the issue
kindly help.

Thanks

Refer to mysql - Access Denied for User 'root'@'localhost' (using password: YES) - No Privileges? - Stack Overflow

One of the solutions from the linked question usually works.

      #IF... this happens....
      #ERROR 1045 (28000): Access denied for user '8de49ae55a02e7ac'@'localhost' (using password: YES)
      DBname=$(cat ~/frappe-bench/sites/site1.local/site_config.json | awk '/db_name/ {print $2}' | sed "s/\"//g" | sed "s/,//g")
      DBpass=$(cat ~/frappe-bench/sites/site1.local/site_config.json | awk '/db_password/ {print $2}' | sed "s/\"//g")
      mysql -uroot -p$MySQLpwd -Bse "GRANT ALL PRIVILEGES ON *.* TO '$DBname'@'localhost' IDENTIFIED BY '$DBpass' WITH GRANT OPTION;"
      mysql -uroot -p$MySQLpwd -Bse "GRANT ALL PRIVILEGES ON *.* TO '$DBname'@'127.0.0.1' IDENTIFIED BY '$DBpass' WITH GRANT OPTION;"
      mysql -uroot -p$MySQLpwd -Bse "set password for '$DBname'@'localhost' = password('$DBpass');"
      mysql -uroot -p$MySQLpwd -Bse "set password for '$DBname'@'127.0.0.1' = password('$DBpass');"
      #delete the DB and re-run
      bench new-site site1.local
              
I know it’s been a time but for my case the solution was to just changing the password by running the following command.
sudo mysql_secure_installation
then, for current password: press enter if you were not set, but if you did, just type the one you used during the installation.
And for the new Password : type your new Password that you will be using from now on wards eve when creating bench site.

That’s it.
              
Run these below commands and then create site
GRANT ALL PRIVILEGES ON . TO ‘root’@‘%’ IDENTIFIED BY ‘your_password’ WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON . TO ‘root’@‘localhost’ IDENTIFIED BY ‘your_password’ WITH GRANT OPTION;
it solved the same issue at our end.