What is the Mysql default password?


I have try the Frappe, and after using this command: bench new-site mysite.local

ask me for the MySQL password, but I don’t pass it.

Where can I found these password?


Hi Fellipeh,

frappe_passwords.txt file will be created at the time of installation
You can find Frappe, MariaDB, Administrator Password in this file.
The passwords are stored at ~/frappe_passwords.txt where you install /frappe-bench
You can remove this file after making a note of the passwords.

bench new-site mysite.local
MySQL root password: 'enter Maria DB password here'
Created user  mysite.local
Created database  mysite.local
Granted privileges to user  mysite.local and database  mysite.local
Starting database import...
Imported from database /home/example/frappe-bench/apps/frappe/frappe/data/Framework.sql
Updating frappe                     : [========================================]
Set Administrator password: 'set admin password'
Re-enter Administrator password:  're-enter admin password'
Installing Fixtures...*** Scheduler is disabled ***


This file was not created… I think, bacause when I start: sudo bash ./setup_frappe.sh , in the Installing Frappe-bench… frozen…

Are you able to login in default site?
Frappe will create default site site1.local at the time of installation.

Works here… but… install ERP Next, and I want to build new clean instalation…how can I remove the new site created? Just remove the Folder?

I’m stuck at this problem. I can’t find that file.

can’t find the password :frowning:

I am using the beta production way

wget https://raw.githubusercontent.com/frappe/bench/develop/playbooks/install.py
python install.py --develop

any help? thanks.

@ericmachine88 you must find it in the directory : /root when you use root user…

1 Like

nope, there’s nothing in /root. I am using ubuntu 14.04 LTS desktop.

When I run these commands

wget https://raw.githubusercontent.com/frappe/bench/develop/playbooks/install.py1
python install.py --develop

does it actually install mysql or mariadb? or should I install separately?


This is the raw / beta version in development mode and is full of buggy nets and I don’t recommend it unless for nerdy developers who knows there away around the system…

If your not then use the easy install script :

You can use it in develop mode which is less buggy the the beta version…

So did you mean this one which can be used for development?

wget https://raw.githubusercontent.com/frappe/bench/master/install_scripts/setup_frappe.sh
sudo bash setup_frappe.sh --bench-branch develop

Do i have to install mysql/mariadb separately or the above script will auto install for me?


I mean this one:
wget https://raw.githubusercontent.com/frappe/bench/master/install_scripts/setup_frappe.sh
sudo bash setup_frappe.sh --setup-production

And yes it setups everything for you from a-z

I tried that before, but I wasn’t able to enable developer_mode: 1


i want to learn how to build my own modules

Just install this one and will help you throw the development mode me and everyone else :slight_smile:

1 Like

While running bench new-site library command, it asks for MySql root password.
I tried with frappe and it worked…

For ERPNext VM mysql root password is frappe. If you install ERPNext via easy install script then you will find admin and mysql root password in frappe_passwords.txt

1 Like

Thanks It’s woks

I have ERPNext VM and the mysql root password is frappe.

Thanks again

I am facing the same issue with MySQL root password being wrong on my Mac.

  1. I tried entering frappe as suggested in the first post.
  2. I could not find any frappe_passwords.txt in the directory where I installed frappe_bench using bench init frappe_branch
  3. I could not find any frappe_password.txt in the user root folder ~
  4. I tried entering empty password and my system sudo password

but nothing worked. can someone please help me?

See if there is a passwords.txt file just outside the bench directory.

I tried in the parent directory also, but nothing is present…

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 ‘’ (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.