What is the Mysql default password?

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.test and 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.