ERPNext Conference 2019* ERPNext.com Blog

New-site sets db user host


#1

When I create new site with bench new-site it creates a new user and database in mariadb. Unfortunately, it also sets the host of the new user to the current IP address of the bench. If I change the IP address of the server for any reason I will then be unable to reconnect to the db as that user (access denied). This is very troublesome on container infrastructures where the IP address may change frequency.

Would this be considered a bug? Is there a way for new-site to not set the host in db for the new user?


#2

I’ve went ahead and opened an issue for this: https://github.com/frappe/frappe/issues/8021