mysql workbench password not storing

Question

I am trying to create a new database using MySQL Workbench and cannot save a password using the "Store in Keychain" button. I have looked everywhere and no answers have been straightforward. I am trying to access the server using

    Connection connection = DriverManager.getConnection(
            "jdbc:mysql://localhost", "root", "password");

so, I need a password. I tried accessing it without a password, but that did not work. When I open the Workbench and click the "Store in Keychain" button next to Password and enter the password, I follow that up by testing the connection and entering the password. No matter what I do, the password never works. I try clearing it, which then allows me to access it without a password, but that is no good to me. Any help would be hugely appreciated.

Answer 1

I figured it out. Double click on the connection, supply the password to login. Choose Server -> editor/management screen, then go into "Users and privileges", highlight the account and change the password there.