Passwords for MySQL

[John Ralls]

> 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