I was trying to setup DNS based multitenancy. I already have a system up and running in erp1.example.com. For this a database named ‘erp1’ and mysql user named ‘erp1’ is already in use. While setting up multitenancy, I have one question and one problem.
Question: 1. Do I need a separate database and user for second site in the same bench ?
I tried the command bench new-site erp2.example.com (A records are already set).
It returned the following error: Access denied for user 'root'@'localhost'
I had encountered same error while running other bench commands as well which was solved with the help of friendly forum members, found in this link.
However, it would not be practical to follow the suggestion in the above link for all commands. I don’t think bench commands work that way normally.
The only problem with new site creation is it says Access denied for user 'root'@'localhost' but I have not set any password for root. Pressing enter just does not work. FIY I have used this step by step guide to set up erpnext.