Passwords for MySQL

[charles dandridge]

I'm running Mariadb on a small Synology Nas (which is basically a stripped
down version of Linux) as my server and a Windows 7 laptop as my client. I
think the shared hosting is a big hurdle for SSH. Another alternative is to
spin up an Amazon ec2 instance where you would have full root access
without the overhead of hardware costs.
On Thu, Dec 31, 2015 at 12:57 PM John Ralls <jralls at ceridwen.us> wrote:

>
> > On Dec 31, 2015, at 9:17 AM, aeneas <receiver at gowdygroup.net> wrote:
> >
> > John, your reply has provoked another thought.
> >
> > I created a MySQL database for experimentation purposes on my own
> computer
> > even though I foresee use of MySQL on my hosting service as one big
> reason
> > for using MySQL which carries with it a reason for using GNUcash.
> >
> > When I created the schema, for GNUcash, using phpMyAdmin on my own,
> xampp,
> > system it allows for specifying collation.  I opted for utf8_unicode_ci
> for
> > no particular reason other than believing (?) this to be fairly benign.
> > When I go back and look at the DB created by GNUcash I notice that all of
> > the tables have latin1_swedish_ci as the collation.  There was never
> > anywhere for me to specify a preferred collation within GNUcash.
> > Furthermore, I also notice that the phpMyAdmin on my hosting service
> > indicates that the server connection is using utf8_general_ci.  What is
> the
> > rationale for GNUcash to use latin1_swedish_ci?  Is this universal or do
> I
> > just need to know how to manipulate the setting?  Possibly you know,
> better
> > than I, why this either may or may not matter.
>
> It's the default for MySQL. GnuCash sets the character set but not the
> collation. I don't think that it actually matters; most of the primary keys
> are GUIDs and therefor in the character range A-F0-9, which will sort the
> same for either. If it really bugs you, change the default for the server:
> https://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_collation_database
>
> 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.
>