Save As MySQL is crashing gnucash

[Wouter van Marle]

I think you're misunderstanding the manual (and how MySQL works). I've
worked a bit with MySQL so I can give you some general advice there.

As Robert already said: you will first have to create a MySQL login for
GnuCash, set a password for it, and give it appropriate permissions.
Otherwise GnuCash can never connect to the MySQL server in the first
place. And of course GnuCash can not create this user by itself!

When this username is registered in your MySQL server, GnuCash will be
able to connect to the server and do its work - including creating the
gnucash database with all required tables and fields on the first run.

How to create the user I forgot, please check the MySQL manual. It's
quite simple.

Wouter.


On Fri, 2010-11-26 at 07:18 +0000, Ian X Waddington wrote:
> Thank you, the entries in the archives suggest that a save as in gnucash
> changing the type to mysql would create a database of name gnucash with the
> user id and password I had entered.
> 
> Is this now not the case?
> 
> -----Original Message-----
> From: Robert Heller [mailto:heller at deepsoft.com] 
> Sent: 26 November 2010 00:02
> To: Ian X Waddington
> Cc: gnucash-user at gnucash.org; Robert Heller
> Subject: Re: Save As MySQL is crashing gnucash
> 
> At Thu, 25 Nov 2010 22:59:47 -0000 "Ian X Waddington" <iwaddox at gmail.com>
> wrote:
> 
> > 
> > Hi
> > 
> >  
> > 
> > On a Windows 7 machine I am running gnucash 2.3.17 and have just 
> > installed MySql 5.1.53
> > 
> >  
> > 
> > When I select file-save-as (with a new blank file of an existing test 
> > file) I get the MySQL form to fill in and choose localhost, gnucash, 
> > (made up userid), (made up password) - gnucash immediately crashes and 
> > windows 7 tells me I've had an APPCRASH in libgncmod-backend-dbi.dll
> 
> made up userid, made up password ?
> 
> You can't just 'make up' a username and password.  You need to login to
> mysql as the root user and create a username with a password.  You probably
> also need to create a database (named gnucash I presume). 
> Under Linux/UNIX one would fire up the mysql command from a shell with the
> root user and password. I believe a *fresh* install leaves the root user
> with no password (which really should get changed as the first post install
> step).  Creating users and databases is covered in the MySQL reference
> manual.
> 
> > 
> >  
> > 
> > I've search the list archives but could not find anything that seemed 
> > relevant so I would be grateful for any help or suggestions
> > 
> >  
> > 
> > Regards
> > 
> > _______________________________________________
> > 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.
> > 
> >                                            
>