Root user password reset

This PR relates to issue: #193 
The PR also resolves issue: #196 and #197
This has been one of those paper cut issues that everyone seems to run into (set up console, you think it works but actually it's pointing to preprod...). I suggest that we should rather keep it localhost and find a way to setup preprod so that it uses preprod (with #115 closed we don't really have an excuse anymore :) ). I'll volunteer take a look into that when this merges.