Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

MySQL Workbench not saving passwords in keychain

Tags:

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.

like image 458
JoseHdez_2 Avatar asked Mar 08 '17 12:03

JoseHdez_2


People also ask

Where does MySQL Workbench store passwords?

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.

How does MySQL store passwords?

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).

What is the default username and password for MySQL Workbench?

Default username is root and there is no password set.


1 Answers

I am using Ubuntu 18.04. Here is a the error I'm seeing:

pic of the error

Solution

  1. Go to Ubuntu software center.
  2. Search for MySQL workbench community.
  3. Click on permission
  4. Enable Read, add .... to on
like image 171
Martín Mori Avatar answered Oct 12 '22 23:10

Martín Mori