Using Kubuntu 16.10, I'm saving a password into the keyring in MySQL Workbench, checking the "Store password in keychain" checkbox.
It works as long as it's open (doesn't ask for password), but when I re-open the program it prompts for the password again.
Not many people seem to have this problem. It might have something to do with my OS, but I'm not sure.
The vault provides a convenient secure storage for passwords used to access MySQL servers. By using the vault, you need not enter credentials every time MySQL Workbench attempts to connect to a server. The host name is used for storing password information.
MySQL stores credentials in the user table in the mysql system database. Operations that assign or modify passwords are permitted only to users with the CREATE USER privilege, or, alternatively, privileges for the mysql database ( INSERT privilege to create new accounts, UPDATE privilege to modify existing accounts).
Default username is root and there is no password set.
I am using Ubuntu 18.04. Here is a the error I'm seeing:
Solution
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With