Just to record what I have done for the benefit of someone else who might face the same challenge…
Then I tried to set password as per the idea in this thread
mysqladmin -u root -p password 'frappe'
sql - MySQL set root password wrong - Stack Overflow
sql - MySQL set root password wrong - Stack Overflow
- then tried
bench new-site library.testand it was working, but a different error
ERROR 2002 (HY000): Can’t connect to MySQL server on ‘127.0.0.1’ (60)
Table ‘tabDefaultValue’ missing in the restored site. Database not installed correctly, this can due to lack of permission, or that the database name exists. Check your mysql root password, validity of the backup file or use --force to reinstall - Then i tried again
bench new-site library.test - and got another error
in setup_database
raise Exception(f"Database {db_name} already exists")
Exception: Database _e12f97fbea49690f already exists
I did not know why this error comes.
In the end, I gave up trying to install Frappe on my own on Mac.