Passwords for MySQL

[charles dandridge]

I experienced the special character issue with a password generator as
well. My work-around has been to set my remote MySQL db to accept local
host connections only. I then setup SSH to tunnel to the server with a RSA
key pair, with SSH not allowing password logins. Then set a very simple (6
plain character) password for the Gnucash sql user. Solves my issue and
beef's up security altogether.
On Wed, Dec 30, 2015 at 2:22 PM John Ralls <jralls at ceridwen.us> wrote:

>
> > On Dec 30, 2015, at 10:37 AM, aeneas <receiver at gowdygroup.net> wrote:
> >
> > It appears as though I also experienced the problem described in  this
> > <
> http://gnucash.1415818.n4.nabble.com/GnuCash-2-4-7-remote-mysql-error-tt3767275.html
> >
> > post.  When using a strong password produced by a password generator I
> > received the error described as -
> >
> > <http://gnucash.1415818.n4.nabble.com/file/n4682184/GNUcashError.jpg>
> >
> > By changing to a simple (6 alphabetic characters) password the error went
> > away.  Insofar as MySQL supports quite complex passwords that may
> include a
> > good variety of special characters, it appears as though this problem has
> > something to do with GNUcash.
> >
> > Therefore, the question becomes, "what password restrictions does GNUcash
> > impose?".  Is this restriction particular to MySQL or possibly a
> consequence
> > of having support also for PostgreSQL?
>
> It probably depends upon the characters your password generator creates.
> GnuCash uses utf-8 for all GUI interactions and the password string isn't
> transcoded, so if MySQL is looking for something else the password won't
> match if it has code points > U+007f.
>
> Any printing ASCII characters should be OK.
>
> Regards,
> John Ralls
>
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>