MySQL Workbench fails to store password in vault
The final error message shows the real problem. Your credentials are not correct or the user is not allow to connect. Hence MySQL Workbench asks again for them when you test the connection (as it failed to connect using your stored credentials).