GnuCash on Windows with MySQL backend

[Geert Janssens]

On Monday 24 November 2014 15:17:02 Yitzchok Lavi wrote:
> Thanks for your reply
> I made a mistake - it does remember the server name when prompting for
> a password on start. I recall now that in my hunt for a "save
> password" option I tried opening again from a database and it's there
> that the server name resets to localhost. I'm on Windows 8.1.
> 
Ok, I'm glad it works as expected on your system as well.

Unfortunately GnuCash won't save the password on Windows because Windows doesn't 
provide an interface for it.

Geert

> From: geert.gnucash at kobaltwit.be
> To: gnucash-user at gnucash.org
> CC: yl-gnucash- at outlook.com
> Subject: Re: GnuCash on Windows with MySQL backend
> Date: Sun, 23 Nov 2014 10:35:25 +0100
> 
> On Saturday 22 November 2014 17:43:44 Yitzchok Lavi wrote:
> > I am using Gnucash 2.6.3 on both Windows (specifically git rev
> > 166cbb7+) and Linux (maybe it's 2.6.4 on Linux) against the same
> > MySQL database.On Linux I have never had a problem - once I
> > connected
> > to the database I reconnect automatically every time I start the
> > program.On Windows I find that every time I connect I am prompted
> > for
> > the password and also the server name is incorrect (it defaults to
> > localhost). I probably didn't notice this at the beginning because I
> > was having so much trouble with another issue which was an actual
> > bug
> > in GnuCash.Is there a setting which affects this behaviour? I looked
> > on the preferences page and didn't see anything there.ThanksYitzchok
> 
> Hi,
> 
> GnuCash relies on the system to provide a safe store for the database
> password. On linux it uses gnome's keychain on OS X there's the
> system wide keyring. Windows doesn't provide such a safe store system
> wide so on Windows the password is never kept. Indeed that means you
> have to retype it each time.
> 
> When it prompts for the password it should do so with the correct
> hostname and database. And it does so correctly on my test system.
> 
> What is the name of your mysql server ? And the name of the database ?
> Which version of Windows ?
> 
> Geert