The DB user created by
bench user has the ip of the host as the value for the
I need to change this to
I need to update the host from a script
One way I thought was to login as root and update the host column for the user. But I need to get the username from somewhere.
Question 1 : How can I retrieve the username of the DB user for a site?
Question 2 : Is there any other way to update the Host value?
Thanks in Advance.