Save As MySQL is crashing gnucash

[Ian X Waddington]

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.
> 
>                                            

-- 
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