Save As MySQL is crashing gnucash
Robert Heller
heller at deepsoft.com
Fri Nov 26 09:46:03 EST 2010
At Fri, 26 Nov 2010 07:18:00 -0000 "Ian X Waddington" <iwaddox at gmail.com> 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?
You missunderstand the messages in the archves. MySQL (like most/all
RDBMs) needs to have users and databases *created* by a DB 'super user'
before application client programs can login.
>
> -----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.
> >
> >
>
--
Robert Heller -- 978-544-6933 / heller at deepsoft.com
Deepwoods Software -- http://www.deepsoft.com/
() ascii ribbon campaign -- against html e-mail
/\ www.asciiribbon.org -- against proprietary attachments
More information about the gnucash-user
mailing list