again run below command and set root password to Y
sudo mariad-secure-installation
Still same thing don’t know what is the issue but same error replicated.
Ok I found one more thing. When I connect to mariadb and check the database list I can see this databases list:
But in the log when I check it is trying to connect with this database “_0050c0acd1828574”. So, why it is trying to connect this database? Or do I need to create new database with same name “_0050c0acd1828574” then how?
After provide the database and password manually then get this error:
pymysql.err.ProgrammingError: (1146, “Table ‘mysql.tabSingles’ doesn’t exist”)
I can see there is not table with same name available in the mysql database.
So, now how can I fix all this?
When you create a site in Bench using the bench new-site command, it creates a new database within the mariadb and frappe tries to connect to the same db, and all these configs are saved in your site-config.json file in the sites directory.
In your case, the site is created, but the database is not created for the site. Try the below command and share the output
bench new-site dev.localhost
PS: DM me, let’s not make this thread any longer