You may come across times where you need to reset the password of a database user.
First, you must create an SSH key, and be able to successfully login to your server as root. There are guides in the KB on how to generate this key on both Windows and Mac workstations.
Once you login, run the following GPCLI command “gp mysql get-pass root”. This will show you your root sql password.
Then follow this guide to connect via MySQL Workbench: https://gridpane.zendesk.com/hc/en-us/articles/360033232672-Connect-a-desktop-MySQL-client-with-a-database-by-SSH-as-root
In addition to your SSH key, you would use the root sql user and password you pulled above.